I agree, partially... Temp tables shouldn't be used just because they can be. But, remember that a "derived table" and CTEs create "working" tables which appear in TempDB just...

virgo (8/11/2008)

---

Hi jeff,

That was informative...is ther a way using sql query to retrive the doc,image,pdf from the sql server tables to local computer with out using any ADO or front...

I think replication...

Maybe so... but you're pretty good at throwing people under the bus yourself. 😛

It sounds like...

Two way street here, Angel... tell us how you solved your problem, please. 🙂

jennyor (8/11/2008)

---

I'm trying to write an update command in sql to take the weekyear portion of a serial # and convert it back to a date by extracting the week...

THAT, my friend, it why I recommend only storing the file name and not the file itself. 😛

You either have to capture the info in a variable in a...

Shamshad... have you tried...

Like I said... Books Online... lookup BCP Format file. I can't help if you don't even know what I'm talking about. 😉

dwither_07 (8/11/2008)

---

Hmm..let me trace on how did I come up with the said result, I'll just use script number 6 (Sixth Data Scenario) since it has less data.

--=====...

Good article so far as the format, readability, and revelation go. The thing I'm having a problem with is the use of recursion of any kind to create a...

Does anyone want to race? 😉

Um... no... according o the rules you gave, script 5 should include rowid # 11 because the promo-id went from 6 to 1.

Ok... I've tested all of your scenarios and they all came out like you said in the comments except the 5th one... and that's because you made a mistake... Row_ID...

yogesh.khaire (8/10/2008)

---

Is there any way other than Trigger. ?

But i want fast Updation. when ever Data Inserted or updated in the Table i want to be insert that Data into...