XML and HTML have standard formatting conventions, and when I use tools to write this type of code the tools have a menu option to apply the standards and fix...

SSW has recommendations posted at http://www.ssw.com.au/ssw/Standards/DeveloperSQLServer/SQLServerStandard_3_StoredProcedureFormatting.aspx . They also have lots of guidelines on other topics associated with programming

Andrew Novick's Transact SQL User Defined Function's book has an excellent discussion on Documenation, Formmatting and Naming Conventions in Chapter 6. In this, some of his reasons for the comma,...

Steve, the new feeds seem to be working

thanks

Dean:D

thanks, i figured it was something simple.

It was formatted in SSMS, what do I need to do to keep the formatting when I post it here?

Steve, I notice that when I go to http://www.sqlservercentral.com/Xml/Rss/Articles/Editorial%20-%20MP3/ I just see a list of titles but no actual files are shown. When I go to other...

I'm just looking at the clock in the bottom right corner of the Management Studio window. I highlighted the select statement in my sproc and then clicked Execute

Thanks, but the number of rows was cut in half and there was no reduction in execution time. so I'm still confused:unsure:

Steve, when I subscribe to just the mp3 format in my Zune, I get an error message that "The RSS appears to be valid but there is no content" and...

Steve, I'm still getting 4 files for every show via the Zune marketplace. Have you had a chance to look into this yet?

Dean

you can start with the DB Tuning Wizard that comes with SQL Server.

THANKS

Thanks, is this limitation documented somewhere? I did not see anything telling me that i could not do it the way I was trying to.

Dean

Check out the dynamic sql articles at http://www.sommarskog.se. he provide a good example of how to do this.

Thanks why do recommend staying away from this dynamic sql?

I have mutiple identical dbs (for various companies in my corporation). I need to run the same query against several of...