Viewing 15 posts - 53,881 through 53,895 (of 59,068 total)
Heh... wasn't so concerned about IBM as I was that folks thought a megabyte was either 1,000 bytes or 1,024 bytes. Thanks for the edit...
November 27, 2007 at 9:41 pm
Heh... it depends... is the spoon and the plate there?
November 27, 2007 at 9:38 pm
Um... no, I don't think so... a Mega byte is a binary million bytes, not a binary thousand.
Convert from Bytes to KBytes by dividing by 1,024.
Convert from Bytes to MBytes...
November 27, 2007 at 9:10 pm
I need this to be a single create statement.
Why?
November 27, 2007 at 8:59 pm
Ananth,
Are you all set with your running total problem? Was the link that Andras provided sufficient or do you need something a bit more specific? Just wanna make...
November 27, 2007 at 8:16 pm
karthikeyan (11/27/2007)
Jeff,Gathering Running total only is not my job. Really i am trying to give answers which comes under my knowledge.
for your reference,;)
----------------------------------------------------------------
http://www.sqlservercentral.com/Forums/Topic425244-169-1.aspx
----------------------------------------------------------------
Sounds a bit arrogant, Karthik... perhaps it's the...
November 27, 2007 at 8:15 pm
No-one has suggested writing a VBS file using ADO to loop through the recordset writing to a file at each iteration
The reason I've not suggested such a thing is that...
November 27, 2007 at 8:09 pm
What does change is I pull a subset of the columns (50-70%) and modify their datatype and/or...
That would be part of the reason why things take so long... why...
November 27, 2007 at 8:07 pm
If it's within the same proc, yes... I'll many times use a temp table with indexes, etc. If there are several procs that require the same process, I'll build...
November 27, 2007 at 8:04 pm
OMG! ROFLMAO! Just when I stopped laughing at this, I laughed again! Way too funny! Lordy, I love dry humor! Thanks for making my day,...
November 27, 2007 at 5:43 pm
What? Oh? OH? OOOOOHHHHH!!! BWAAAA-HAAAAAA-HAAAAA! WHOOOOO-IIIIEEEEEE! SNNOORRRTTT! Now, THAT's funny, David!!!! OMIGOD!!! I CAN'T QUIT LAUGHING!!!! TOO FUNNY,...
November 27, 2007 at 5:32 pm
Karthik,
No... that's what a lot of folks do and it's not database design. For starters, each table should have a primary key (as well as having a clustered index...
November 27, 2007 at 5:24 pm
Actually... I like VSS. No, it won't merge your code for you or handle branches, etc, etc. But guess what? I'm not a Java programmer! 😉
If people...
November 27, 2007 at 4:49 pm
Thanks for the feedback, John! Yeah, same thing here... sometimes the language barrier is a bit difficult to get through, but a well formed Create Table statement cut's through...
November 27, 2007 at 4:42 pm
Viewing 15 posts - 53,881 through 53,895 (of 59,068 total)