Viewing 15 posts - 47,686 through 47,700 (of 59,064 total)
Matt Miller (10/15/2008)
Jeff Moden (10/15/2008)
In that case, I'd use a FILL Factor of 100 for that tiny bit more speed on any SELECTS you may do on the table.
True -...
October 15, 2008 at 9:48 pm
rbarryyoung (10/15/2008)
So that's in-between LGD and Cryptographic? And I don't see any varbinary(MAX) or sql_variant data-types. 😀
Heh... no... It's somewhere in between a pork chop and a chicken...
October 15, 2008 at 9:46 pm
In that case, I'd use a FILL Factor of 100 for that tiny bit more speed on any SELECTS you may do on the table.
October 15, 2008 at 7:20 pm
Garadin (10/15/2008)
This solution is a variation of Jeff Moden's Running Total Technique, which can be found here:http://www.sqlservercentral.com/articles/Advanced+Querying/61716/
Thanks for the "pass back", Seth. After Matt's index suggestion, looks like you've...
October 15, 2008 at 7:15 pm
David O (10/15/2008)
Once you get your formatting issues fixed the function is datediff. Check out Books on line for the details of the function.
Actually, once converted, you can just...
October 15, 2008 at 7:02 pm
According to the following...
http://msdn.microsoft.com/en-us/library/aa258866(SQL.80).aspx
... the Test returned is of the data type TEXT which can contain up to 2 billion characters. But, the largest "column width" you can set...
October 15, 2008 at 6:58 pm
Marianne,
Actually, I'd be very interested in the performance of the queries. Could you tell us how many rows ended up in the table and how many of them had...
October 15, 2008 at 6:49 pm
eric (10/15/2008)
Nevermind.....I found my mistake....after 3 hours. I tried to delete the post but it's not working !
Would you mind telling us what your mistake was? Might save...
October 15, 2008 at 6:16 pm
sudrav (10/15/2008)
1. ...
October 15, 2008 at 6:15 pm
The way you deal with different coding styles is by insisting that there only be one coding style. Publish and enforce a set of standards including such arcane things...
October 15, 2008 at 6:08 pm
I guess I don't understand... what's wrong with having the double quotes in the column headers? That's how a true CSV file should be formed.
October 15, 2008 at 6:02 pm
we had a similar problem just last week. Couldn't explain it and still can't. All I know is that we stopped SQL Server Agent and restarted it. ...
October 15, 2008 at 5:59 pm
GAURAVKAUSHIK26 (10/14/2008)
Thanks for response. Can you please provide me any code or syntax that imports csv/txt file into SQL CE without SSIS/DTS.
Sure... if the file has no company private or...
October 15, 2008 at 11:44 am
Yep... I agree, Kevin... especially if you have a function like "ToWords". That and RegEx Replace seem to be pretty good.
October 15, 2008 at 8:14 am
Derek Dongray (10/15/2008)
Matt Miller (10/14/2008)
October 15, 2008 at 6:27 am
Viewing 15 posts - 47,686 through 47,700 (of 59,064 total)