here is the problem simplified:

i have a table, with 2 cols in it

invoiceID , invoiceNumber

invoiceID is unique. there are duplicate invoiceNumbers. how do i delete the duplicates

( note the table...

SELECT

 InvoiceGuid

 ,CreditNoteID

 ,InvoiceHeaderID

 ,InvoiceBatchID

 ,BillToAccountName

 ,BilltoAccountCountry

 ,BillToAccountCountryCode

 ,BillToContactName

FROM

 mcsInvoice

WHERE

 InvoiceBatchID IN (

      SELECT

       InvoiceBatchID

      FROM

       mcsInvoice

      GROUP BY

       InvoiceBatchID

      HAVING

       Count(1) > 1)

i have tried this and it returns everything in my table. there are over 3000 rows in the table. i am pretty sure there are about...

here is the actual query i am running to get the data i require ( sorry its a bit long but it might demonstraight exactly what im looking to get:

i want to return all the data from all the rows rows where col1 is not distinct. col1 isnt a primary key, but its still supposed to be distinct.

so i...

the problem with that is it will select all rows in the table that are distinct, which is most rows. i only wnt the ones that are duplicates

i have read the post which you provided a link to, but im still a bit hazy.

heres my exact problem. i some rows in my table( not very many)...

got it sorted. just blind looking at code. was easy. sorry to bother you all

its a design kind of question.

eg. in the flat file i each row must contain customer info, program info, goal Info. thats no prob as they all lead on...

that pretty much explains my question. thanks dude

solved. had to go to workflow properties for each object and set to execute on main thread. works fine now. thanks all

the thing is though, i never created an odc connection. the report just worked on my pc, i thought id have to create the connection myself. can excel carry a...

the inner sproc takes the @customerId,@programId, @period, , calls another sproc and returns all "goals"  and goal related info  for that particular customer in relation to that program. here is...

i have done this, and although it adds the tables to the diagram, i dont get any relationships showing up. i have looked around but can find no setting to...

thank you. that worked a treat. i would have searched, but i didnt know what to search for.

i did i did!! i am getting a result back for @numRows, but thats in the context of the dynamic sql, and i cant reference that outside of the...