Viewing 15 posts - 7,051 through 7,065 (of 10,144 total)
brainblower13 (11/16/2010)
SOURCE DATA:COLUMN NAMES:ID ,STREAMID ,OFFEREDTIME ,TERMINATEDTIME ,Menuname,Prevmenuname,NextMenuName,ivrdisconnected,CallerANI,CallerDNI
200 , 160#A31 ,2010-06-01 01:29:59.000,2010-06-01 01:29:59.000,Account,Agent,Agent Transfer,13,9865,9678
221,160#B31,2010-06-01 02:29:59.000,2010-06-01 01:29:59.000,MenuName,Repeat Offer,Account,15,998,997
222,160#c#1,2010-06-01 03:29:59.000,2010-06-01 02:29:59.000,Previousmenu,Account,Agenttransfer,16,997,09
This doesn't work. What Lutz is asking for is a CREATE...
November 16, 2010 at 2:07 am
chintalagiriprakash (11/16/2010)
hello chrissits no were use for me iam getting all wrong data with ur query so please change my query as per my requirement
regards
Prakash
November 16, 2010 at 1:52 am
What version of SQL Server are you using?
November 16, 2010 at 1:47 am
Jack Corbett (11/15/2010)
Appreciate the advice coming from y'all on my burn out thread.
Plenty of 20/20 hindsight in there, Jack. Everything you need to know and then some. Take it easy,...
November 16, 2010 at 1:46 am
Steve Jones - SSC Editor (11/15/2010)
Heard from Barry. He's fine, just busy.
Good news to start the day. Thanks Steve.
November 16, 2010 at 1:43 am
It will get better, it doesn't seem likely right now but it will. The best advice that can be given has already been posted - if you can't see the...
November 15, 2010 at 10:23 am
Brandie Tarvin (11/15/2010)
November 15, 2010 at 9:05 am
Kit G (11/15/2010)
Chris Morris-439714 (11/15/2010)
Kit G (11/15/2010)
Chris Morris-439714 (11/15/2010)
Torque. New longbow is ready for collection. 130#@32", hickory / satinwood / ipe.Jealous
You can play, Kit!
I would have to work up to...
November 15, 2010 at 7:20 am
arty 15255 (11/15/2010)
Does that mean that looping through each character is better?
Yes, if it means avoiding an unnecessary table scan!
if @@rowcount>0 goto r
"If the last iteration f the UPDATE performed...
November 15, 2010 at 7:09 am
arty 15255 (11/15/2010)
Why nobody likes my solution without UDF, WHILEs, Dynamic SQL statments, etc ...🙂
...snip...
Because it has a loop?
Or because it has to perform n table scans, where...
November 15, 2010 at 6:57 am
Kit G (11/15/2010)
Chris Morris-439714 (11/15/2010)
Torque. New longbow is ready for collection. 130#@32", hickory / satinwood / ipe.Jealous
You can play, Kit!
November 15, 2010 at 6:50 am
Torque. New longbow is ready for collection. 130#@32", hickory / satinwood / ipe.
November 15, 2010 at 6:42 am
This query looks as if it was originally written by a programmer then messed about with by someone who is very unsure of what they are doing. The end result...
November 15, 2010 at 6:14 am
Not sure what an "Index Calculation" is, unless it's a computed column associated with an index?
Anyway, here's an alternative to the QU (quirky update) method, a recursive CTE. It's...
November 15, 2010 at 5:14 am
Jeff Moden (11/14/2010)
Report 1: (Repeating Amount and how many days it is repeating) for the last 30 days from the current date.
Lutz and Chris,
I'm not sure what's going on...
November 15, 2010 at 2:20 am
Viewing 15 posts - 7,051 through 7,065 (of 10,144 total)