The only other way would be build the string dynamically.

None that I am aware of unless you use something other than CR/LF to mark then end of your line. That is why there appears to be one extra line....

Curious where did you come across information that EXISTS performs better than IN. I have tested EXISTS, IN, ANY and INNER JOIN for these types of queries and only the...

Interesting information. If you test it out please follow-up here so others can see your results.

But you run the risk of getting invalid data due to dirty reads.

No the idea is to apply most restirctive. It is not a design flaw as you can have a user who is a member of 2 different Roles in the...

Then Ian's solution should be close to what you are after.

Forgive me as I don't have a sytem to test with here, but I think it was one of these three

1) either the windows firewall was blocking the install

2) file and priunt...

No all get the ID value for the related SP, they have no other relationship otherwise.

If you just need to show on a day by day basis and do not need to break down into Year, Month, Day then this might shave a bit off,...

To save maintenance you can create a role to put your users in for and grant EXECUTE on individual procs and/or functions to the role instead.

Or just use

LEFT(ColName,6)

cause fortunately FAILED and PASSED are the same length.

Many different was to do this. It is called a pivot table and there have been many responses on this. But for your answer the question is how do you...

I would double check the article and see if doesn't mention Merge replication as that is the only one I know you can drop that setting.

However that said check that...

What is your indexes fill factor? It shouldn't be on an order of a magnitude as the reindex does copy the index into new pages and drop the old pages once...