Mindy Hreczuck (9/24/2012)

---

Well I'll try to explain better...

One solution would be to create a UDF instead of a view and pass in a user guid into that UDF which queries...

Yep, just this easy:

IF object_id('TempDB..#tTemp1') IS NOT NULL

DROP TABLE #tTemp1

CREATE TABLE #tTemp1(ID int, Name varchar(20))

INSERT INTO #tTemp1(ID, Name)

SELECT 1, 'NewYork'

UNION

SELECT 2, 'Virginia'

UNION

SELECT 3, 'London'

UNION

SELECT 4, 'Sydney'

UNION

SELECT 5, 'Dubai'

SELECT ID,...

Personally, I'd like to know what you have done so far, but here is a solution anyway. I know you have been give some of the code used already,...

Abu Dina (9/25/2012)

---

Luis Cazares (9/25/2012)

---

I know it could be a bad solution, and maybe you had tought about it.

But since the rCTE is not scaling well (and it sure won't)...

Here is my code, reformatted the way I like to it.

with rCTE as (

select

t1.retained,

t1.dropped,

t1.retained as TopLevel

from

...

Lynn Pettis (9/25/2012)

---

Abu Dina (9/25/2012)

---

Lynne's solution works if we assume that the retained ID is always the maximum.

But tthe solution doesn't work with the following record set:

drop table dbo.testing

create...

Abu Dina (9/25/2012)

---

Lynne's solution works if we assume that the retained ID is always the maximum.

But tthe solution doesn't work with the following record set:

drop table dbo.testing

create table dbo.testing...

Luis Cazares (9/24/2012)

---

I don't have anything to test with, but I believe this could be better.

However, the problem is that it's still using a cartesian product to obtain the result.

SELECT...

Can TotalDue every be less than 0?

Probably. I have had issues using it myself, so I tend to script the database then use SSIS to transfer data.

If you are going from 2008 R2 to 2008, you won't be able to use the backup/restore. You will need to script your database on SQL Server 2008 R2,...

YSLGuru (9/24/2012)

---

Lynn Pettis (9/20/2012)

---

YSLGuru (9/20/2012)

---

Lynn Pettis (9/19/2012)

---

Bump. Have you tried my latest change? You know, not including the [ ] around the server name and instance name with...

Try this:

Update cd

set coreprocesstoken18 = udb.coreprocesstoken18

FROM ContractData AS cd

INNER JOIN

(select accountnumber, sourcesystem, effectivedate, siccode, coreprocesstoken18

from RR_GMC.RCA.dbo.UDBSourceData

where sourcesystem = 'CAN'

and effectivedate = '6/30/2012') as udb ON udb.accountnumber = cd.accountnumber

Sean Lange (9/24/2012)

---

SQL_beginner1 (9/24/2012)

---

Lynn, it's a table.

Both the source and the destination tables have the same columns, and I need to update the column...

Not feeling well today? 😉