How can a UniqueIdentifier be used to return rowsets

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

How can a UniqueIdentifier be used to return rowsets

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-06-10 : 08:10:57

Nithya writes "HI,
I would like to know if a uniqueidentifier can be used to return rowsets which contain data from more than one table. If it does then how can i use the rowsets returned by them.

Regards,
Nithya"

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-06-10 : 13:15:36

Could you provide an example of what you mean?

Tara

X002548
Not Just a Number

15586 Posts

Posted - 2004-06-10 : 16:01:37

It's the row number thing...

Either wait for Yukon (which I can't believe they added that...continue the misconceptions about data)

Or use a temp table



USE Northwind
GO

CREATE TABLE #myTable99(Col1 int IDENTITY(1,1),YourData99 int)

INSERT INTO #myTable99(YourData99)
SELECT OrderId From Orders 

SELECT * FROM #myTable99 ORDER BY Col1
GO

DROP TABLE #myTable99
GO

Pretty arbitrary, no?

Brett

8-)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources