The Business Intelligence Development Studio (BIDS) component os SQLServer 2008 uses a subset of Visual Studio 2008. If you don't have VS2088 SP1 installed, it will install a separate copy...

Thanks for the suggestions.

I tried them both and, with my sample data, they both seemed much faster than my version. However, when I tried them on some 'real' data, where...

OK. I figured it out.

When I recreated the database, I must have changed the ODBC connector. Using a 'SQL Server' connector it's slow. Changing to a 'SQL Server Native Client...

I needed a similar feature a few years ago and came up with 8 classifications of International holidays (non-working days) as either fixed or relative to some other date, one...

I have SQLServer 2005 (Developer) with SMSS and SQLServer 2008 Express with SSMSE 2008 installed with no problem, so would think SSMSE 2005 and 2008 shold be able to coexist....

Funny, I never thought I'd read a...

jcrawf02 (2/12/2010)

---

Speaking of psychological response interview questions, anyone watch "the Middle"? favorite interview of all time now is "If you could be any color, what color would you be?"

response was...

Slight correction - remove '0.' from nodepath as it's meaningless and add nodepath2 in W-X-Y-Z format

;WITH CTE_temp(P_Sequ,description,c_sequ,Level,nodepath,nodepath2)

AS

(

-- Root

Select t1.P_Sequ,t1.description,t1.c_sequ,0 As Level, CAST(t1.P_Sequ AS VARCHAR(MAX)) nodepath

,convert(varchar(max),t1.description) as nodepath2

from tabA t1

where c_sequ...

You need to go back to whoever defined the requirement that the enddate be the same day of the month as the startdate and check what they want done for...

And your question is...?

What's wrong with the non-recursive

select P_Sequ, description from tabA

where P_Sequ not in (select c_sequ from tabA)

The if you need the levels you just join it to your exisitng CTE.

You don't have to drive up the A6 every morning, do...

I work in Manchester, UK (Didsbury, actually) but live in Derbyshire, about 20 miles away.

Don't know why you'd have trouble finding rotary dial phones. I just typed "rotary dial phones us" into Google and it offered http://www.rotarydialphones.com/ and http://www.rotarydialtelephones.com/. Both US sites. The first...

Derek Dongray (7/15/2009)

---

Steve Jones - Editor (7/15/2009)

---

No idea, what's wrong there. Usually it's an embedded HTML code, but I don't see on there....