Viewing 15 posts - 12,811 through 12,825 (of 26,486 total)
SQLCrazyCertified (4/16/2012)
Lynn Pettis (4/16/2012)
SQLCrazyCertified (4/16/2012)
Mike John (4/14/2012)
April 16, 2012 at 2:04 pm
SQLCrazyCertified (4/16/2012)
Mike John (4/14/2012)
It...
April 16, 2012 at 1:46 pm
hbtkp (4/16/2012)
i have this data in 1 tableI1
2.3
4.5
3.4
2.3
1.2
now i need output lik this
cumulative of I1
----------
how to do it
Absolutely no idea. I see no decernable pattern in the values...
April 16, 2012 at 1:44 pm
hbtkp (4/16/2012)
i just need math formula to calculate cumulative field. in sql.is there any build in function
A + B - C. There, a formula as useful as anything you...
April 16, 2012 at 1:37 pm
And then there are those that you think should be able to understand what you are telling them only to have that believe shot out from under you.
April 16, 2012 at 1:35 pm
Looking at this line:
SET@OpenQueryPrefix = @OpenQueryPrefix + ', ''SELECT COUNT(*) AS400TableCount FROM ' -- << and here
AS400TableCount is a column alias, I am naming the column that contains the value...
April 16, 2012 at 1:34 pm
Welsh Corgi (4/16/2012)
Lynn Pettis (4/16/2012)
April 16, 2012 at 1:23 pm
The select count(*) in the openquery still has no alias and you are still doing a select * from the openquery and not assigning anything to the variable that ultimately...
April 16, 2012 at 1:15 pm
Yes, but I would HIGHLY recommend NOT doing it.
April 16, 2012 at 12:59 pm
Welsh Corgi (4/16/2012)
I'm sorry but I do not follow.I do not have a column Alias in the SQL Select?
This:
SET @SQLQuery = 'SELECT @cnt = COUNT(*) FROM ' + @SchemaName...
April 16, 2012 at 12:57 pm
In the actual OPENQUERY, you do a select count(*). Add a column alias there.
In the select that uses the openquery, you simply do a select * from openquery(...)). ...
April 16, 2012 at 12:54 pm
Larry Page(Ehsan.Akbar) (4/16/2012)
Lynn Pettis (4/16/2012)
Phil Parkin (4/16/2012)
So what do you suggest? what should we do to win the match?
Study the play of Barcelona.
Not really anything to do with SQL...
April 16, 2012 at 12:45 pm
Can you add a column alias to the count(*) in the select from the as400 table? If so, then do that, then select that column name in the outer...
April 16, 2012 at 12:43 pm
Phil Parkin (4/16/2012)
So what do you suggest? what should we do to win the match?
Study the play of Barcelona.
Not really anything to do with SQL Server.
Not sure why, but...
April 16, 2012 at 12:32 pm
Viewing 15 posts - 12,811 through 12,825 (of 26,486 total)