Viewing 15 posts - 32,971 through 32,985 (of 59,102 total)
sqlfriends (8/5/2011)
Our production server will be enterprise version
For the license issue, can I just use developer version for...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 7, 2011 at 2:54 pm
Gosh, NO! You shouldn't ever save formatted dates and times in the database. It messes up just about everything and it's a real pain when the user changes...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 7, 2011 at 2:47 pm
sdgray01 (8/7/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 7, 2011 at 2:41 pm
Do you always want to show Jan thru Dec or do you really want to show comparisons for the previous 12 months? For example on the previous 12 months......
--Jeff Moden
Change is inevitable... Change for the better is not.
August 7, 2011 at 10:11 am
Could you attach a text document containing a couple of lines of the "rich text/html formatted data", please? We also need to know what the maximum number of characters...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 7, 2011 at 10:06 am
sdgray01 (8/7/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 7, 2011 at 9:57 am
trstringer (8/6/2011)
Nobody?! I had to further tweak that code because it was moreso a SELECTed column in an INSERT VALUES clause. But that's the gyst of it.
Heh... you've...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 7, 2011 at 9:16 am
anand_vanam (8/6/2011)
I am facing hard time in configuring the BCP command to to import data from txt file (Pipe as Field terminator)into SQL Table.
As the TAB is the...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 6, 2011 at 2:38 pm
The clean version is "Can't Remember Stuff". 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
August 6, 2011 at 2:32 pm
ankit.shukla1105 (8/6/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 6, 2011 at 2:25 pm
shank-130731 (8/3/2011)
Example date: 2011-01-02 00:00:00.000
SET @ETD = '%' --works as expected, all rows
SET @ETD = ''...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 6, 2011 at 2:21 pm
Please see the first link in my signature line below for how to get quicker and coded answers for future posts.
This is the way you should post data for problems...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 6, 2011 at 2:11 pm
gah (8/6/2011)
https://mvp.support.microsoft.com/gp/mvpbecoming
List of SQL MVPs.....dbl click on any name to give an idea of the committment these people make to the...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 6, 2011 at 1:25 pm
I understand what you're trying to do and this is an easy thing to do, Sean. If you would post the data in a readily consumable format (see the...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 6, 2011 at 1:22 pm
BCP with a BCP formatfile would do this easily and with great speed. You could also create a VIEW of the data were the column datatypes are CHAR(2), CHAR(6),...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 6, 2011 at 1:13 pm
Viewing 15 posts - 32,971 through 32,985 (of 59,102 total)