I believe what you're looking for is sp_helplogins

Have a look in BOL for more info on this proc

/Kenneth

You can't declare your own global variables in Transact-SQL.

If you do;

DECLARE @global - you get a local variable named 'global'..

If you do;

DECLARE @@global - you get a local variable named...

Someone said;

"Keep us posted on your code, there isn't enough in these forums on dynamic sql......."

I beg to disagree - it's way way too many questions on dynamic sql in these forums....

Just to supply some variation

If the only criteria is 'rows from order where the same ordernumber is in more than one row', then...

Agreed - it has the potential to trip some unwary feet. Tonge-in-cheek is required (as well as some 'sanity checks' like plain selects to verify the 'target area')

/Kenneth

Maybe that was the intention, but as it was presented as the actual SQL executed, it boils down to a batch of two statements rather than one.

With some commenting the...

You may also want to read this nice page http://www.sommarskog.se/dynamic_sql.html entitled 'The Curse and Blessings of Dynamic SQL' - if for nothing else to verify that what you're doing is...

Well, it does insert just well when I tried it.

Maybe I should point out that you don't have the string "01/23/1234" anywhere in your example, since your variable for storing...

Perhaps you should thank your lucky star the log got full. The SQL written isn't quite what you wanted to do..

Delete tblMMStanTestScores

Select TS.Grade, TS.TestShortName, TS.Permnum, TS.SA, TS.InsertDate

From tblMMStanTestScores TS

Inner Join...

Yes, 1) is correct. That is how datetime datatype is implemented in SQL Server.

2) Well, this is expected. Your datestring for the test is '01/23/12', which by all means conforms...

Imho, letting users have the "freedom" of creating/generating their own ad-hoc queries demand a certain level of expertize from the users. If they don't have this, they shouldn't be allowed...

Most likely the answer is yes for equi joins - there is no difference in having the second criteria in the ON clause or the WHERE clause.

For outer joins the...

Apologies for being unclear, my mind was in 'generic' SQL mode, not SQL Server specific 

My intention was to say;

How rows are physically stored does not necessarily guarantee in...

Antares solution is very slick, though it may be difficult to understand how it works and hard to read if you don't know how the functions involved work in this 'special' case.

Another...

The requirement to state 'order by' if you want to guarantee a certain order in the result has always been there - it has not been added by MS.

Only bozos...