Viewing 15 posts - 6,061 through 6,075 (of 10,144 total)
krishnaprasad14 (7/10/2012)
Hi,I am geting this error when I try to run a quer through SSMS.
Table got 23000 records and SQL srever max memoy assigned 3024.
Thank you in Advance,
Krishna
Run the results...
July 11, 2012 at 5:25 am
-- with CostsNet in the GROUP BY, there's no aggregate of CostsNet
-- Try the original query with and without SUM
-- Then take CostsNet out of the GROUP BY and check
--...
July 11, 2012 at 4:34 am
Hello and welcome to ssc. Please read the link in my sig (click on the word "this"), which will show you how to create sample data for folks to code...
July 11, 2012 at 1:55 am
After you have populated the variables, how do you use their values?
July 11, 2012 at 1:50 am
Jeff Moden (7/10/2012)
Ok... I've been looking at this thread for a bit for "Sam's view definition" and I'm not finding any "SAM" that posted. Did you mean "Chris' view...
July 10, 2012 at 9:41 am
Jeff Moden (7/10/2012)
ChrisM@Work (7/10/2012)
Jeff Moden (7/9/2012)
July 10, 2012 at 9:38 am
anthony.green (7/10/2012)
I had a couple of pints of St Austell's Tribute on Saturday, that was a good tasting ale
Lovely stuff - FGW sell it on board their trains.
July 10, 2012 at 9:19 am
Stuart Davies (7/10/2012)
http://www.marstonsbeercompany.co.uk/our_brands/marstons/oldempire.asp
and the other here
http://www.innisandgunn.com/en/the-range/original.aspx
Not beers for drinking by the bucket full though - they pack a bit of a punch as...
July 10, 2012 at 8:52 am
GSquared (7/10/2012)
July 10, 2012 at 8:47 am
GSquared (7/10/2012)
ChrisM@Work (7/10/2012)
Jeff Moden (7/9/2012)
July 10, 2012 at 8:02 am
Jeff Moden (7/9/2012)
July 10, 2012 at 6:53 am
There's no aggregate in my previous post:
SELECT @90000119Sum = Avamel
FROM V_Factor_Total4
WHERE cslPricingFactorRef = '95'
AND ProductCode = '90000119'
Why do you need a cursor for this?
Performance is likely to be very...
July 10, 2012 at 5:42 am
eh.shams (7/10/2012)
it is not agggregation, the name of my variable is (90000120sum)
SELECT @90000119Sum = Avamel
FROM V_Factor_Total4
WHERE cslPricingFactorRef = '95'
AND ProductCode = '90000119'
July 10, 2012 at 5:31 am
eh.shams (7/10/2012)
While @@Fetch_Status = 0
Begin
select
CASE
WHEN (@ProductCode = 90000119) and (@cslPricingFactorRef =...
July 10, 2012 at 5:20 am
eh.shams (7/10/2012)
because i need to analysis each row of cursor , and make decision by value of column
Like this:
CASE
WHEN (@cslPricingFactorRef= 90000119) THEN (SELECT @sum=@Avamel)
What are the other decisions?
July 10, 2012 at 4:56 am
Viewing 15 posts - 6,061 through 6,075 (of 10,144 total)