I have often found that drinking helps in these situations. 😛 Good luck.

Not to mention if some of the columns are blobs (image, text, etc). Why select *? You should only select the columns you actually need.

This seems to be the beginning of the problem. Is there no primary key for this table?

Try something...

As it sits there is no order by anywhere in this so there is no guarantee about what order it will be returned in.

On another point, this looks like it...

I will jump on the bandwagon of not getting the convert to char but will point out that I never like code that just uses the default size for datatypes....

LOL (irl). I can't count how often I laugh at your picture. Sadly it is how I feel today. Unfortunately it is not SQL, it is the dreaded evil browser...

😎 current score 1 - 1

Learner1 (11/2/2010)

---

Thanks but, I cannot use it in a subquery as I have to store the Level value in a variable and then have to add a LOOP to...

Lowell beat me to the punch again. 😛

You don't need more than 1 select to solve this. Try this...

with cte1

as

(

select a,b,c,level

from abcd

)

select a,b,c from cte1

where Level = (select MAX([LEVEL]) FROM...

steveb. (10/29/2010)

---

I agree with this...

Also if you use your datetime column is the primary key and you have a child table, you will end up with a datetime column as a foreign key. That...

As a current day woodworker, and a family history of woodworking I would likely be either a carpenter or work in the creamery like my grandfather did. :w00t:

The point was that internally they both...

Not sure what you mean by what should you do with it???

on dbo.fady_match (Depots.DepotNumber) =...