check on http://www.esnips.com

you can add group by contact it will display the 3 record or delete the existing group.

give the page break after summary.

Is this work for you?

Don't look into the TSQL just focus on the data it's returning. I just want to explain, you have to format the TSQL which will return the record set in...

use the given below TSQL

select 'Asia' as 'RegionName','ApplesSold' AS ROW, '100' as SoldVALUE

union

select 'Asia' as 'RegionName','OrangesSold' AS ROW, '200' as SoldVALUE

union

select 'Africa' as 'RegionName','ApplesSold' AS ROW, '10' as SoldVALUE

union

select 'Africa'...

create a datasource and point the report dataset to created data source. Based on server information set in datasource report will pull the data from specified server.

yes, it is possible using matrix report. but if no. of column is fixed then why go with the matrix instead of table report.

There is no strange in this procedure. First you creating the proc and altering the logic using Execute SQL statement. then you are calling the procedure and then droping it.

as...

you are not allowed to use the RAND() function inside UDF function. To call the value of this function create a view with the single statement select RAND()

And then call...

Use the print statement to cross verfiy your condition

and

check the alternate for your SP

create Proc [dbo].[CsaWise Cust List1]

...

create temp table usign Identity column and then fill the data into this temp table.

Now you have the seq. data into the temp table, now it's time to update the...