Viewing 15 posts - 1,951 through 1,965 (of 14,953 total)
Steve Jones - SSC Editor (2/21/2012)
February 21, 2012 at 12:55 pm
jcrawf02 (2/21/2012)
they are so close...now we just need a HUD that runs on...
February 21, 2012 at 12:28 pm
carmellabanker (2/21/2012)
February 21, 2012 at 6:27 am
SQLKnowItAll (2/20/2012)
the set {1, 1, 2} = set {1, 2}, because the repeating "1" is the same as a single "1".
Eh... Kind of? That is if the elements of...
February 20, 2012 at 1:14 pm
Brian.cs (2/20/2012)
February 20, 2012 at 1:09 pm
On the point of a row, or even multiple rows, materializing "all at once", of course it doesn't actually work that way, since CPUs don't work that way (the process...
February 20, 2012 at 10:51 am
SQLKnowItAll (2/20/2012)
SQL Kiwi (2/20/2012)
SQLKnowItAll (2/20/2012)
February 20, 2012 at 10:48 am
Are you using SQL 2008 (as per the forum you posted in), or an earlier version?
If 2008, then there's a Time datatype that you should use instead of DateTime, and...
February 20, 2012 at 10:40 am
That's called a "trigger". Look at "create trigger" on MSDN or in Books Online. They're pretty easy, if you know how to write stored procedures.
February 20, 2012 at 10:39 am
IowaTechBear (2/17/2012)
Both religion (Apple vs Microsoft) and politics (jobs, political party references, ...) have started taking over...
February 20, 2012 at 6:56 am
Break the tables up a bit more (normalize them).
You should have a table of vendors, a table of categories, and a table of items per category. Then, if a...
February 20, 2012 at 6:43 am
Brent, by way of possible appology, I discovered that Travis has a tendency to annoy/offend people, based on participation in other threads. I may have overdone my reactions to...
February 20, 2012 at 6:40 am
Robert Davis (2/17/2012)
February 20, 2012 at 6:39 am
PaulB-TheOneAndOnly (2/17/2012)
GSquared (2/17/2012)
PaulB-TheOneAndOnly (2/17/2012)
Jeff Moden (2/11/2012)
PaulB-TheOneAndOnly (2/11/2012)
Just loading a table hardly qualifies as ETL.
Seriously? You don't think that taking a mega-row text file from something like Double-Click.Net and loading...
February 20, 2012 at 6:30 am
Brian.cs (2/17/2012)
February 20, 2012 at 6:29 am
Viewing 15 posts - 1,951 through 1,965 (of 14,953 total)