Just wanted to say thanks for sharing. The article was well thought out and well written. The level of detail in your object descriptions was great. I...

It may interest you to know that you can get fn_get_sql from Microsoft without upgrading to SP3. See here: http://support.microsoft.com/kb/325607/en-us

Bulk Insert is just taking what you have in your data file. If the source data has the extra double quotes, bulk insert will treat them as wanted data....

Yep, you're right. Nice catch.

Wow, you guys got an early start today. I'll echo everything Peso has posted. Very sound advice as usual Peter. Thanks for joining in.

You don't need a cursor to do this. Keep in mind this has not been tested as it is based off of the last example:

alter function str_data_list(@keyvalue int) returns...

This value is passed in the connection string as ApplicationName. If you want to uniquely identify connections, you'll have to have them identify themselves in the connection string.

In your first example, the optimizer can use the value you've passed in (1001) and actually look at the distribution of the index to determine if an index seek could...

Once you have the data in the table, how are you accessing it? Is it always by Project, or do you typically look at it by date as well?...

Your description is pretty vague. Can you describe what you mean by compress/decompress. How about giving us some examples using SQL statements and sample data? It would...

OK, that's a start. How about some sample data and your desired results?

Without documentation, it's hard to say. It does appear that the SoundExe values are all comprised of the left most X characters of the name, although I cannot see...

Can you post your BULK INSERT statement and a couple of lines of sample data mimicing what your data looks like with regards to the quotes?

Yes, but this would appear to me to be more of a business rule. How does the data initially get inserted into the table?

This looks like a story problem. This sounds pretty simple, but you'll have to help out a bit with some sample data and desired results. See the link...