Jeff Moden (4/13/2011)

---

Gosh, NO! You're combining two performance sins, here. You're using an mTVF (Multi-line Table Valued Function) and RBAR. Please see the following article on how...

Thanks to all for your replies.

To Chris M,

Well, not only does that do exactly what I need, I pretty much understand it too!

Thanks very much. I need to able to drill down in the front...

To ranjodh_makkar;

I have fixed the error in my code (needed square brackets around the column names] and got your code working. Thanks for your help.

ranjodh_makkar (4/7/2011)

---create a string that will pick all the names from table [tblProject] and create one temp table

declare @tempTable varchar(mAX), @column1 nvarchar(100),@column2 nvarchar(100)

set @tempTable =' Create table ##result ( Date...

ranjodh_makkar (4/7/2011)

---

CREATE TABLE [dbo].[tblMeeting](

[MeetingID] [int] IDENTITY(1,1) NOT NULL,

[MeetingName] [varchar](255) NOT NULL,

...

Just as a matter of curiousity ... I know I'll get shot down in flames ... but is what is posted above different from ...

SELECT [SalesOrderID], [OrderDate], [Status],

...

I have one situation where I couldn't find any other way of returning the data I wanted.

I have a lot of tables (at least a hundred) with a lot of...

Thanks folks - 2 solutions that do the job. All I need to do now is try to understand!

One thing I definitely don't get is ... the example table just...

EDIT: Sorry - other posts appeared while I was writing this - please ignore.

Thanks for your reply and the link. I'm sorry, but I still don't get it.

CREATE TABLE #SomeTable1

...

I am no expert - in fact I am about as far from being an expert as it is possible to be.

So, what I have written below may be a...

I didn't realise you could write Select * FROM dbserver1.dbname1.table1 when dbserver1 is a different server from the one the query is being run on. What sort of authentication is...

GSquared (3/21/2011)

---

What you're looking at is multi-step authentication. Wince, grit your teeth, and do an online search for "kerberos". You can also search for "NT AUTHORITY/ANONYMOUS LOGIN", and...

Thank you.

Chris Morris-439714 (11/4/2010)

---

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

-- Create a tally table - CAREFUL, this is only 120 rows / numbers

-- and should be used only for this demo

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

DROP TABLE #Numbers

SELECT TOP 120 n =...