Maybe

SELECT * FROM @TABLE T

WHERE T.fldID = @ID or @ID is null

does good work too.

Hi,

I think the left join query is correct. Maybe the subquery (select field1 from tableb) returns some nulls, that can turned out your whole not in expression in UNKOWN instead...

for example : round( 8 * Value) / 8 rounds to the nearest 8th. By the way, i'm sorry for posting several replys, the ideas came to me in batches...

Is just a different aproach that is useful for different scenarios too.

It works for rounding to 8ths, 16th, 32 ths, 7ths, anyways any "th", this case our friend needed to round to 100ths

Hi, i like to use this operation. But i must admit it migth be litle costly:

select ROUND( 100 * (99.7971), 0) / 100

Tower Heist is cool,

Real Steel too

Good deal Vemula =D.

Thank you Divine =D

Hi,

This is a different solution, just to sum up with the good ones you already have.

select distinct a.Peter, m.Mike,m.Steve from ATable a

cross apply(select top 1 Mike,steve,peter from atable...

Hello,

I came up with these query using Divine's table ( i just took off a row 3 person 103 pair because i think they were inserted twice).

select [Rows] .Row,

...

is all good man

I just know i wont say "this don't work" to things that works and i have not tested

well it works on my computer, but i agree that adding semicolons will make it better

Did you tried it before your change??

Hi,

I came up with the following, maybe you like it and is what you need.

Thanks

-- Test table definition

DECLARE @t TABLE(DateStamp DATETIME PRIMARY KEY CLUSTERED, V1 INT, V2 INT)

-- Test data...