Heh... well I'll be... I found it...

http://msdn2.microsoft.com/en-us/library/bb326653.aspx

... learn something new every day...

VARDECIMAL OPTION? Where did you find that? I can't even find it in Books Online... Is it a database setting or ???

Sounds like another "Sr. Project".

Doing my morning article "skimming" and saw this one. In the "Conclusion" it's stated "This way I avoid using a GROUP BY "... and the example right above it...

Which one of the many links posted is that? And why does he say not to use Bulk Insert/BCP anymore?

Whatever... I just think this is wrong on so many levels.

rbarryyoung (3/15/2008)

---

Anyway, for those who may actually be interested in what parts of Transact-SQL are standard and what may not be, here is a good readable summary site (yes, I...

Anirban Paul (3/18/2008)

---

The article was good. I liked it even though it has some probs as pointed by some of my 'co-readers'. For me it started the base of RBAR.

Thanks...

FULL OUTER JOIN with null detectors on both tables.

Don't store formatting symbols in the database. The only thing they're good for is display... you'd have to strip them out of most file transfers and reporting and GUI...

Thanks for posting the solution, Virgil...

Absolutely the right idea with the numbers table, Gus 🙂 but you don't need the CTE or a...

Use BCP for this... and use OSQL instead of ISQL...

Use the SELECT along with INTO to create a table. Use sp_SpaceUsed to see how big the table is.

kaiitong (3/17/2008)

---

Hello Jeff

I'm really appreciate your concern about me. Not to make an excuse. I've really tried on many way. I looked up in the books, searched on the internet...