The monthly data would be limited to the first six months of sales based on the date they joined the program. After six months, I no longer need to report...

Simple enough. It just takes the field name and divides by 1, removes any whole number, and returns the balance. In this case, decimals. Thank you.

Thanks Phil. This looks like the results I expected. Now to incorporate it into my main query. I appreciate the guidance on char vs varchar. I did not know, but...

I need to add a little twist to the data. When the item is considered stockable at loc9999, I need it to have it's own usage. When it's not stockable...

• This reply was modified 4 years, 5 months ago by  jcobb 20350.

Thanks guys. Looks like I've got to do some searching and brush up on CROSS APPLY. I'll test these out.

Thank you both. I will dig deeper and see if I can narrow the issue by looking at the execution.

I have the table already and the "emailed" column is NULL. I want to create a SQL job that looks at that table and emails any rows where the email...

I think I can take it from here. All of these are very helpful, now just to move them into a CTE so I can expand the report. Thank you...

All of these are close, but maybe I didn't explain it correctly. I have a main item and it's substitute. The sub can also be  a main item with a sub...

Luis, This is perfect, I was trying to alias the SELECT * FROM S pivot (...    and couldn't get it. Now that I see it in type, it makes sense.

Thank you. I will work on this.

Thank you for double checking my work. I was focused on the date and forgot to partition by supplier. Now it looks right.

Figured it out. Added a row to the subquery to number the dates that were the same date.
,