NP. Does it work correctly for you?

Jeff Moden (6/25/2010)

---

eq2home (6/24/2010)

---

Here is what I found out today from TechNet (Notice "the will be removed" language:

WITH CUBE

This feature will be removed in a future version of Microsoft...

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)

---

declare @test-2 table (RowID int IDENTITY, [new proj id] char(5), [old proj id] char(5))

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)

---

Talk to your credit-card processor. I believe that they have some numbers that can be used for this type of thing - they pass the verification process...