Man, I sure hope so. This is what I'm basing my future on!

Returning 2.75 million rows in 14 seconds to the screen is pretty good.

That being said, I see one area where it might be improved upon.

When a column in a table...

I think this is what you're looking for. If so, you were pretty close.

;WITH CTE AS

(

SELECT EmpID,SuperID,

-- provide a unique ParentNumber (PN)...

Sigh.

Rahul, up above Falgunoza...

CirquedeSQLeil (6/24/2010)

Wow that one sneaked right up on...

It seems like on the days that Steve...

rahulsony111 (6/24/2010)

insert into @test-2

SELECT '1150b', '1150/' UNION ALL

SELECT '1150c', '1150a' UNION ALL

SELECT '1150d', '1150b' UNION ALL

SELECT '1150c',...

I'm not going to reformat your data into usable code again. I you want me to look at it, then you will need to at least put the new data...

if object_id('tempdb..#temp') IS NOT NULL DROP TABLE #temp

CREATE TABLE #temp (DBName sysname, UserName sysname, UserSID varbinary(85))

if object_id('tempdb..#temp2') IS NOT NULL DROP TABLE #temp2

CREATE TABLE #temp2 (UserName sysname, UserSID varbinary(85))

execute master..sp_msforeachdb...

George, please see the first link in my signature. If you...

In the first link you referenced is this

So, just use the sp_help_revlogin procedure to script them out, and then run the...

Taking the idea of a staging table to the next level, how does this work out for you?

declare @test-2 table (data varchar(100), cust_id int null)

insert into @test-2 (data)

select 'A, 1,...

GabyYYZ (6/24/2010)

CirquedeSQLeil (6/23/2010)

WayneS (6/23/2010)

How's this?

select *

from #tt

left join #tt1

on #tt.theDate = #tt1.theDate

...

Rem-487422 (6/23/2010)