TheSQLGuru (6/22/2012)

---

Eugene Elutin (6/21/2012)

---

I cannot understand why would you need dynamic sql for statements there.

Why not to have the same stored procedures in every database and call them dynamic sql....

Shot in the dark...

WHERE Date_Used between @date1 and @date2

???

Lynn Pettis (6/22/2012)

---

Sean Lange (6/22/2012)

---

I certainly hope you don't feel...

I certainly hope you don't feel insulted!!! It just hit...

Lynn Pettis (6/22/2012)

---

Sean Lange (6/22/2012)

---

That my friend is a might fine question. 😛 Sometimes the keyboard starts before the brain kicks in.

Not only is...

That my friend is a might fine question. 😛 Sometimes the keyboard starts before the brain kicks in.

Not only is your solution cleaner it...

OK I modified your ddl a little bit so the sample data will work.

CREATE TABLE #mytable

( ID INT ,

Product Char(50),

Sum INT,

YearValue INT,

MonthValue INT

)

INSERT INTO #mytable

(ID, Product, Sum, YearValue, Monthvalue)

SELECT '4','Green','1000','2012','2'...

Sachin 80451 (6/22/2012)

---

CREATE TABLE #mytable

( ID INT IDENTITY(1,1) PRIMARY KEY CLUSTERED, ...

where Num % 1 <> 0

OK I am done now...otherwise we are going to start into completely ridiculous string manipulation. 😉

Or a better twist on mine than casting to an int.

select * from Nums

where Num <> floor(Num)

LOL got distracted while posting, seems Lynn beat me to the punch with a different approach to the same thing.

Not the best for performance because it isn't sargable but this should work.

;with Nums(Num)

as

(

select 100.00 union all

select 200.00 union all

select 350.01 union all

select 235.07 union all

select 38.10 union all

select 4.006...

Then you will need to become familiar with date routines.

Lynn has some great ones here. http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/%5B/url%5D

You can use that to figure out your starting date. Then you just need...

sunshine-587009 (6/22/2012)

---

Hi there!

I'm trying to get the last update statement to work and it is not work for me. I receive errors on the join. Any help appreciated!

Results I'm looking...

Koen Verbeeck (6/21/2012)

---

Oh god not him.

He's the most important reason I have such a high post count. Trying to help him...