Viewing 15 posts - 1,696 through 1,710 (of 3,232 total)
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
June 12, 2008 at 10:14 am
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....
June 12, 2008 at 9:54 am
Yep, you're right. Nice catch.
June 12, 2008 at 9:33 am
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.
June 12, 2008 at 9:24 am
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...
June 12, 2008 at 8:44 am
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.
June 11, 2008 at 4:46 pm
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...
June 11, 2008 at 4:43 pm
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?...
June 11, 2008 at 4:37 pm
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...
June 11, 2008 at 4:33 pm
OK, that's a start. How about some sample data and your desired results?
June 11, 2008 at 4:30 pm
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...
June 11, 2008 at 4:24 pm
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?
June 11, 2008 at 4:02 pm
Yes, but this would appear to me to be more of a business rule. How does the data initially get inserted into the table?
June 11, 2008 at 3:57 pm
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...
June 11, 2008 at 3:40 pm
How are you doing the import?
June 11, 2008 at 3:38 pm
Viewing 15 posts - 1,696 through 1,710 (of 3,232 total)