Nice question .. learned something from it THANKS

I have SQL 2008 R2 and Denali CTP 3 installed on my lap top, the only problem I have is remembering which SSMS icon to click on to start doing...

Assuming that your procedure creates a temp table using # (a local temp table) and NOT ## (a global temp table)

Run your procedure simultaneously by different users. Then execute...

Revenant (4/14/2012)

The image does not display in my IE9. Or was...

Something like this might be what you require

CREATE Table #UserAccount(UserName varchar(50),uPassword varchar(50)

,FirstName varchar(50),Surname varchar(50),Email varchar(75)

,ExamTaken bit,AccountType int,LastLogin datetime)

INSERT INTO #UserAccount

SELECT 'M123','whoknows','Sam','Johnson','Me@Gmail.com',0,87,GETDATE() UNION ALL

SELECT 'Sal789','sheknows','Jamie','Smith','Metwo@Gmail.com',1,7,GETDATE()

CREATE PROCEDURE [dbo].[GetUserDetails]

...

Reported as SPAM

What exactly is your problem as this works for me(Note the extra row of data which does NOT match what you posted):

CREATE TABLE #T(Col1 DATETIME,Col2 INT IDENTITY(1,1))

INSERT INTO #T

SELECT '2012-05-01...

To help those who want to help you with a tested solution, please post table definition(s), sample data and your T-SQL statement.

To do the above quickly and easily please click...

You can help those who wish to help you by posting the table definition, sample input data and desired results. To do this quickly and easily please click on...

I don't have a solution worked out, but I know there are some very smart security people out there and I'd hope that they are working on a variety of...

Nice clear question - thanks

Here is a method, probably not the most efficient but it works for me

CREATE TABLE #C(Num INT,Nam VARCHAR(5))

INSERT INTO #c

SELECT COUNT(Cola),'Cola' FROM #Nepal WHERE UNICODE(Cola) > 127 UNION ALL

SELECT COUNT(Colb),'Colb'...

Why stop at 2008 ... visit this Microsoft site

http://www.microsoft.com/sqlserver/en/us/editions/express.aspx

Compare features with needs ... and one great feature it is FREE

If I understand your question, you must first determine what collation, and code page you are using, In my case the collation is:

SELECT SERVERPROPERTY ( 'collation' ) -- Result:...

Not as easy as I thought it would be:

Since one of the major objectives of the QOD is to...