Viewing 15 posts - 54,001 through 54,015 (of 59,068 total)
Loner (11/22/2007)
They are interested in engineering, not computer programming.
You're right... Engineer's never use computers 😛
November 22, 2007 at 6:24 pm
If you make no major assumption about the string other than it's going to have digits on the left and non-digits on the right, you end up with something that...
November 22, 2007 at 6:14 pm
dgvsbabu (11/21/2007)
using replicate function and u can solve it
Well? No code? 😉
November 22, 2007 at 5:44 pm
I suppose you could hardcode some SUBSTRING lookups using CHARINDEX and the like... but, I like to remain, well, "flexible"... 😉 Soon as you ask for the second part,...
November 22, 2007 at 5:41 pm
Add an identity column to the staging table and use that as a key to drive a large control loop to insert a couple of hundred thousand rows at a...
November 22, 2007 at 5:13 pm
Jeff, you have to force the conversion to numeric before the division operation
Thanks, for the catch, Michael... more coffee! 😀
November 22, 2007 at 5:11 pm
i am asking the difference between programmer and good programmer.
Knowledge of all things...
A good programmer will have an extreme knowledge of the language (s)he's writing in, understand/how to use external...
November 22, 2007 at 11:15 am
Combination of PATINDEX (to find the string) and SUBSTRING (to extract the string) should do it.
November 22, 2007 at 11:02 am
Man, you're on a role with all these questions... and most of them are so general in nature that it's not possible to give a decent answer. For example......
November 22, 2007 at 11:00 am
Who said there're jobs at SQLServerCentral.com?
November 22, 2007 at 10:55 am
If what you mean by "written skill" is "writing skills in the English language", then take some English courses, practice talking with people in English, and then maybe take a...
November 22, 2007 at 10:53 am
Maybe it was just by chance, but the result set you posted originally showed the "middle of the pack" for column B... the aggregate you settled on won't do that.
November 22, 2007 at 10:46 am
I'm looking everywhere to write easily the result of an T-SQL query in an output file.
The use of xp_CmdShell to fire off BCP or OSQL would definitely be the way...
November 22, 2007 at 10:36 am
max (11/22/2007)
I swear vb result is 3.85185988877447E-34 !! (how can i attach an image to a new post?)SQL result is 0
I'm actually using FLOAT instead REAL.
Thank you
Regards,
Max
When you create...
November 22, 2007 at 8:20 am
Viewing 15 posts - 54,001 through 54,015 (of 59,068 total)