Yep, that is another one.

Yea, but I think I should change mine to use <> instead of just >.

Going to require a table scan to accomplish, but something like this may work:

SELECT

*

FROM

dbo.MyTable

WHERE

Amount - ROUND(Amount,0,1) <> 0.0;

Sachin 80451 (6/22/2012)

---

I have a column which has months (1 --> 12).

In my result set I want to show all the data for the next three months. If we were...

You can create inline table valued functions and use those as parameterized views, passing in the appropriate values to obtain the desired result set.

If you really want people to lok at other threads, either here on ssc or other forums, it would help if you would use...

Unless you move data from the larger data file to smaller data file before doing the backup and restore, you are going to need 3 TB of disk space for...

What it will affect is that the transactions that need to go to the mirror database are queued until the mirror is resumed. This means the transactions are not...

Testing is important. Remember; backups are worthless, restores are priceless.

Ages ago I worked as a computer operator. We backed up our databases to 9 track tapes. I...

GBeezy (6/22/2012)

---

Thanks for the clarification! Where I work, one place where a MERGE Statement I think would really work is within a Trigger, have any of you used a...

Duplicate post. Please post any responses here.

One possibility, iirc, is that you could have hyperthreaded cores, which means 16 could be 32. Just a shot in the dark.

Charmer (6/22/2012)

---

oh i read that article, Anothny....Thank you so much...this is what i was looking for...so there will be no choosing option...this is it....mmm....

if you have time , could you...

Lynn Pettis (6/21/2012)

---

herladygeekedness (6/21/2012)

---

Charmer, are you saying that your toolbox is completely empty, or just missing 3rd party tools?

If the former, I'm not sure how to help unless you can...

Munabhai (6/21/2012)

---

Hi SSCoach, it does works great, Instead of "," if I want to put <p> how do I do that? I try all the position but it display at...