Thank you I change it a little but get the same results

SELECT

(DATEDIFF(dd,DATEADD(mm, DATEDIFF(mm, 0, GETDATE()), 0), getdate()) + 1)

-(DATEDIFF(wk, DATEADD(mm, DATEDIFF(mm, 0, GETDATE()), 0), getdate())...

That is what I am looking for I need to be able to get what workday number the current day is saturday and sunday would be 0

That worked I was able to add my where clause to it and get what I need thanks

select * from

(

select uompScheduleNumber, case

when redtagcode ='' then 'NON' else redtagcode...

I could offer this

order,item,serial,status

'1234','s1','112341','6'

'1234','s2','1512431','6'

'1234','s3','1512331,'6'

'1234','s3','1512371','6'

'1234','s4','1612331','6'

'1234','s4','1622331','6'

'1234','s5','1612631','6'

'1234','s6','1612334','6'

'1234','s7','1512131','6'

'1234','s8','1511331','6'

'1234','s9','1512441','6'

'1278','s1','112342','4'

'1278','s2','1512531','4'

'1278','s2','1512931','4'

'1278','s3','1592331','2'

'1278','s3','1518331','2'

'1278','s5','1517331','4'

'1297','s7','1511631','3'

'1297','s1','112442','3'

'1297','s2','1512111','3'

I am sorry I left out the item

Select 0rder_number,item_number, serial_number, status

from orders

where order_closed !=-1 and ?????????

order by Order_number

everything is in the same table

Yes lastupdate is date time. Wow thanks for all the comments I used * in the select here because I did not want to copy and past the 28 columns...

what I get with the original query is a total box count for the UOMPSCHEDULENUMBER for 072115-01 I would get 812 for every line but with these I get...

this statement would work but I was hoping to use a table so I don't have to hardcode this in the software.

replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(m1_dc.dbo.SalesOrderLines.omlPartLongDescriptionText,'Brighton','Belleair'),'Colony','Colonial'),'Cottage','Colonial II'),'Homestead','Shaker'),'Homestead II','Shaker II'),'Harmony','Hawthorne'),'Savannah','Springfield'),'Briarwood','Bronson'),'Jamestown','Jupiter'),'Shelby','Sanford'),'Lawrence','Longwood'),'Yorktown','Youngstown') ...

Works Great Thanks

One more question I need to add the last order date to this and then add the AVg_days_between_orders to it so that I get Last_order_Date + Avg_days_between_orders

WITH orders

AS -- add...

the results should be on a per customer id bases not between customers so each customer id will have its own average.

thanks I will use the reverse and see how that works. Thanks again

When I do I get nothing.

Right(jmaPartShortDescription,CHARINDEX('x', jmaPartShortDescription)-1) AS length1

I have another question on this subject. I need to get everything from the right of the little x and I get that for the most part with this statement...

Thank you very much

This worked great

LEFT(SUBSTRING(jmaPartShortDescription, CHARINDEX('-', jmaPartShortDescription) + 1, LEN(jmaPartShortDescription)), charindex('x', SUBSTRING(jmaPartShortDescription, CHARINDEX('-', jmaPartShortDescription) + 1, LEN(jmaPartShortDescription))) - 1)