Well, it depends

One way that may be more 'elegant' is simply to split different select statements into different procedures. There is no black...

Glad you found a way that works.

bcp would have been my choice as well

/Kenneth

Row DatabaseID:FileIDageID:Slot(row) RID: 5:1:104:3

In this case, database ID 5 is pubs, file ID 1 is the primary data file, page 104 is a page...

It looks like the procedure usp_ValidateWebMember is having problems when executed simultaneously by more than one connection.

You need to look at the code inside usp_ValidateWebMember in order to find what may...

Books on Line (or BOL for short) is the online manual that comes with SQL Server. It usually installs along with the client tools, like Enterprise Manager, Query Analyzer etc....

It would probably be easier to figure out what's happening if you could build a small repro script and post that.

We need basic DDL of the tables involved (with accurate...

It seems a little backwards... Can you please post a few samples with tables, some data and a description of what you want to do and the desired output..?

You...

Perhaps it would be in order to recommend some reading in Books on Line as well?

'computed columns' is a good thing to search...

For inner joins, there is no difference at all if you filter in the ON clause or the WHERE clause.

These two are exactly identical:

SELECT *

FROM   foo f

JOIN   bar b

ON    ...

A ROLLBACK will always do two things - it will undo all work done from the outermost BEGIN TRANSACTION and it will reset @@TRANCOUNT to 0 (if you use savepoints...

Here's something I had lying around in my archive. Never tried it though, but it may be of some help I hope.

-----Original Message-----

From: Sydney_Lee@discovery.com <Sydney_Lee@discovery.com>

To: SQL 7 Discussions...

This seems shaky at best, though more like outright dangerous. Are you really granting public access to the sp_OAxxx procs? You might as well give the server away on a silver...

You can't. ANSI => OEM conversion is done 'in between' a source and a destination. The ODBC connection is one place where you can set it.

You can find out more...

Yes, that is correct. You cannot declare global variables in Transact SQL, only local variables. So, a variable named '@@myVar' is still a local variable named '@myVar', even...

Maybe we need an explanation about what the purpose behind this request is? I mean, I don't understand why you would declare a few constants, and then filter on those...