COOL.

i've never seen TABLESAMPLE before. but this looks nice. it seems to be unreliable on the number of rows that come back, but i suppose i could just...

loop the NEWID() field through a VIEW against the raw data.

CREATE VIEW [mlowden].[dbo].[v_Xtreme_RandomCompanyNames]

AS

SELECT CompanyName, NEWID() AS RandomSortBy FROM mlowden.dbo.Xtreme_Customers

then just use the VIEW as...

GOT IT !!!!! 🙂

please hold for details.

HAHA. fair enough. I guess I just prefer the features of TXT/SQL editing in a more advanced TXT editor ... you know with options like "Insert 2 spaces...

Oh I totally agree. But really isn't it the only way to create a view without typing the supporting TSQL for like "CREATE VIEW" etc?

Or is there some higher...

wow... thanks for the quick followups guys.

------------------------------------

Right-Click > New View

.. add a simple table like "country"

Type your own SQL in the editor (3rd of 4 panes) and enter:

SELECT

...