Run this:

select EmpCode

from tblEmpCodes

where cancelled is NOT NULL

AND EmpCode IS NULL

First you need to convert csv to table variable.

Search this site for "split" or "parse" function, there are plenty of them.

Then you join that table variable to the static table:

select...

Karthik,

I can give you set of other "variable limitations".

For example:

SELECT * FROM @Table

SELECT Value as @ValueName

GROUP BY @Column

etc.

All these are actually cases of misuse of language elements typical for beginners.

What...

You should left-click on the database first.

If you are using 2k you may click on DB in EM, then right-click and select View-Taskpad.

Tell us what it will show you.

Are you on SQL2k or2k5?

Do you have Enterprise Manager?

You may do normal BACKUP LOG, it will remove pages from LOG file as well.

Just make sure you direct backup to some network drive, because backup file takes space for...

karthikeyan,

limitation is not in variables, limitation in your knowlege of the language.

Not sure about juniors, but even medium level developers (developers, not system engineers) suppose to know the difference between...

Or:

SELECT *

FROM mytable

WHERE mydata LIKE '_________F[1-5]%'

Are you prepared to have all your "B100"to be replaced with "B980"?

Because you want to replace "B10" with "B98".

So, B100 as B10+0 will be replaced as B98+0 = B980.

@@NESTLEVEL depends on where you call your INSERT from.

If it is from a procedure called by a procedure called by ....

You know.

EXEC (@SQL1 + @SQL2 + SQL3 + ...)

There is a trick for you:

IF Object_ID('tempdb..#Inserted_trg_StaticSiteMenuTopLevelMenu') IS NOT NULL

RETURN

ELSE

CREATE TABLE #Inserted_trg_StaticSiteMenuTopLevelMenu (ID int)

Table will be created when the trigger is called...

Quickest UPDATE would be drop the table and create a view with the same name to return calculated values based on look-up criteria.

Do BACKUP LOG.