the queries took to long and were timing out the reports. the union or union all query returns to rows of data for one style

...

possibly thanks ill have to see

never mind ill figure it out.

this was just a quick query that i posted to see if someone had any suggestions on a creating a compare query. didnt need...

You have a GROUP BY clause but since you have no aggregate functions its only effect is to eliminate duplicate rows.

i am dividing in the case statement.

It would help...

lowells, but yours i nice as well. 🙂

thanks, love your profile picture!!!

Not sure if i understand 100% what you are asking but, i am grouping my query

First, get rid of the # in the data element names; it is HIGHLY proprietary and a little dangerous. Can you explain what a sku_nbr is and why it is...

Thanks

how do i convert it?

is there a way to make the datetime just a date???

thank you very much that worked great.

i used

dateadd(dd, ININVD - 1,

dateadd(mm, ININVM - 1,

dateadd(yy, ININVY + 100, cast('19000101' as datetime))))

the values are integers

i tried this

cast(( dbo.INVHDRPF.ININVY * 10000) + (dbo.INVHDRPF.ININVM* 100) + dbo.INVHDRPF.ININVY as datetime)

these were my results

YEAR MONTH DAY ...

i used this and it seems to work

INNER JOIN

dbo.OCUSMA ON CAST(dbo.OORDDETL.ORACTD As VARCHAR(12)) = dbo.OCUSMA.OKCUNO

thanks