MD (5/14/2008)

---

Jeff

I'm not sure if I can use this because it took so long to run. I mean, I can think of better things to do with my seven...

Thanks for the compliment, Todd... :blush:

Au4848... are you all set?

If you perceived it as "almost stalking", so will others... don't forget to protect your self.;)

Well done John and Matt! Exactly correct on both parts!

Todd, here's the long answer... Funny thing... I'm actually writing a series of articles on the generation of constrained random...

Michael,

They don't come right out with an example that I can easily find in BOL, but if you put a couple of bread-crumbs together, you come up with the following...

What kind of...

Thanks, Sapna... :blush: Such a nice compliment is a great way to start the day. 🙂

Me too... except I'd add one thing...

UPDATE Employee

SET SocialSecNumber = stuff(stuff(SocialSecNumber , 6, 0, '-'), 4, 0, '-');

WHERE SocialSecNumber NOT LIKE '%[^0-9]%'

... just to be on the safe side.

One other thing... why do you want to scramble the dates in such a fashion?

"Disater Planning" comes in many forms... this is one of them. You need to make backups that the "IT Member" has no knowledge of and no access to. ...

Million random date pairs in <30 seconds ok?

SELECT SomeDate AS StartDate,

SomeDate+1 AS EndDate

FROM (

...

Peter, any idea where I can get a list of these ODBC functions?

That's if you need a solution for both SQL Server 2000 and 2005... if it's just for 2005, it gets real easy...

SELECT CASE

...

Au4848 (5/13/2008)

---

I have start date and end date fields in database where I want to scramble the dates. How to create random dates for start date and end date should...

Simple case statement should work.