Viewing 15 posts - 7,966 through 7,980 (of 15,381 total)
Luis Cazares (6/13/2013)
DECLARE @Something table
(
Years int,
SomeValue int
)
insert @Something(Years, SomeValue)
Values
(2000, 2)
,(2001, 4)
,(2002, 5)
,(2003, 3)
,(2004, 2)
SELECT SUM( SomeValue) SumOfAll, SUM(...
June 13, 2013 at 12:28 pm
Seems like a semi strange requirement but certainly not to bad. Notice how I posted consumable ddl and sample data? This is something you should do in the future.
Here are...
June 13, 2013 at 12:03 pm
Lynn Pettis (6/13/2013)
Sean Lange (6/13/2013)
SQL_beginner1 (6/13/2013)
I get the following error when I parse your script:
Msg 156, Level 15, State 1, Line 6
Incorrect syntax near the keyword 'over'.
I'm using SQL...
June 13, 2013 at 10:04 am
WayneS (6/13/2013)
dwain.c (6/12/2013)
I can only imagine what it must be like to have SQL Server running in some non-English language. MS probably translated the obtuse into the indecipherable.
Maybe the...
June 13, 2013 at 9:22 am
The Dixie Flatline (6/13/2013)
Sean Lange (6/13/2013)
Steve Jones - SSC Editor (6/13/2013)
The Dixie Flatline (6/13/2013)
Brandie Tarvin (6/13/2013)
The Dixie Flatline (6/13/2013)
Don't talk to me about time. Time is my business.
Dixie,...
June 13, 2013 at 9:05 am
SQL_beginner1 (6/13/2013)
Hi Lynn,I get the following error when I parse your script:
Msg 156, Level 15, State 1, Line 6
Incorrect syntax near the keyword 'over'.
I'm using SQL Server 2008 R2.
He missed...
June 13, 2013 at 9:03 am
Steve Jones - SSC Editor (6/13/2013)
The Dixie Flatline (6/13/2013)
Brandie Tarvin (6/13/2013)
The Dixie Flatline (6/13/2013)
Don't talk to me about time. Time is my business.
Dixie, I could kiss you for...
June 13, 2013 at 8:23 am
Abu Dina (6/13/2013)
Troll :doze:
I sometimes like feeding the trolls. They make such interesting sounds as they eat. 😛
June 13, 2013 at 7:33 am
In order to help we will need a few things:
1. Sample DDL in the form of CREATE TABLE statements
2. Sample data in the form of INSERT INTO statements
3. Expected results...
June 13, 2013 at 7:21 am
qotiyqoy1 (6/13/2013)
must popular!!!
Did you have a question?
June 13, 2013 at 7:17 am
afreen281989 (6/13/2013)
Thanks for ur rply..
I am working on Salesforce Platform(Cloud technology) using Apex language..
i have to connect to Sql Server from Salesforce.
Just wanted to know whether any API or...
June 13, 2013 at 7:10 am
Hard to give anything resembling specifics with not much detail. I think it would be far better if you can get rid of the looping and just do an update....
June 12, 2013 at 2:33 pm
rick_markham (6/12/2013)
June 12, 2013 at 2:17 pm
sql1411 (6/12/2013)
X200, 516, XD1, YTG, 24ZY, 40Y, 01DX
Now, I just need the numeric...
June 12, 2013 at 2:03 pm
SQLRNNR (6/12/2013)
Steve Jones - SSC Editor (6/12/2013)
jasona.work (6/12/2013)
June 12, 2013 at 1:35 pm
Viewing 15 posts - 7,966 through 7,980 (of 15,381 total)