Viewing 15 posts - 1 through 15 (of 50 total)
Mark,
will you consider foreign candidates and/or remote worker?
Nicolas
May 2, 2006 at 11:46 am
Hi Drew
My name is Nicolas and i have a question... is there any possibility for a foreign candidate? I would need sponsorship for a visa, and perhaps some relocation assistance.
I'm...
March 11, 2006 at 7:40 am
Hi, I can´t understand what are you trying to do... if your query returns just a single record sum(x) = x because there...
January 12, 2006 at 5:27 am
Yup, so, you can put it all into one single string and execute it using EXEC(@MyVar)
And that, would by simple just using a select statment
Something like that, obvoiously into a cursor...
November 11, 2005 at 8:17 am
Hey... tk, check at BOL the correct syntax of EXEC...
You musn't pass a single string with parameters, you have to pass parameter's values for each parameter...
so EXEC @rc...
November 11, 2005 at 6:25 am
Luciana...
Here is a pretty small solution for you. Please implement something like that and forget all aobut cursors and d-sql. You don´t need it. TSQL is great and nice....
October 27, 2005 at 10:25 am
Luciana
what EHC is saying is to use his simpler solution instead the cursor, you don´t need the cursor...
You can use a single function... which calls Split2Table to obtain data in...
October 26, 2005 at 12:27 pm
Luciana:
It seems like you're forgotting to use the parameters in you sql ... here is the sintax of sp_executesql... try out it and use the @params to define...
October 26, 2005 at 8:26 am
you said... i.e. the implicit conversion of Value2 an nvarchar(8) to a datetime value
Hi David,
In the structures you've mentiones Value2 is a numeric in both tables.
I think that...
October 26, 2005 at 8:15 am
Terrence, is your client considering foreign candidates? I would need a visa to get there.
Nicolas Donadio
from Argentina
October 18, 2005 at 8:53 am
YES YES YES YES
The tempdb has different collation... but I wonder why never we've had problems...
Thanks a lot... I would try to make them change it...
Nicolas
August 2, 2005 at 7:49 am
I'm sorry... I just forgot to translate... replace VALOR for VALUE (same meaning different language).. the original was in spanish, but I translate var names to english before post and...
August 2, 2005 at 6:44 am
PLease, note that this function is just to run on a specific DB...
ALTER FUNCTION dbo.FloatToStr
(@Value float, @fmtMoney bit,
@Decimals bit, @Thousands bit)
RETURNS...
August 1, 2005 at 9:01 am
It just performs a
@Result = ' $ ' + LTRIM(LEFT(CONVERT(CHAR(16), CAST(@VALOR AS MONEY), 1), 13))
where @Result is a varchar(20)
Nicolas
August 1, 2005 at 8:28 am
Viewing 15 posts - 1 through 15 (of 50 total)