SELECT Language, format
FROM Product_Details
WHERE TRY_CONVERT(varchar(max),format) = REPLICATE('?',LEN(format))

John

Try removing the square brackets from the first line.  It's looking for that literal login name - square brackets and all.

John

There's no "undo" switch, but you can create a task that moves the files back, similar to the task that moved them in the first place.

John

Use the sys.server_role_members (that may or may not be the exact name - I can't remember) catalog view to script out the members of the sysadmin server.

John

In Object Explorer, navigate to Security -> Logins.  Open the Object Explorer Details window.  Select all logins, or just those you want to script.  Right-click, and choose Script Login as.

Your INSERT statements will fail unless you turn IDENTITY_INSERT on.

Why don't you just create LogTable as a view, and then it's always correct without your having to update...

Your SELECT statement is just selecting the dynamic SQL, not setting it.  Try changing SELECT to SET @sql =

John

Well, my guess would be yes.  But you're the one with the SQL Server 2000 computer - why not try it?  You won't break anything.

John

I think this is what you're looking for.

John

No, I agree - it would need to be the first column in the key.  But like I said before, it's not needed at all, unless the product ID PD1...

Danny

Use REPLACE to replace '-00' with '-20'.

Edit: and then change the data type to date so you don't get this happening again.

John

I'm not sure there's any more efficient way than that.  You'll probably need indexes on the columns in the GROUP BY clause and in the join predicates as the number...