Nice… I love it when that happens!!!

Especially when I right click on a table in Microsoft SQL Server Management Studio and then Open Table…

Probably need to reboot… That fixes everything else…

Yup, it is a reality.
Yup, it is free (for now).

It allows you to have Intellisense for your SQL queries. Works very nice. Good job Red-Gate!

Thanks Michal for the link.

It is easier than I thought it would be.

DataTable dt = new DataTable(“MyTable”);
bool hasMyColumn = dt.Columns.Contains(“MyColumn”);>

BTW: The Contains() methods appears to be for any collection and not just DataTables.

If you do not know, John Reuben is one of my favorite musical artists… And I stress Musical ARTIST!!!

“SICK RHYMES KILLER BEATS”

I found a couple of autobiographical video’s and wanted to share them with you.

• The Professional Rapper
• Mistaken for a Girl
• Re: Mistaken for a girl
• It’s all about the marketing!
• John Reuben (live show)
• Heavy Metal Mom (John Reuben’s mom)

Videos

• Do Not (My wife’s favorite)
• Nuisance Video with Reliant K
• Nuisance Video Spoof

His websites:

• http://www.myspace.com/johnreuben
• http://johnreuben.com
• http://reubonicplague.com

Be careful, you just might catch the “Reubonic Plague”

Found out why live mail was dead in the water a few minutes ago.
Looks like they were doing a system upgrade.

In the first minute of use… I like it.

• Appears a good bit faster
• No stupid adds on the right which takes some of your reading pane space
• Move to works worlds better

Very nice… Good job Live mail team!!!

I was trying to read my live mail account… Oh well…

Ok, the goal is to take this PurchaseOrderHeader table from the AdventureWorks db and build a comma delimited string of purchase orders.

Filtered dataset:

PurchaseOrderId OrderDate               SubTotal
————— ———————– ———
801             2003-10-05 00:00:00.000 143.0415
884             2003-10-12 00:00:00.000 143.0415
907             2003-10-14 00:00:00.000 143.0415
971             2003-10-28 00:00:00.000 143.0415

DECLARE @PurchaseOrders varchar(50) 
>

SELECT @PurchaseOrders = ISNULL(@PurchaseOrders + ‘,’, ”) + CONVERT(varchar(10), PurchaseOrderId)
FROM Purchasing.PurchaseOrderHeader
WHERE VendorId = 1
   AND OrderDate BETWEEN ‘10/1/2003′ AND ‘10/31/2003′>

SELECT @PurchaseOrders>

This returns:

801,884,907,971

For winning the 2006 AAAA State Championship!!! GO BRUINS!!!

Championship game scores from WPDE here in Florence. (about the extent of what I could find online)

Fuss session: I am very upset with the local media here in Florence.
This should be something we should be proud of; yet it is only mentioned in passing.

Well… I am proud of you Lady Bruins!!!

Check out the ROW_NUMBER() function new in SQL 2005.

Here is an example of what it can do using the AdventureWorks database.

SELECT  
   ’RowNumber’ = ROW_NUMBER() OVER (ORDER BY PurchaseOrderId)
   , PurchaseOrderId
   , OrderDate
   , SubTotal
FROM Purchasing.PurchaseOrderHeader
WHERE VendorId = 1 
   AND OrderDate BETWEEN ‘10/1/2003′ AND ‘10/31/2003′>

RowNumber PurchaseOrderId OrderDate               SubTotal
——— ————— ———————– ———
1         801             2003-10-05 00:00:00.000 143.0415
2         884             2003-10-12 00:00:00.000 143.0415
3         907             2003-10-14 00:00:00.000 143.0415
4         971             2003-10-28 00:00:00.000 143.0415

Maps and bathtub cleaners!!!
Now those are topics for a .NET users group meeting!!!

I can hardly wait to see Page Brooks‘ presentation tonight on those topics at the Pee Dee Area .NET Users Group.

Please see site for directions and times.