The checksum

Generating Test Data: Part 2 - Generating Sequential and Random Dates

Part two of this fantastic series from Jeff Moden looks at generating date data, something which can be handy for any number of testing purposes.

Generating Test Data: Part 1 - Generating Random Integers and Floats

Learn how you can easily generate large amounts of test data efficiently in this new series from Jeff Moden. Part 1 covers integers and floating point values.

Random problems

Building random numbers can be challenging for people working in T-SQL. New author Chris Nowicki brings a solution he used to get a random number assigned to each row of a result set.

RE: Duplicate Records

Something like this..CREATE TABLE SSNTemp (  SSN char (10) NOT NULL ) CREATE UNIQUE   INDEX [IX_SSNTemp] ON SSNTemp ([SSN]) WITH     IGNORE_DUP_KEYinsert into SSNTemp select ssn from yourssntable delete from yourssntableinsert into yourssntable select ssn from SSNTemp  

RE: help to modify a query

See my answe to this post I put in this morning; http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=131367&post=true You just need to replace the WHEN statement with between start and end dates.

RE: Drill Through filter option

In the Cube Drillthrough Options screen, on the Columns tab, you should see all of the columns contained in all of the tables used in your model. Assuming you have only 2 tables, a fact and a single dimension, the columns may be something like COLUMN TABLE fkCol1 tblFact fact1 tblFact fact2 tblFact pkCol1 tblDim1 […]

RE: Invalid column

quote: ...if you placed a GO between the Alter and the Select... True in this contrived example but not if the intention was to use it in a procedure.

RE: Error when changing startup account

the user that you want to change the sql service account need to be a user at a minimum at your local box. mom

RE: profiler

No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!