This is weird. I was in a hurry so I did not explain the situation properly. I had a variable that I defined as varchar(3000), but today it turned out...

Hello All,

I ended up doing this and it worked:

AND ',' + @EmployeeId + ',' LIKE '%,' + CAST(e.ID AS varchar(10)) + ',%'

Thank you all for your...

I am passing a string of comma delimited Ints to the stored procedure. Now I need to see whether e.Id is IN those INTs.

From the response I got from you...

I figured out the solution. It was very simple but my brain was not working:

Set @Mth1 = DATENAME(month,@StartDate)

and then use @Mth1 in my dynamic query.

What does "P" stand for?

I want to select as:

select ISNULL(AVG(month1),0) AS 'JULY'

but 'JULY' depends on a variable @StartMonth

I created a variable table and inserted all record in it. Then I used pivot to spread it out across. Problem resolved.

I have too many tables. If I use "generate script" then it will create the table creation script as well. I don't want to create the scripts for creating the...

Can anyone help please.

All of you must be wondering, what is this person talking about? It was my silly mistake. I tried running the SP using a long string

of comma delimited string...

Ah! stupid me. The query actually had top 1000. When I took that out, the records were there. Thanks for your time.

Select * from databasename.dbo.tableA

Thanks.

I am running just this insert statement manually. There are no triggers on either tables.

Thanks.

Besides triggers, I can also use function. right?

Hi Jason,

I also thought of doing it in 2 selects and join the results, but wanted to try doing it in single select.

Thanks for your time.