Hi Chris,

The fundamental fact I was missing (ability to have 'AND column = value' in joins) wasn't in that post but it was highly informative, all the same.

Thanks for your...

That's exactly what I was looking for. Thank you!

The part I was missing was the ability to have an AND clause as part of the JOIN. I have to admit...

Many thanks guys.

I wondered if there was a better way than getting involved with temp tables and things but I guess not. Tally table it is then...

He may indeed be thinking about an issue that no longer exists in SQL 2005. I shall have a look at some execution plans when I get a chance.

Many...

I really appreciate all of your input guys.

Many of your queries generate identical query plans to my original at small numbers of rows. I shall see if this is...

Thanks for your response.

Sorry for sounding like a simpleton but do you have an example of how I would use PIVOT to format the query? PIVOT and...

That's pretty much what I ended up doing 🙂

Thanks for your reply.

Paul.

Thanks for all of your help guys. It's much appreciated. 🙂

The second query is perfect. Thank you very much!

Just goes to show how much I still need to learn about T-SQL 🙂

Cheers,

Paul.

Many thanks for your replies.

Here is some sample data to help visualise the problem:

First create and populate the tables:

CREATE TABLE FileTable(

ChainID INT NOT NULL,

Filename VARCHAR(256) NOT NULL

)

INSERT INTO FileTable(ChainID, Filename)

SELECT...

I use PowerGUI Script Editor too and have the same concern. The way I get around it is to put "return 0" as the first line of code and...

Have a look at the command Import-CSV. It takes a comma delimited file as input and returns corresponding objects.

The first line of the file needs to be a...

That's perfect GSquared, thank you so much!

Apologies for the error in my example. I spent so much time worrying about anonymising the data that I managed to let that...

Thanks for your replies.

Unfortunately when I try to restore the Master DB to the test server under a different name I get the following error:

"System.Data.SqlClient.SqlError: There is already an object...