This is so simple, but I can't get it to work. I created a grouping on the name field so that all entries for a particular person are on their own page. I break out perfectly so each one is a page for where I should get rows for that one person I only get one. On no page do I see more than one row. The data is not being summarized so that does not explain it.
Why would I lose data row? Thanks!
Hi,
I have a table with five groups in sql server reporting service. If i give a page break at end in each group and deploy the report the report is fine when viewed in the report viewer(UI).
But when i export it to a PDF i get the Groups footer is a separate page. How can i get the PDF file same as it appears in report viewer.
Thanks in Advance.
SM.
The last page of the report has a table or rectangle (tried both) which is supposed to be invisible based on a parameter. However, the page still shows up with only the header! Apparently the report knows that the next element (table or rectangle) has to be on a new page, and only too late figures out that the element is invisible.
Anybody else encountered this, or has a solution?
Thanks
Hi all. My name is Guilherme and I'm a Braziliam software developer.
I've installed on my computer all the software required to work with MS SQL RS. I log on this computer using my domain user. and a few days ago i needed to change my password (network policy)
Now, when I open the adress http://localhost/reports on my computer, I can't see the installed reports, neither the configuration page.
What should I do?
Thanks in advance.
Like the subject says I have tested the SP in Gridview. Everything looks fine. But when run nothing shows up on the page.
I have tried using QueryStrings to pass the data and Controls.
Here is the Gridview Code:<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
BackColor="White" BorderColor="#3366CC" BorderStyle="None" BorderWidth="1px"
CellPadding="4" DataSourceID="SqlDataSource1">
<FooterStyle BackColor="#99CCCC" ForeColor="#003399" />
<RowStyle BackColor="White" ForeColor="#003399" />
<Columns><asp:BoundField DataField="FirstName" HeaderText="FirstName"
SortExpression="FirstName" /><asp:BoundField DataField="LastName" HeaderText="LastName"
SortExpression="LastName" /><asp:BoundField DataField="EthnicID" HeaderText="EthnicID"
SortExpression="EthnicID" /><asp:BoundField DataField="Gender" HeaderText="Gender"
SortExpression="Gender" /><asp:BoundField DataField="Height" HeaderText="Height"
SortExpression="Height" /><asp:BoundField DataField="Weight" HeaderText="Weight"
SortExpression="Weight" />
<asp:BoundField DataField="Hair" HeaderText="Hair" SortExpression="Hair" />
<asp:BoundField DataField="Eyes" HeaderText="Eyes" SortExpression="Eyes" />
<asp:BoundField DataField="City" HeaderText="City" SortExpression="City" />
<asp:BoundField DataField="State" HeaderText="State" SortExpression="State" />
</Columns>
<PagerStyle BackColor="#99CCCC" ForeColor="#003399" HorizontalAlign="Left" />
<SelectedRowStyle BackColor="#009999" Font-Bold="True" ForeColor="#CCFF99" />
<HeaderStyle BackColor="#003399" Font-Bold="True" ForeColor="#CCCCFF" />
</asp:GridView>
Here is the Datasource:<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:SQL2005_311004_modelsystemConnectionString %>"
SelectCommand="spSearch" SelectCommandType="StoredProcedure">
<SelectParameters><asp:QueryStringParameter DefaultValue="" Name="FirstName"
QueryStringField="fn" Type="String" />
<asp:QueryStringParameter Name="LastName" QueryStringField="ln" Type="String" />
<asp:Parameter Name="EthnicID" Type="String" />
<asp:Parameter Name="Gender" Type="String" />
<asp:Parameter Name="Height" Type="String" />
<asp:Parameter Name="weight" Type="String" />
<asp:Parameter Name="Hair" Type="String" />
<asp:Parameter Name="Eyes" Type="String" />
<asp:Parameter Name="City" Type="String" />
<asp:Parameter Name="State" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
I hope you can help me with this one!!!
HI
Has anyone figured out how to reset the page numbers after a grouping and have it display in the format €˜Page X of Y€™? I can get it to reset the page number for each group and display €˜Page X€™ but it€™s the €˜of Y€™ part that is a problem.
Thanks,
I have a SQL Agent job that runs at 4:15 in the morning. The job has 5 steps, each step only runs if the preceding step succeeds. The second step, which calls an SSIS package that does the main processing, appears to finish as it goes on to the next step; however, when looking in 'View History' there are 2 entries for this step - the first one shows it as still running (Circled Green Arrow) but with a start and end time. The second entry says the job succeeded.
I have been seeing conflicts, such as deadlocks, with later jobs. I suspect this job is causing the conflicts - maybe the package is still running in the background instead of having actually completed?
what conditions a job step my be showing in the job history as both running AND completed successfully?
Have anyone came across an issue with Reporting Service 2005 where if you had more than 1 group within a table and the first group has the property 'Page Break at end' checked - this will cause a page break after the group footer was printed.
Usually this is not an issue but consider this scenario - the 'Page Break at end' is set against the second group (not the first group which show the overall total) - when the last footer was printed for the second group, this cause a page break before the first group (overall) is printed - it seem to me that Reporting Service is not able to know when not to generate a page break if there isn't any more data - more importantly - there dosen't appear to be a way to set an expression against 'Page Break at end' within the group
Does anyone know of this issue and is there a workaround it?
Example: A sales report that details and summarizes each Salesperson’s total sales within a company’s stores that reside in each state.Â
The report has 3 levels of groupings where the highest 2 levels require summary counts on a separate page and the lowest level produces a summary count in the midst of the detail lines of the report.
The data consumed by the report is ordered by State, Store ID, and Salesperson.Â
The header of each page lists the State and Store ID. The detail lines of the report list items sold and the associated sales amount for each item sold by each store’s salesperson.Â
At the end of each Salesperson’s items sold, a summary line is listed on the next line in the report showing the total amount and total count of items sold by that Salesperson.Â
The very next line on the report lists items sold and the associated sales amount for the next Salesperson within that particular store.Â
Summary lines will be produced for each Salesperson within each particular store on the next line of detail in the report.
At the end of all sales data for each store, a summary page is produced on a separate page listing the summary of each Salesperson’s totals.Â
Each line of the summary page contains the same counts for each Salesperson that was embedded in the detail section of the report.Â
The summary page also contains a grand total line listing the total count and sales for all salesmen within each given store.
At the end of all sales data for each state a summary page is produced on a separate page listing the summary of each store’s totals.Â
Each line of the summary page contains the grand totals of all sales for each store within a given state.Â
The summary page also contains a grand total line listing the total count and sales for all stores within each given state.
The simple breakdown is the groupings and totals for each state and store must be listed on a separate page in the report.Â
The grouping and totals for each Salesperson must be listed on the next line within the detail section of the report.Â
Current issue: The requirement is for no page break at the end of each salesperson’s sales data because the page breaks produce too many extra pages in the report.Â
Disabling the page break at the Salesperson level produces format issues such as page headers printing on the next line in the report before each Salesperson’s summary line.Â
Disabling the page breaks at this level also produces the problem of suppressing the page break for the summary page that comes at the end of each store.
Question:The report has 3 levels of grouping with Salesperson at the lowest level, Store ID being the parent group of Salesperson, and State being the parent group of Store ID. Is it possible to format the Salesperson summary line (lowest level grouping) as just another detail line in the report without impacting the report format that requires page breaks at the parent group levels?
A sample report layout of what we are trying to achieve is on the next page.
Â
Sales Report
State: Alaska                        Â
Store ID: 100
Item Sold              Â
Sales Amount
Hammer               Â
$10.00
Saw                       Â
$15.00
[Code] .....
I have a dataset for report builder 3 that has 8 fields. The data for the report needs to be grouped by the first field. The 2nd field is a string that describes the group field and this too needs to be on the same row as the group field. This 2nd field need nearly the full page width. The remaining 6 fields need to end up rendering below the first row. I can't figure out how to get report builder to put the first 2 fields on the first row and use the full page width.
View 0 Replies View RelatedSSRS 2008 R2
I have two level of grouping  Example:
:::HEADER::: Â Â Â
A [GROUPING 1]
B[GROUPING 2]
C[GROUPING 2]
When I apply Page Break
:::HEADER::: Â Â Â
A [GROUPING 1]
        B[GROUPING 2]
