Just curious... are any of the joined "tables" really views?  That's what happened to me at work... just did a SELECT * to see what I got back from a...

NVarchar uses two bytes per character.  There is no reason to use it unless there is something "language specific" or the system requires it.

Using EXEC (@SQL1+@SQL2...@SQL4), have been able to do up to 32k.  Target of exec has to be in ( ).  Didn't try it but was once told the limit was...

You can also create roles and assign individuals to roles.  That way, if you need to change the permissions for a whole group of people, you just change the permissions...

The systax of the GRANT command should be as follows:

GRANT permissiontype ON sqlobject TO grouporrole

See "Books on Line" under "GRANT, GRANT (described)" for a complete list...

CASE

  WHEN ABS(DATEDIFF(ss, x, y)  ) <= 3

  THEN 'Y'

  ELSE 'N'

END

 

Don't forget that DATEDIFF will always TRUNCATE to the whole second.

-2.9 seconds becomes -2 and 2.9 seconds becomes 2.

I believe you are looking for the GRANT command.  See "Books on Line" for details.

>it works until the caseno column contains an value that can't be converted to int.

Mike, you are absolutely correct.  I was aiming at the original question and I guess I...

I don't think you'll see much of a problem because "IS" shares are not exclusive and rank as one of the lowest locks.  I haven't had a problem with it,...

You may have better luck with OpenRowset.  Here's a copy of the example in "Books On Line"...

A. Use OPENROWSET with a SELECT and the Microsoft OLE DB Provider for SQL...

Someone isn't doing something right on Kim's machine... the following example shows that, although it may not be a good idea, implicit transactions as Kim described should work just fine...

Not sure, folks, but I think the original question was about having temp tables with the same name running in stored procedures that run at the same time.  The answer,...

You've made it a bit difficult on yourself... the following should do nicely and should do 70,000 records in something less than 10 seconds on a good server...

UPDATE...

Yeah, Wayne has confirmed what I've heard... you can do some really nasty things through xp_shell.  Maybe you shouldn't go there.  Just create the BCP job in a batch file...

Of course, Microsoft documentation is always 100% correct

What you may want to try, instead, is calling BCP using xp_shell... that is unless you...