thatok (5/14/2008)

---

The two statements are run on the same table. the problem is:

The column headcount does not have a field called transfares, It only has two fields called 'transfarein' and...

adrian_townsend (5/7/2008)

---

I know this may sound strange.... I'm not sure I believe it....but I tested it several times

Currently I have a query where the natural order when run has Record...

Jeff Moden (4/29/2008)

---

This will do it...

--===== Create a table to demo with

DECLARE @DemoTable TABLE (IPAddr VARCHAR(15))

INSERT INTO @DemoTable (IPAddr)

SELECT '192.168.215.1' UNION ALL

SELECT '192.168.23.1' UNION ALL

SELECT '192.168.5.1'...