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...

Calvin,

If your server is set to CONCATENIZATION OF NULL YIELDS NULL, then you will need either COALESCE or ISNULL unless you preset the variable to something other than NULL.

Richard,

I believe that, with SQL 2000, there is a BULK INSERT role where you no longer have to grant a user "SA" rights just so they can use the BULK...