LutzM (10/16/2010)

---

I would use the "quirky update" method.

Disclaimer:

DO NOT USE the code

until you've read Jeff's article[/url] and the related discussion.

DO NOT USE the code

until...

LutzM (10/16/2010)

---

I would use the "quirky update" method.

Disclaimer:

DO NOT USE the code

until you've read Jeff's article[/url] and the related discussion.

DO NOT USE the code

until...

First, create the tables and some initial data. YOU SHOULD HAVE PROVIDED THIS!

-- See how you start off by actually creating a table and then

-- inserting the data into...

scottichrosaviakosmos (10/15/2010)

---

declare @tbldate table(stdid int, sdate date, eddate date)

Now i want to put a condition on my final result column of A and B that if edate is of month...

WayneS (10/15/2010)

---

Specifically, Do ALL tables that reference table konten have indexes on their foreign key...

Craig Farrell (10/15/2010)

---

I think I'm going to go hide in my corner now....

CirquedeSQLeil (10/15/2010)

---

GilaMonster (10/15/2010)

---

Big boom.

That's one of my all-time favourites, along with the...

LutzM (10/15/2010)

---

Do you have to store it on the disk?

Why not storing the xml results in a separate table (file name in one column, xml data in a xml column,...

SOM!

(They're not so easy when Steve has to go tell...

Umm, Craig, this is valid syntax for 2005 also! :w00t:

Specifically, Do ALL tables that reference table konten have indexes on their foreign key columns?

You're...

Either SSIS, OpenRowset (to a text file), or sp_OACreate to use the Scripting.FileSystemObject to write the data out.

Alvin Ramard (10/15/2010)

---

Grant Fritchey (10/15/2010)

---

GilaMonster (10/15/2010)

---

And just when I thought the situation at That Client couldn't get any worse....

<headdesk><headdesk><headdesk><headdesk>

(No, I'm not going into details, it's a little too sensitive a...

I don't think...

William Vach (10/15/2010)

---

Thanks for the information. I was not aware that you could also set the query window color through the connection dialogue box. I did discover a...