Can you post some sample data?

Have you searched the script section here already. This is a FAQ, so very likely you find a generic solution there.

Multiple posts to different fora doesn't make it any better

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=10&messageid=152693

Anyone who is that stupid to believe there is money for nothing available must bear the blame himself.

Something like this?

use pubs

go

select au_lname,

 case when charindex('l',au_lname)>0 then au_lname else 'FRANK' end

from

 authors

?

Just a note on the use of a column with BINARY_CHECKSUM instead of * as has been mentioned above. Consider this:

CREATE TABLE #t

(

 i1 INT IDENTITY

 , c1 VARCHAR(50)

)

INSERT INTO #t VALUES...

Really the quickest way?

Detach the db, rename or delete the log, attach the DB

or use

BACKUP LOG WITH TRUNCATE_ONLY

DBCC SHRINKFILE

Btw, changing the recovery mode has...

Have a look at BOL for "CREATE VIEW" -> "Creating an indexed view". The chapter about requirements for an indexed view should help you.

Can you post your statement?

Forgot to mention, to determine the name of the DB the DB_NAME()  function might come in handy.

See, if this helps:

DECLARE @stmt NCHAR(1000)

SET @stmt = 'USE Frank_3 '

 + CHAR(13) +

 'DECLARE @stmt NCHAR(1000)'

 + CHAR(13) +

 'SET @stmt = ''CREATE TABLE First (col_a int)'''

 + CHAR...

I think your syntax isn't supported by SQL Server (At least, have I never heard of that). The use of a cursor might be questionable, maybe you can workaround the cursor...

I'm not sure if I understand you. Can you give an example in pseudocode of what you mean?

What is your exact statement and the error message you get?

And why do you want to denormalize your table?

You can't use dynamic SQL inside a function. So this part of your suggestion won't work.