You can change the compatibility level of the database in SQL Server 2005 all you want. What you can't do is take a backup of the database and restore...

Scared him off, I think we did.

GSquared (1/8/2010)

---

Lynn Pettis (1/8/2010)

---

Thankfully, NO! I (actually the family) did get a few good (IMHO) movies: Star Trek, GI...

Scott-144766 (1/8/2010)

---

SQL 2005 SP3

I have a list of customers and associated transactions, but some of the transactions are null. Where a customer has only one non-null transaction number I want...

Thankfully, NO! I (actually the family) did get a few good (IMHO) movies: Star Trek, GI Joe, to name...

You'd get a lot better help from us (and others) if you provide us with what I have asked you to provide. For more on this, you may want...

whitlander (1/8/2010)

---

Example from 'event' table:

IDSource_IDEventType_ID Use_ID Period

34022 10 ...

Your recursive CTE will not scale well as the size of the string and number of rows increases. You should take a look at this particular thread, Performance issue...

There is a difference between the self-test software and brain dumps. The companies that build selft-test software build their own sets of questions that mimic what you may see...

Table(s) structure (CREATE TABLE statement(s)), sample data (a series of INSERT INTO statements for the table(s)), expected results based on the sample data.

This will help us help you.

I guess we haven't had much to talk about or complain about. Not sure why, other than it is the same people over and over.

Sorry, still don't understand. What are the inputs used to generate the output desired. At this point I only have half the problem. Can you provide me...

Can you show us the code?

Well, you showed us what the output should look like, but what are the inputs to the function?

What about the table structure (CREATE TABLE statement(s)), sample date (as a series...

Fixed the link in my previous post. Thanks Jeff.