Viewing 15 posts - 50,296 through 50,310 (of 59,078 total)
p.s.
I don't know what the code is actually trying to do nor why you feel you need dynamic SQL to do it, but if you break all the lines just...
May 25, 2008 at 9:29 am
Issam,
Are you simply trying to slice a given number into slices containing 3 digits each?
May 25, 2008 at 9:09 am
Yes, but that bit of math is the divisor in a larger formula...
CASE WHEN (SUM(CONVERT(NUMERIC,CRC.Contact))*100) <> 0.0 THEN ISNULL(CONVERT(DECIMAL(6,2),(SUM(CONVERT(NUMERIC,CRC.Contact))/(CONVERT(DECIMAL(6,2),(SUM(TalkTime + HoldTime + WrapTime + WaitTime + PreviewTime +...
May 25, 2008 at 9:01 am
If you simply rip the SA rug out from under them, you'll make a lot of enemies... you need to get management to buy into a good security plan where...
May 25, 2008 at 8:55 am
Ok... thanks...
Like the others have said, if you do a Google or other search, you'll find several articles on how to do this. It's just not something that most...
May 25, 2008 at 8:49 am
Marvin,
So, is the CTE a good enough solution for you?
Shifting gears a bit... its pretty clever how they put the test question assessment list together so that it works against...
May 24, 2008 at 8:43 pm
avipenina (5/21/2008)
hi,how can i decrypt a stored procedure in sql server 2005?
THX
I'm curious... where is your source code? Or are to trying to break in on someone else?
May 24, 2008 at 6:13 pm
sharma (5/24/2008)
[font="Arial Black"]TblMaster[/font]
ID NAME
100 James
101 Joseph
102 Felix
103 bernadsha
[font="Arial Black"]TblChild[/font]
ID NAME LOCATION
100 James New Jersy
101 Joseph California
102 Felix New York
103...
May 24, 2008 at 6:10 pm
Obviously, the following creates a zero somewhere...
TalkTime + HoldTime + WrapTime + WaitTime + PreviewTime + DeadTime
What do you want to do when you have a zero in that simple...
May 24, 2008 at 6:06 pm
FROM LD_SDT
LEFT OUTER JOIN WK_SDT_ORGANIZER B ON
...
May 24, 2008 at 5:48 pm
Please check you post... can't see what you posted for the "view".
May 24, 2008 at 4:43 pm
It's easy... don't try to remove the SA login... just change the password and don't give it out to anyone, ever...
May 24, 2008 at 4:23 pm
Matt Miller (5/23/2008)
The funny clothes I can deal with. The tin foil hat on the other hand...:)
Heh! C'mon... I don't wear the hat in public... and no one...
May 24, 2008 at 4:17 pm
Heh... TODD!!!??? Why are you having me figure it out... run it against the table generator I provided and report your findings! 😀
The answer to your question is...
May 24, 2008 at 4:13 pm
Heh... post the other data from the other table and let's see if we can get it down to a couple of minutes, eh? 🙂
May 24, 2008 at 3:55 pm
Viewing 15 posts - 50,296 through 50,310 (of 59,078 total)