:::HEADER::: Â Â Â
A [GROUPING 1]
        C[GROUPING 2]
[URL]
We are facing problem in doing page break with column grouping. Our column group contains years e.g 2011, 2013 . We want to show a complete page for a year.Â
Suppose 2011 has 10 records(horizontal) and 2013 has 12 records(horizontal) in column. The output should be 10 records of 2011 in first page, 12 records of 2013 in second page.
We cannot change the report layout to make column to row and vice versa.
Hi,
I created one blank ADP to connect default tempdb database on MSDE on server ASHFAQUEPC (name of my msde server). Tested the connection was successful.
I created a table called Testtable from command prompt (MSSQL/Binn) in default tempdb of MSDE using following lines:
…Binn>osql/U sa mypassword
1> use tempdb
1> go
1> Create table Testtable (Cnum integer NOT NULL PRIMARY KEY, City Varchar(15))
1> go
Table Created successfully then I added 2-3 records using following lines;
1> INSERT INTO testable (cnum, city)
1> values (1, ‘abc’)
1> go
1 Record affected and I did same to add 2-3 more records. Then I used following lines to see all the records I entered.
1> select * from testable
1> go
And a list of records displayed at command prompt. After exit from command prompt I found a ‘Testtable’ appeared in the above ADP.
But next day when I opened my pc and opened ADP, I did not found the Testtable even though I re-connected to tempdb on MSDE from File menu. I reached then to command prompt to see whether the table itself is existing. Strange it was not there.
Can somebody tell me how can I get connected to testable automatically when I open my ADP? Where might have gone wrong? Do I need to create table again and input records?
I want to make sure before I do anything with my real dbs.
Any help would be highly appreciated.
With kind regards,
Ashfaque :confused:
I have a table which has a blank as owner name when I see on Enterprise manager. Sp_changeobjectowner is not working on this to change the owner name to dbo.I am still able to create another table with same name under dbo.But I want to get rid of the table which has no ownername. When i run the drop table command it doesn't drop that!!It says invalid object!!Any help!!
thanks,
Di.
How could I create a table that shows the month, each day in that month and the year and give me the option to set a start date & and end date? This is sql server 2005. I have used this before, but it doesn't allow me to see the days in the month. Essentially I want my output to be
Day Month Year
01-01-2012 January 2012
.......
01-02-2015 January 2015
.....
03-01-2015 March 2015
....
08-02-2020 August 2020
Code:
CREATE TABLE #yourTempTable([MonthName] VARCHAR(9), [Year] INT);
WITH CTE(N) AS (SELECT 1 FROM (SELECT 1 UNION ALL SELECT 1)a(N)),
CTE2(N) AS (SELECT 1 FROM CTE x CROSS JOIN CTE y),
CTE3(N) AS (SELECT 1 FROM CTE2 x CROSS JOIN CTE2 y),
TALLY(N) AS (SELECT 0 UNION ALL
SELECT TOP 11 ROW_NUMBER() OVER(ORDER BY (SELECT NULL))
FROM CTE3),
DATETALLY(N) AS (SELECT DATEADD(month, DATEDIFF(month, 0, GETDATE())+N, 0)
FROM TALLY)
INSERT INTO #yourTempTable
SELECT DATENAME(month,N), YEAR(N)
FROM DATETALLY;
SELECT *
FROM #yourTempTable;
The following objects are placed on the Report body of the Report pane of SQL Server 2005 Reporting Services :
<textbox: expression1>
<textbox: expression2>
<table:table1 with at least 30 columns and 30 expressions>
<textbox: string1> - considered as the Title in the Footer section of the report
<texbox:string2> <textbox:expression3>
<textbox:string3> <textbox:expression4>
<textbox:string4> <textbox:expression5>
<textbox:expression6>
I can't find any explanation why is it string1 and string 2 of the footer section of my report displayed separately from the expression3 which is aligned on it and the rest of the object on the second page.
The expected design is that all Footer items should be displayed together of whether it is placed on the first page or on the last page.
As a workaround of this, I converted string 1 into an expression (Added = and enclosed the string with double quote).. As a result, all of the items in the Footer section are now placed together on the last page of the report.
I also remember one of the issue I encountered before where the Footer items where placed together on the first page and still have space at the bottom of the page, but then expression 6 is forced to display (alone) on the last page of my report.
I can't find any discussion related to this, I wish somebody could give me an idea why RS behaved like this.
Thanks in advance
Fit an intere table in same page without page break for save the excel export.
My table has a Group for order my dates.
I need to have the intere table in the same page, i don't care about blank space at the end of the page.
I can't use the page break beacuse i need an excel export in a unique sheet..
I have tested.. every page break..you'll have a different sheet in your excel export
I need something like this
page 1
Zone
1
2
3
4
5
6
7
7
8
9
..
page 2
Zone
1
2
3
4
5
6
7
7
8
9
..
but an unique sheet in the excel export
Hi,
I issued this command on Tempdb but it doesnot shrink the file.
dbcc shrinkfile (tempdev_3,1)
go
Messages:
-----------------------------------------------------------------------------------------------------------
DBCC SHRINKFILE: Page 4:11283400 could not be moved because it is a work table page.
-----------------------------------------------------------------------------------------------------------------------------------------------
I have checked that there are no tables associated with any user in tempdb. Any help is appreciated.
Regards,
Razi
How can I print a field that is in the dataset on each page? I added a textbox in the Page Header and use =Fields!ProjectName.value in the value property. I got an error "Fields cannot used in page header and footer."
How can I have the table header shows on each page? Currently if the data goes to the second page, there is no table header.
Thanks.
DanYeung
when insert a multiple line string value into a field it display with two squares when open table.
insert into temptest (test,refdetails,cardno)values('test1','this is first line
and second line
and third line',
'23243')
this record shows in the database with squares for enter key. how to replace these squares with space?
pat
this is first line and [][]second line [][]and third line
hai guys,
i have written a stored procedure which creates a table ex:
USE PUBS
GO
IF EXISTS (SELECT * FROM SYSOBJECTS WHERE NAME = 'RC_STRPROC')
DROP PROCEDURE RC_STRPROC
GO
USE PUBS
GO
CREATE PROCEDURE RC_STRPROC
(@TBLNAME VARCHAR(35), @COLVAL1 VARCHAR(35), @COLVAL2 VARCHAR(35))
AS
IF EXISTS (SELECT * FROM SYSOBJECTS WHERE NAME = '@TBLNAME')
DROP TABLE @TBLNAME
CREATE TABLE @TBLNAME
(@COLVAL1, @COLVAL2)
GO
it gives an syntax error at '@tblname'
can u guys tell me the problem
thanks
hiss
My DB contains company names repeating themselves several times (in the same column).
Can I create a new table that shows only the distinct names, and use it to work with the data?
My intention is to allow my users to choose only from the options within the DB (mimic in a way the list validation option in excel)
In my report i would have 2 groups.
The first group should cause a real page break, the secound group should cause a column break.
Any idea on how to realize this, i've been playing with quite some settings but .....
So, any help ...
I have a report where in I want to show each record on a separate page.
So, to achieve that I took a single cell from table control, expanded it and used all the controls in that single cell. This looks nice so far.
Now, I also have to show a sub grid on each record. So I took a table control and added on the same single cell and tried to add a parent group to the table row.
When I preview, it throws this error.
"The tablix has a detail member with inner members. Detail members can only contain static inner members."
What am I doing wrong? How can I achieve table grouping inside a table cell?
Your help on this could make my day a better one ....
I was trying to create groups on a table report item in SRS 2005 report. The criterion I'm using in one group is exact opposite of the criterion I have in the next group. My dataset has records which fulfill both criteria but my table displays only records for the first group.
Is there a limit on the number of groups we can use in SRS reports and/or on building criteria for filters?
Thanks,
Samtadsh
I€™m trying to group records that are in two collections and assign a Master Id. For example:
Example Base Table:
Collection Number Customer Id
--------------------------- -----------------------
3000001 244517
3000001 244518
3000002 244517
3000002 255519
3000002 244518
3000003 255520
3000004 266660
€¦
€¦
Since Customer Id 244517 is in collection 3000001 and 3000002 I want to group all customers in both collection and assign one master id. For example:
Example Results:
Collection Number Customer Id Master Id
--------------------------- ----------------------- --------------------------
3000001 244517 1
3000001 244518 1
3000002 244517 1
3000002 255519 1
3000002 244518 1
3000003 255520 2
3000004 266660 3
€¦
€¦
I€™m not sure how to perform this, can anyone direct me?
Hello all,
I have a problem in a report that must list agents with some extra info.
First of all, my query that i use, returns the following data:
AgentId, AgentAccount, AgentFN, AgentLN, AgentInfo, AgentGroup, TeamId, TeamDescription, SkillsId, SkillDescription, LanguageId and LanguageDescription.
My report should look like this in fully extended (drilled down)
--------------------------------------------------------------------------------------------------------------------
Account Lastname Firstname Info #Teams #Skills #Languages
--------------------------------------------------------------------------------------------------------------------
Uk
+ 101 xyz abc xxx 3 2 4
+ Team info
Team 1
Team 2
Team 3
+ Skill info
Skill 1
Skill 2
+ Language info
EN
FR
ES
DU
+ 102 xyy acd xxx 1 3 2+ Team info
Team 1
+ Skill info
Skill 1
Skill 2
Skill 3
+ Language info
EN
ES
Initial is should look like this:
--------------------------------------------------------------------------------------------------------------------
Account Lastname Firstname Info #Teams #Skills #Languages
--------------------------------------------------------------------------------------------------------------------
Uk
+ 101 xyz abc xxx 3 2 4
+ 102 xyy acd xxx 1 3 2
BXL
+ 105 ddd abc xxx 4 8 3
+ 106 rrr acd xxx 3 4 2
When i then would click on the agent detail it should look like this:
--------------------------------------------------------------------------------------------------------------------
Account Lastname Firstname Info #Teams #Skills #Languages
--------------------------------------------------------------------------------------------------------------------
Uk
+ 101 xyz abc xxx 3 2 4
+ Team info
+ Skill info
+ Language info
+ 102 xyy acd xxx 1 3 2
BXL
+ 105 ddd abc xxx 4 8 3
+ 106 rrr acd xxx 3 4 2
+ Team info
+ Skill info
+ Language info
This far i was only able to display the report with one subitem per agent.
So what i want to display is when you click on the agent the 3 subitem titles apear (team info, skill info, language info) but without the details. When you then click on one of the 3 sub items, the details should apear.
Could anyone help me out a bit ??
Greetings
V
I'm really stumped on this one. I'm a self taught SQL guy, so there is probobly something I'm overlooking.
I'm trying to get information like this in to a report:
WO#
-WO Line #
--(Details)
--Work Order Line Detail #1
--Work Order Line Detail #2
--Work Order Line Detail #3
--Work Order Line Detail #etc
--(Parts)
--Work Order Line Parts #1
--Work Order Line Parts #2
--Work Order Line Detail #etc
WO#
-WO Line #
--(Details)
--Work Order Line Detail #1
--Work Order Line Detail #2
--Work Order Line Detail #3
--Work Order Line Detail #etc
--(Parts)
--Work Order Line Parts #1
--Work Order Line Parts #2
--Work Order Line Parts #etc
I'm unable to get the grouping right on this. Since the line details and line parts both are children of the line #, how do you do "parallel groups"?
There are 4 tables:
Work Order Header
Work Order Line
Work Order Line Details
Work Order Line Requisitions
The Header has a unique PK.
The Line uses the Header and a Line # as foreign keys that together are unique.
The Detail and requisition tables use the header and line #'s in addition to their own line number foreign keys. My queries ends up looking like this:
WO WOL WOLR WOLD
226952 10000 10000 10000
226952 10000 10000 20000
226952 10000 10000 30000
226952 10000 10000 40000
226952 10000 20000 10000
226952 10000 20000 20000
226952 10000 20000 30000
226952 10000 20000 40000
399999 10000 NULL 10000
375654 10000 10000 NULL
etc
Hierarchy:
WO > WOL > WOLD
WO > WOL > WOLR
It probobly isn't best practice, but I'm kinda new so I need some guidance. I'd really appreciate any help! Here's my query:
SELECT [Work Order Header].No_ AS WO_No, [Work Order Line].[Line No_] AS WOL_No,
[Work Order Requisition].[Line No_] AS WOLR_No, [Work Order Line Detail].[Line No_] AS WOLD_No
FROM [Work Order Header] LEFT OUTER JOIN
[Work Order Line] ON [Work Order Header].No_ = [Work Order Line].[Work Order No_] LEFT OUTER JOIN
[Work Order Line Detail] ON [Work Order Line].[Work Order No_] = [Work Order Line Detail].[Work Order No_] AND
[Work Order Line].[Line No_] = [Work Order Line Detail].[Work Order Line No_] LEFT OUTER JOIN
[Work Order Requisition] ON [Work Order Line].[Work Order No_] = [Work Order Requisition].[Work Order No_] AND
[Work Order Line].[Line No_] = [Work Order Requisition].[Work Order Line No_]
I am trying to optimize a stored procedure in SQL 2008. Â When I look at an actual execution plan generated from when I run it in SSMS it shows a table being used in the plan that has no relation to what is actually in the query script and this is where the biggest performance hit occurs.
I've never seen a table show up before that wasn't part of the query. why this might occur and how to correct it? Â I can't just change the query script because the table in question isn't there.
SQL Server 2008.
From individual event logs I have generated a table where arrivals and departures at a location are registered per device. As there are multiple registration points, there might be multiple consecutive registrations per location.
If this is the case I need to filter those out and have one registration per location and in the result I need to get the earliest arrival and the latest departure of these consecutive rows.
Part of the table:
logIDdeviceIDArrivedDepartedLocationIDGrp1Grp2Grp
3485441082013-02-07 17:51:05.0002013-02-07 17:51:15.0005110
3492041082013-02-07 17:51:15.0002013-02-07 17:51:26.0005220
3500241082013-02-07 17:51:27.0002013-02-07 17:51:37.0003312
3508941082013-02-07 17:51:41.0002013-02-07 17:51:54.0004413
[Code] ....
So as long the field LocationID is the same in the next row, it needs to be grouped.
I have added the rows Grp1, Grp2, Grp in an attempt to get an unique grouping number with the following script in the select statement:
,ROW_NUMBER() OVER(PARTITION BY DeviceID
ORDER BY logID) AS Grp1
,ROW_NUMBER() OVER(PARTITION BY DeviceID, LocationID
ORDER BY logID) AS Grp2
,ROW_NUMBER() OVER(PARTITION BY DeviceID
ORDER BY logID)
-
ROW_NUMBER() OVER(PARTITION BY DeviceID, LocationID
ORDER BY logID) AS Grp
By subtracting Grp2 from Grp1 (Grp = Grp1 - Grp2) I hoped to get an unique group number for each set of equal consecutive locations, however the Grp2 column does not restart from 1 each time the LocationID changes: Grp2 in line 7 should have been 1 again, but it is 2 because this is the second row with LocationID = 3 in the list.
I have a table that will always return 6 records. I would like to group the table, such that the first 3 records, are GROUPED Together first, do the sub-total on these 3 records first. Then the last 3 records are grouped together. and then the sub-total on the last 3 records. Is there a way I can do that in SSRS 2005?
View 3 Replies View RelatedI have constructed my main report using the table item from the toolbox. In maintable I have two groupings.
In the maintable I have grouping2 set for a page break after each grouping.
I have set the subreport parameter to the field value of the maintable grouping2.
I want to display the contents of the subreport after grouping1 of the maintable on the same page.
I have achieved a result by placing the subreport in maintable_group2 footer. However when I save it as an excel sheet it says "Subreports within table/matrix cells are ignored".
I really don't like how the report displays like this in the report server however I will need to export this report to excel.
Have I explained my issue well enough?
I have a table with couple of hundred thousand records, i have added a new column to the table named MD_Group.
Now i need this column populated, so that every 10,000 row set in that table gets a numeric (incremental number) assigned starting from 1.
So the first 10,000 rows will have MD_Group = 1, next 10,000 rows will have MD_Group = 2 , next 10K MD_Group = 3 etc.
For testing purpose here is a results table with total of 11 rows where we want data grouped every 3 rows.
MD_Group
CustomerNumber
AmountBilled
1
12
15243
1
1231234
15243
[code]....
-- Create Sample Table
Declare @GroupRelation_Test TABLE (
MD_Group [varchar](20),
CustomerNumber [varchar](20) ,
AmountBilled [varchar](20) ,
[code]....
-- Test data
INSERT INTO @GroupRelation_Test
( CustomerNumber, AmountBilled,MinAmounttBilled)
SELECT'12','15243','' UNION ALL
SELECT'1231234','15243','' UNION ALL
SELECT'463','15243','' UNION ALL
SELECT'442','15243','' UNION ALL
[code]....