TheSQLGuru (6/22/2012)

---

Sean Lange (6/22/2012)

---

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...

sunshine-587009 (6/22/2012)

---

Wow! I never finished writing the messsage and must have accidentally sent because I got busy at work. I am a dba, not a developer which is why I...

To be more descriptive in the normalization issues I figured I should explain what I mean.

You have a column Engineer. I assume this is the column that holds the name...

That is because your data is not normalized. You have multiple rows with the same part number but the description is different. If you had a parts table and this...

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.