Ninja's_RGR'us,

We have a table with each patient record where they can have multiple opeation code (up to 15 operation). it has to be in a separate column as most of...

GSquared,

I hate myself for not thinking this. It is one of the best solution. There must be other alternative where i can Unpivot it and then write the select statement....

We have to have a separate column for each operation code. Any patient can have more than one operation and all listed from operation 1 to operation 14. It is...

Thanks for the feedback.

It seems it helps if experience developer or DBA share their knowledge of real time problems and how to speed it up queries etc.

I got the solutions....

-- Create a test table

CREATE TABLE [TESTSTATS]( intKey INT, x FLOAT, y FLOAT)

-- Populate the test table with random data

DECLARE @intCount INT

SET @intCount = 1

WHILE @intCount <...

If i understood this right then you can create a dataset and write the t-sql query to count(*) the test and show it in the textbox....if it is not the...

You need to use case statement instead of If.

SELECT dbo.tblWorkDocu.WorkID, dbo.tblWorkDocu.LastEditOn,

case when DATEDIFF(day, tblWorkDocu.LastEditOn, tblWorkDocu.CreatedOn) = 0 then 'New' else 'Edited' end as aaa

FROM dbo.tblWorkDocu;

Hope it helps.

i use following link:

http://www.mssqltips.com/tip.asp?tip=1145

You need to check the dateformat in the date time field you are using. If it is ymd then set on top before running t-sql statement to

set dateformat ymd

if...

You can do this using data driven subscription in reporting services.

Let me give you an example.

I have different branch details in my database with manager assigned to each...

If you are using stored procedure then you can format your parameter (start id and end iD) as you like and then use into SQL code.

did you check the dataset assigned to the table itself? it might be that table is having different dataset.

you can create parameter in report with start date and end date and type should be date time. Then you pass that parameter into your stored procedure and get the...

Yes with simple subscription it will happen. You need to use data driven subscription where you can write query to find out if there is any record available to sent....

does it mean you want to show it from 1st march 2008 to 30th june 2009?

When you get the parameter into the stored procedure then get the month and year...