.NET Answers

Archive for November 4th, 2008

Last week I had an interesting assignment: Given a specific record, randomly retrieve three related records from the database.

Naturally, as a programmer, I started looking for the SQL random function.  Which I found.

But even as I was searching for how to use that function, I was thinking to myself, “How am I going to structure things in such a way so as to randomly select the records once I have the function?  It isn’t like I can retrieve the records into an array and then select them out.  Am I going to have to retrieve them into a temp table?”

Read the rest of this entry »

Other Related Items:

Inside Microsoft SQL Server 2008: T-SQL Programming (Pro-Developer)

Get a detailed look at the internal architecture of T-SQL with this comprehensive programming reference. Database developers and administrators get... Read More >

Wilson Jones 362 Line Basic Round Ring View Binder, 3-Inch Capacity, 8.5 x 11 Inch Sheet Size, White (W362-49W)Looks good on the shelf or on the go. Customize for filing or presentations with a non-glare overlay on the spine and front and back covers. Use the round ring open and close triggers for easy access. Take advantage of interior pockets for extra storage.

Arcserve Backup R12.5 Win Win Agent F/ Ms Sql Svr-Prod OnlyCAARCSERVEBACKUPR12.5FORWINDOWSAGE