or refer http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=81254

Jeff Moden (9/21/2008)

---

Only way I can figure out to do that is to look in Books Online and make a table with the given mins and maxs for each...

Kerrie Jones (9/22/2008)

---

I have the following piece of SQL code which runs without any problems:

SELECT year, Q1Amt + Q2Amt + Q3Amt + Q4Amt AS Actual

FROM Table1

WHERE (buildingID = @buildingID)

ORDER...

Luke L (9/16/2008)

---

I'm slightly concerned with your approach here as it seems what you are doing flies in the face of all things relational. Any chance you could give...

Many newbies are not beware of implicit convertions 🙂

http://sqlblogcasts.com/blogs/madhivanan/archive/2008/01/16/beware-of-implicit-conversions.aspx

Jeff Moden (9/18/2008)

---

Heh... not exactly true...

SELECT *

INTO #MyHead

FROM OPENROWSET('SQLOLEDB','Server=(local);Trusted_Connection=Yes;Database=Master',

...

Also read this

http://sqlblogcasts.com/blogs/madhivanan/archive/2008/02/19/understanding-single-quotes.aspx

gunapandian.mca07 (9/18/2008)

---

sql query to find a particular word in a field of table

eg: in a field, gunapandian is a name, if i give "gun" it should give the row id.

those...

Nuts (9/18/2008)

---

Hi Guys

I have a column with the figures which have 4 decimal points.

I want to trim them to two decimal points.

How do I do it??

Can it be done...

avani104 (9/19/2008)

---

In the query below:

FieldValueID-nvarchar(50) [since it can hv comma separated values 1,2]

ID - int

Select CountryName from EYARDMasterCountry where ID in (FieldValueID)

but this give an error...how do i read...

I am not sure if this works

where ActualTime >0

The proper way would be

group by dateadd(day,datediff(Day,0,date_col),0)

Also refer http://sqlblogcasts.com/blogs/madhivanan/archive/2007/12/21/count-number-of-words-in-a-string.aspx

Post some sample data with expected result

May be the old thread but I want to show you other approaches

http://sqlblogcasts.com/blogs/madhivanan/archive/2007/08/27/find-nth-maximum-value.aspx