Nobadys' is perfect you learn it from your silly mistakes :-D.

you might have named instanced installed .. try it..

here si the correct code

DELETE

FROM SecondaryCategory

WHERE EXISTS(select 1 from deleted where SecondaryCategory.[ArtistID] = DELETED.[ArtistID]) AND (SecondaryCategory.[ArtistGenreID] = DELETED.[ArtistGenreID])

)

I guess this is what you are looking for....

selectdistinct NAME, cast(DIM1 as varchar(10)) + '-' + b.DESCRIPTION as DIM1,

cast(DIM2 as varchar(10)) + '-' + b.DESCRIPTION as DIM2,

cast(DIM3 as...

Try THis one....

SELECT LOC_NUM, MAX(ISNULL(CASE DEPARTMENT WHEN 'CCD' THEN COUNT(*) END,0)) AS CCD,

MAX(ISNULL(CASE DEPARTMENT...

I am still struggling with the suggestions.

considersing the same sample what pdanke has explanined.. we can use below query to update the data in TableA

UPDATE a

SET a.puser = COALESCE(a.puser, b.primaryuser)

from @TableA a

join @TableB b on a.id...

Khusbu,

You should educate the developers with best practices on writing the script. As koen has already explined about two different transactions, I would i only one comment "check the column...

I guess you can handle this case just by handling the NULL values in Execute SQL task.

What is the size of your database?

Automating installation is a good idea but installing service packs w/o knowing the imapct :w00t:... is not advisible.

Thank you all I did worked earlier on the option suggested but we are confortable with the options. I do have a server side trace running I guess I can...

No one can tell you when to use table variables and when to use temp tables. Each you need to decide which is performing well...

I would suggest you go thorugh...

The answer lies in the question. Filter in JOIN & filter in WHERE clause.

When you add filter in JOIN the rows from respective table will be filtered based on...

To answer your question...

JOINS always perform better than IN clause. Why ? IN clause is basically performs sub query funcitonality, for each row in outer query it execute the innser...