Viewing 15 posts - 3,061 through 3,075 (of 7,484 total)
It isn't really clear what you are trying to do. Is this what you want:
SELECT party_code, sum(inst_amt) as total_insts, sum(paid_amt) as total_paid
FROM @table WHERE paid_date <...
September 21, 2013 at 9:34 am
Jeff Moden (9/20/2013)
So, could you do the following during a filibuster?
If I understand the rules, no - you have to keep talking except for pauses that can be...
September 20, 2013 at 5:44 pm
Jeff Moden (9/20/2013)
Are you good folks saying that any form of SELECT/INTO is bad? If so, why?
I don't think select into is always bad; I do think that it...
September 20, 2013 at 9:23 am
George M Parker (9/19/2013)
September 19, 2013 at 4:11 pm
steve.fortner 92896 (9/19/2013)
I assume the culture in the UK is similar to the US then as far as college "requirements" for most tech jobs?
Not quite as firmly cast in concrete...
September 19, 2013 at 3:57 pm
Jeff Atherton (9/19/2013)
September 19, 2013 at 3:31 pm
GOODS (9/19/2013)
I'm have same issue:
Msg 468, Level 16, State 9, Procedure RPT_MTX_CDR_CostBreakdown_PerMsisdn, Line 142
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.
I have the...
September 19, 2013 at 2:15 pm
Brandie Tarvin (9/19/2013)
I know half a dozen ways to do what you've requested. But any easier than the easiest way I posted above?If you find one, let me know.
Rather than...
September 19, 2013 at 1:22 pm
Sean Pearce (9/18/2013)
I am not voting because I use all three options.
I use all three options, plus others, but I'm voting for tablet because I've run out of shelf space...
September 19, 2013 at 12:24 pm
GilaMonster (9/18/2013)
L' Eomot Inversé (9/18/2013)
Don't need to is surely an understatement: you are not allowed to, I think?
If you mean the SELECT * INTO, unfortunately that's allowed. I've cleaned so...
September 19, 2013 at 11:20 am
Koen Verbeeck (9/18/2013)
Stefan Krzywicki (9/18/2013)
SELECT * INTO #A1 FROM Table
SELECT * INTO #B1 FROM #A1
in production code? #A1 & #B1 are also...
September 18, 2013 at 5:47 pm
sqlnaive (9/18/2013)
September 18, 2013 at 5:39 pm
amenjonathan (9/18/2013)
Certs are very, very specific and really don't help much (IMO).
Not very much? If they help at all, the recruiter is probably an idiot (unless the cert is...
September 18, 2013 at 5:26 pm
Grant Fritchey (9/18/2013)
carpainter69 (9/17/2013)
September 18, 2013 at 5:24 pm
bcb (9/17/2013)
September 18, 2013 at 5:04 pm
Viewing 15 posts - 3,061 through 3,075 (of 7,484 total)