Yes you can. I have 3 instances on my development PC.

To connect to an instance in SSMS, use ServerName\InstanceName

I'm not sure what you'd like explained. We have no sample data etc and obviously no access to the datasource.

You can take a look at http://msdn.microsoft.com/en-us/library/ms178107 to see if it...

Jeff Morden's 8K splitter may be able to help and it's published right here on SQLServerCentral.com ;I used for a similar task sometime ago and it performed perfectly.

See http://www.sqlservercentral.com/articles/Tally+Table/72993/

Good question thanks.

Congratulations!

Ah well, went with my gut feeling and got it wrong but that'll teach me to some research before guessing the answer to a question I don't know the answer...

Thank you again for all your comments and feedback!

I came up with question after seeing some code written by a colleague who had omitted to use brackets in the WHERE...

Good question thanks

L' Eomot Inversé, you make a fair point. BOL could do with some improving in this respect.

Thank you all for you comments - much appreciated!

Good question and great discussion. Thanks!

Thanks for the clarification Hugo - excellent as always. When I grow up I want to be like you.

I think Smart would be nice but I prefer SQL Server not making smart assumptions!

Good question - I use this example myself to teach those new to TSQL.

+1 Anthony.Green

Just had a look at k.subramanyam1017 's profile; it's full of interview questions.

Advice to: k.subramanyam1017: Buy some books and work your way through the examples; it will take you some...