umm....you have to exec your dynamic sql before you can get results. All you have done is build a string and then select it.

sqlbi.vvamsi (4/16/2012)

---

Ok. Here it is

CREATE TABLE [dbo].[test](

[a] [numeric] NULL,

[date] NULL

) ON [PRIMARY]

GO

ab

11981-08-14

21985-10-03

32012-04-13

select SUM(a) from test group by b having b=CONVERT(date,GETDATE())--This returns nothing

select SUM(a) from test where b=CONVERT(date,GETDATE())--This returns...

Keep in mind that returning null is a row. When your query finds no rows like in your example it can't return null because it did not return any rows....

Define not working. Did it return the wrong value? Did it return...

hbtkp (4/16/2012)

---

MAY BE U CAN understand by this

NUMBER CUMULATIVE

...

Eugene Elutin (4/16/2012)

---

Sean Lange (4/13/2012)

---

Here is how all of the threads that you have started sound.

There were two crocodiles flying. One to the south but another one was blue.

Question:...

Look at the splitter in my signature.

Depending on some details from...

I do not think you need a loop to do this at all. If you can post ddl and sample data (insert statements) along with desired output based on your...

L' Eomot Inversé (4/13/2012)

---

Jeff Moden (4/13/2012)

---

capn.hector (4/13/2012)

---

ok on topic: http://www.sqlservercentral.com/Forums/Topic1283271-392-1.aspx how do you long time posters keep going when you run into people like this. (one thread...

HUH?

parameter sniffing? cached plans? stale statistics? Could be any of those. From your brief description it sounds like a "catch all" type of query. Take a look at Gail's blog...

GilaMonster (4/13/2012)

---

Just a feeling. Vagueish questions, little response to replies...

Not saying there's a problem, but...

Evil Kraig F (4/13/2012)

---

capn.hector (4/13/2012)

---

ok on topic: http://www.sqlservercentral.com/Forums/Topic1283271-392-1.aspx how do you long time posters keep going when you run into people like this. (one thread there are...

zojan (4/13/2012)

---

Sean Lange (4/13/2012)

---

jzoran (4/13/2012)

---

If the request is reduce time of execution from 20 min to 20 sec the only one possibility is checking indexes (missing indexes or it could...

jzoran (4/13/2012)

---

If the request is reduce time of execution from 20 min to 20 sec the only one possibility is checking indexes (missing indexes or it could be right index...