Eirikur Eiriksson (11/12/2014)

Koen Verbeeck (11/12/2014)

In that case...

The following query calculates the SD and MEAN by customer (it doesn't include order_date).

select PO.customer_id

,PO.order_date

,row_number() over(partition by order_date order by order_date desc) as DATE_LINE

...

Here is another alternative

Add a date column (REC_ADD_DATE) to the table, instead of ClientNum. Default the date column to current_date. This date will then be used to determine...

-- Here is SQL SELECT query to use when inserting a new row into the table.

-- But ClientNum will remain accurate as long as the rows are not deleted...

Here is another alternative..

select TheDate

,TheMonth

,WeekName

,ParcelCount2013

,case when TheDate is not null and TheDate > '2014-10-02' and TheDate < '2015-01-01' then ParcelCount2013 +...

I believe the CHARINDEX returns 0 if the delimiter is not found in the string. Tweaked the customer number formula a little bit to handle these scenarios

CASE WHEN coalesce(byte#_of_last_dash,...

Here is an alternate solution to your problem...

The following recursive query locates the last delimiter and parses the record into cust_name and cust_nbr.

In the recursive query, at every iteration...

Is it that you want the books that have the same price and sold by ALL the resellerIds you have in the table ? This is one way to accomplish...

The INNERJOIN subquery ensures that you have more than one reseller_ids for the book_code with the same price.

NO_OF_RESELLERS_SELLING_SAME_BOOK_FOR SAME_PRICE is how many resellers are selling the same...

That's true, I kind of overlooked the conditions in the where clause. Thanks for your comments

I am glad I could help

I am assuming the IntWOSO table joins both WorkOrders and ServiceOrders tables.

The MAX in the GROUP BY subquery ensures you have only one row per WorkOrder and HAVING clause eliminates...

I am new to this forum. I didn't know the post can be edited. thanks for the tip.

There was indentation in the query before I posted....

I had posted the incomplete query by mistake.

sorry for the confusion, here is the query that I wanted to post.

select A.*, B.Value

from #Records A

...

select *

from #Records A

left outer join

(select join_value, max(value)

from #Records M

left outer join #MoreRecords N on M.join_value = N.join_value

where M.date >= N.date

group by join_value

) R on A.join_value...