Generate Lots of Test Data with CROSS JOIN
“Joe Test”
“Joe Test2?
“Joe Test3?
“Arrgh! There has got to be a better way to create some test data!”
Ever had that conversation...
2009-10-12
3,395 reads
“Joe Test”
“Joe Test2?
“Joe Test3?
“Arrgh! There has got to be a better way to create some test data!”
Ever had that conversation...
2009-10-12
3,395 reads
This past Saturday I was able to participate in the Carolina Code Camp, help just outside Charlotte, NC. I was...
2009-10-12
940 reads
Congratulations to John Magnabosco for being awarded as a Microsoft MVP. I met John last year at the Indy Tech...
2009-10-12
622 reads
See his quiet post about it here. This comes right after finishing up his first book titled Protecting SQL Server...
2009-10-12
289 reads
I read The Duct Tape Programmer from Joel Spolsky recently, and I thought he made some good points. Then I...
2009-10-12
691 reads
Ever had a day when a bunch of small things run together to create a day you wish you had...
2009-10-12
338 reads
I try to be balanced on new technology and ideas, trying to find the middle ground between hype and usefulness,...
2009-10-11
395 reads
I’ve been blogging for a few months. During that time I’ve received comments about my grammar, sentence construction and paragraph...
2009-10-11
650 reads
Here it comes! The big event on my schedule SQLSaturday #21 –Orlando. We’ve got over 300 registered so it should...
2009-10-11
500 reads
A couple upcoming events I'll presenting at...
SQL Saturday #21 on October 17th in Orlando
I'm amazed at how SQL Saturday has grown...
2009-10-10
394 reads
As for me, I'll keep writing whenever time permits. I don't expect every post...
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Comments posted to this topic are about the item Pay for Performance, which is...
Hi I have this slow query that is pulling data from a linked server....
Comments posted to this topic are about the item Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers