Hugo:

Other than using "UNION ALL" I don't see any difference in my code and yours.

Never mind, I agree "UNION ALL" is the best.

Do not reply....

I found the solution.. Ahhh! It was way too easy.. I shouldn't have asked anyone.

Select p_code, NULL as name , CNT from @a

UNION

Select p_code,...

Luis: It works, However I changed the data somewhat slightly. Now we have 2 more rows in table @a that do not have members in @B.

Take...

Reply to all:

Please ignore this post.

I found the issue.

I had done things in an unusual sequence and that caused the bug.

See the script I created below. If you run this...

Reply to all:

1.) The table gets copied at run time via another process from another db. For the purposes of processing, I need to add the column "DUPLICATE" ( This...

Reply to ZZArtin

So does the recovery mode "SIMPLE" ( which is at the moment ) mean that nothing is written to the TR log ?

Reply to John:

See attached, I ran the sql you sent.

Also in my original post I have question#2.

That is:

IS there a way for me to do an update without SQL sever...

Zzartin:

verify that your scheduled log backups are running properly,

How do I do that ? CAn you guide me

Reply to John:

I am not a DBA. I am a SQL developer. I am hoping someone will pass me the commands and I can check/test/execute them.

Reply to "pietlinden"

How do I find the instance name ?

I did not install SSMS. Someone else did

I see, all 3 work equally well! ( I ran your code )

I am not sure what all those stand for ? Can you recommend which I should be using...

So which one should I use ( out of the 3 )

Sorry, found the answer....

The one below works fine!

SELECT p.name, m.definition, charindex('''Unknown''', m.definition, 1 )

FROM sys.procedures p

JOIN sys.sql_modules m ON p.object_id = m.object_id

where

m.definition LIKE '%Unknown%' Collate SQL_Latin1_General_CP1_CS_AS

ORDER BY 3...

SELECT *

FROM dbo.CaseSensitiveTest

WHERE Value1 LIKE '%Test%' Collate SQL_Latin1_General_CP1_CS_AS

GO

The above is fine.. But can someone help me with the following: How do I do this search to be case sensitive...