@67 posts, i didn't think this was homework for the OP, and i got all excited about making a recursive...

assuming alphabetical order of the status can be used, this works:

With MyCTE (Product,Parts,Status)

AS

(

SELECT 'Laptop1','mouse','OK' UNION ALL

SELECT 'Laptop1','screen','OK' UNION ALL

SELECT 'Laptop1','button','OK' UNION ALL

SELECT 'Laptop2','mouse','OK' UNION ALL

SELECT...

cidr (9/19/2012)

---

Thanks for responding Lowell,

The only issue with this technique is that there are literally 10s of thousands of parts so I'm not sure if this technique would work; I...

ok, i think this recursive CTE generates allt eh sub parts you are looking for:

DECLARE @Table Table(

Parent varchar(2),

Child varchar(2) )

INSERT @Table

SELECT 'A1','B1' UNION...

You could test agaisnt an express instance until your license comes in...just change your connection string;

there's pretty much only 3 or 4 things in the string anyway; server, database, trusted...

create a new post for this question...the original post is from 2009, and very very few peopel will follow it.

also include...

just to confirm, it shows correctly in SQL2012.

it looks like sp_help does nto correctly identify the delete actions.

if i run this i see the action correctly:

select * from sys.foreign_keys

there's a connect item complaining about it here:

http://connect.microsoft.com/SQLServer/feedback/details/616475/sp-help-doesnt-show-set-null-in-foreign-keys

there's two ways to do it;

one witht he proprietary SQL syntax, and another with a correlated query:

--SQL Server UPDATE FROM syntax

UPDATE [Projects]

SET Projects.Closed = Projects3.Closed

FROM [Projects3]

WHERE Projects3.Name = Projects.Name

--correlated...

I think compression may be an enterprise only/Developer version only feature.

If you don't have neterprise edition, you won't be able to use it, i think.

there's a really good MS article...

Sean Lange (9/19/2012)

---

My answers would have been similar to this.

I did know this one, 1024 or 30,000, depending on whether we are talking...

for me, this says...

well i converted/scripted everything to consumable format, but i have no idea what you tried to insert into the table.

a simple INSERT INTO ProjectHours VALUES (10,0,0) works woithout...

Lynn Pettis (9/18/2012)

---

SQLRNNR (9/18/2012)

---

Lynn Pettis (9/18/2012)

---

Flat file, 150,000 columns, SQL Server only allows 1,024 columns per table. The flat file needs to be imported into Excel spreadsheets.

I'm not in...

adding another option to the mix:

i threw a CLR export example out on codeplex;

if you have the ability to add CLR into the mix,then you could use one of the...