Thanks for the fast response.

bvaljalo (2/4/2009)

---

I can't speak to the 'performance issue' someone raised above, but I can tell you this ... I use the method described all the time, and it does do...

GilaMonster (2/4/2009)

---

meichner (2/4/2009)

---

that in essence the where class does not get run and that all rows are selected from the table (which is what I want when no status is...

I had that solution but something bothered me about it. Since I am...

GilaMonster (2/4/2009)

---

There is, but it tends to have...

Thanks so much.

mikefle (2/2/2009)

---

Of course it depends if any of your applications have dependencies on this. Generally, if you know what databases need backing up, you can always schedule a job...

Thanks for all the input. I will look into the XML approach. I am currently using the OUTPUT parameter to obtain the identity key from the Sales Order Header...

Grant Fritchey (12/4/2008)

---

meichner (12/4/2008)

---

I am a C# program (.net 2.0) using Sql Server 2005. I would love nothing more then to do all of my transaction processing in...

G² (11/10/2008)

---

You're right. CTEs are limited in that they are meant to be a one-time view that gets used immediately and then destroyed. To do what you intend,...

G² (11/10/2008)

---

CTEs can be used to replace derived tables, temporary tables or table variables. They tend to be more readable than using nested subqueries. In fact, they're very...

Not in the way you are expecting it to...from BOL:

Guidelines for Creating and Using CTEs

The following guidelines apply to nonrecursive CTEs. For guidelines that apply to recursive CTEs,

see "Guidelines...

noeld (11/6/2008)

---

1. PIVOT needs an aggregate function...

IF OBJECT_ID('TempDB..#mytable','U') IS NOT NULL

DROP TABLE #mytable

CREATE TABLE #mytable

(

ID ...

Jeff Moden (11/6/2008)

---

No problem... could you provide some test data in a readily consumable format like I asked in my previous post? See the link in my signature for...