Well - if you don't use the extra field, you still CAN get just one record back per customer. It just might not be the same one every time....

In a clustered install of SQL server, local drives are not visible as resources in the cluster and therefore cannot be used in the SQL install. That's "by design",...

well then - keep expanding the definition. What do you plan on doing with the results? In other words - why do you need a cursor?

Cursor's tend to...

First - I'm assuming you meant 09/30/2007 because 9/31 is going to be hard to achieve.

The big question I have before heading into an example of how to do this...

..or - the passwords don't meet the requirements and you have the "enforce password policy" turned on....

Let's make sure we're on the same page.

Definition

"surrogate view": a view that is used instead of a table. In this case we're using it so that you can easily...

Gotta tell you - I'm feeling a bit let down... With a title like that - I was hoping for something in a fairly tale format....

"Daddy - could you tell...

I'm not sure we're using...

I'm sure someone is going to trot out a tally table solution any minute now. That being said - doing it the old fashioned way might work....

alter function bintoDec(@bin...

The EXCEPT syntax is going to use all fields mentioned in the select (meaning ROWID+partnumber+countrycode). If you don't have an index with all three fields, that's going to turn...

Well - it is true that Select * from table1 will usually run faster than select distinct * from table1 - but if you have duplicates, the first one isn't...

I'm kind of a fan of the "entry IQ test". On the way in to SSMS/EM, test for intelligence. If you pass - you get to administer the...

Yessir - it would.

Well - the test was for...

Using David and Jeff's definition - a work table is a table used for temporary purposes. You could create it anywhere: in the local database, in tempDB, some other...