Viewing 15 posts - 11,161 through 11,175 (of 15,381 total)
kevmck (7/30/2012)
July 30, 2012 at 3:22 pm
Are you trying to figure out which tier a person should belong to? In other words this sounds like you are trying to write a GetPersonTier function or something like...
July 30, 2012 at 2:17 pm
Abu Dina (7/30/2012)
July 30, 2012 at 1:46 pm
Luis Cazares (7/30/2012)
Thanks Sean, but I was joking with this because I'm not sure palindromes count as a "practical application".
Well of course but it was rather fun to write in...
July 30, 2012 at 1:44 pm
Performance on this is going to be awful. You where clause is full of non-SARGable predicates.
It seems you have a number of duplicated checks in each pass too. You join...
July 30, 2012 at 12:30 pm
Luis Cazares (7/30/2012)
You can use it to check if 2 phrases are palindromes.Just kidding.
create function IsPalindrome(@String1 varchar(100), @String2 varchar(100))
returns table
return
(
select Case when @String1 = REVERSE(@String2) then 1 else 0 end...
July 30, 2012 at 12:12 pm
eric.rini (7/29/2012)
For example a physical authentication like linking an account to a mobile phone (it sends u a text with a unique key to login) or using a token like...
July 30, 2012 at 10:41 am
erics44 (7/30/2012)
nope trigger fixed
Sweet!! 😀
July 30, 2012 at 8:53 am
Alright Jeff, thanks! Im here back at the office and I am trying to change the loops into the code you have given me. I cant seem to understand how...
July 30, 2012 at 8:46 am
Sean, RoundRuppee isn't a scalar udf, it is a stored procedure.
Yeah, that's what I meant. 😉
July 30, 2012 at 8:37 am
GilaMonster (7/30/2012)
exec [WageGenProcForSCons-2] 2
That will certainly fix the ability to call this but the real issue here is the code itself.
To the OP. Some might actually consider it a good...
July 30, 2012 at 8:26 am
erics44 (7/30/2012)
ahhhhhhhhhhhsomeone has been medalling
thanks for the reply
If it was a trigger then you seriously need to fix that trigger to handle multiple row statements. Don't just work around the...
July 30, 2012 at 8:08 am
morepainot (7/27/2012)
I cant tell if you guys are being sarcastic or not...
I can't speak for anybody else but I was not. Knowing Lynn and Jeff as well as I do...
July 27, 2012 at 3:21 pm
Lynn Pettis (7/27/2012)
Sean Lange (7/27/2012)
Jeff Moden (7/27/2012)
morepainot (7/27/2012)
but I need a better format instead of creating 5 seperate temp _tables
Tell them what you told me in the email you sent...
July 27, 2012 at 3:10 pm
Viewing 15 posts - 11,161 through 11,175 (of 15,381 total)