Can I post image from my local PC?

This is very good poster to have. I think this is what happens after a query plan is created. I am looking for sql engine components that are involved in...

i got 64 rows with your query.

It worked, I had to add distinct to select.

I am going to try using pivot.

Thanks for your help.

Sorry for not reading your message properly.

I have a report which has days of a given month as columns. Each client will have row and his schedule_date will be marked...

Below SQL gives me 32 rows only. I am looking for 62 rows , 31 rows - one day per client for entire month. client-id 301 should have 31 days...

Does this help???

table variables provide the following benefits:

A table variable behaves like a local variable. It has a well-defined scope. This is the function, stored procedure, or batch that...

Here is more informaiton on this issue

http://cf-bill.blogspot.com/2007/01/sql-server-order-view.html]

Here is example of what I am looking for

--Here is sample view definition

create view individual

select person.first_name as FirstName

,person.last_name as LastName

,address.street1 as Address1

,address.street2 as Address2

,city.name as City

From person

left join [address] on...

To explain more about the situation, above mentioned T-SQL issue is one among 10-15 complex data issues with in a single stored proc. I know I can go with T-SQL...

Thanks for your comments.

I did solve above issue and got stuck with other. As I have tight production deadlines, I am going for cursor in a stored procedure.

Correct me if I am wrong.

1) we need to handle double quotes before passing it into stored proc / executing stored proc?

Thanks:)

THANKS FOR THE SQL. IT HELPED ME A LOT.

create table t1(

id int identity

,client_id int

,status varchar(10)

,date1 datetime)

insert into t1 values(100,'admit', '2007-1-1')

insert into t1 values(100,'discharge', '2007-2-1')

insert into t1 values(200,'admit', '2007-1-1')

insert into t1 values(200,'discharge', '2007-2-1')

insert into t1 values(300,'admit', '2007-1-1')

insert into t1...