To be fair, DLINQ, with it's dynamic SQL, is good for quickly creating prototypes. Also, if you decide to cache some data as XML, it saves having to know too...

I started the query with the PO_MX table as you were looking for PONumbers - I find this easier but you can start with any table you like.

You should also...

In addition, derived tables, also known as inline views, could be used instead of HAVING:

SELECT PO_MX.PONumber

FROM PO_MX

&nbsp&nbsp&nbsp&nbspJOIN

&nbsp&nbsp&nbsp&nbsp(

&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbspSELECT EJ.PONumber, SUM(EJ.Amount) AS Amount

&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbspFROM EJ

&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbspGROUP BY EJ.PONumber

&nbsp&nbsp&nbsp&nbsp) D1

&nbsp&nbsp&nbsp&nbspON PO_MX.PONumber = D1.PONumber

&nbsp&nbsp&nbsp&nbspJOIN

&nbsp&nbsp&nbsp&nbsp(

&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbspSELECT PO_DX.PONumber, SUM(PO_DX.QuantityOrdered...

Without DDL and test data it is difficult to know what you want.

Maybe you need to use the ROW_NUMBER() function like:

SELECT *

FROM

(

&nbsp&nbsp&nbsp&nbspSELECT ROW_NUMBER() OVER (PARTITION BY S.sessie_id ORDER BY S.created_date)...

1. Create a #temp table with an IDENTITY column

2. Insert your data into the #temp table

3. Join the #temp table to a derived table containing the MINIMUM(ID) for each tans_code...

In SQL2000 you will need to use a #temp table:

http://www.sqlservercentral.com/Forums/Topic397675-8-1.aspx

The UNIONS are test data! (Read the comments.)

Just use the query and replace the test tables with your tables.

-- *** Test Data ***

DECLARE @t1 TABLE

(

&nbsp&nbsp&nbsp&nbspInitials varchar(10) NOT NULL

&nbsp&nbsp&nbsp&nbsp,EffectiveDate datetime NOT NULL

&nbsp&nbsp&nbsp&nbsp,RatePerHour money NOT NULL

)

INSERT INTO @t1

SELECT 'aaaa', '20050101', 150 UNION ALL

SELECT 'aaaa', '20050705', 200 UNION ALL

SELECT 'aaaa', '20050901',...

Without the rest of your tables (P as in P.Tran_ID?) and the rest of the WHERE clause, your post does not make sense.

Try:

INSERT INTO table_geography

SELECT @geolevel

WHERE NOT EXISTS

(

&nbsp&nbsp&nbsp&nbspSELECT *

&nbsp&nbsp&nbsp&nbspFROM table_geography G WITH (UPDLOCK )

&nbsp&nbsp&nbsp&nbspWHERE G.geolevel = @geolevel

)

I have a note that the following should work in 2005. (I must have seen it on a forum somewhere.) I have never tried it as ADO/ADO.Net seems less hassle.

CREATE...

Gail is right to say that order is meaningless in a SQL table, however order does have meaning in your Excel worksheet. In order to retain this order in SQL...

JReed,

I find all the unneeded brackets in code makes it difficult to read. I have reformatted it as follows:

SELECT DISTINCT

&nbsp&nbsp&nbsp&nbspAccounts.UID

&nbsp&nbsp&nbsp&nbsp,Accounts.Fname + ' ' + Accounts.MI AS Fname

&nbsp&nbsp&nbsp&nbsp,Accounts.Lname...

Your queries are running correctly, NOT IN and NOT EXISTS are not the same when there are NULLs involved and ANSI_NULLs are on. (Your data must have NULLs in the...

Try casting to bigint and using the fnNumber2AnyBase function at the following link.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=87871