Viewing 15 posts - 16 through 30 (of 67 total)
Scott, My bad .....
I just didn't see that particular one....That's exactly what I needed. many thanks !
March 12, 2021 at 4:32 pm
Good Point Sergiy.
Public holidays are also excluded. , but right now Id just like to solve the weekends and then see if there is a solution for hoildays as well.
thanks
March 12, 2021 at 3:00 pm
Thank you for your guidance and reformatting this...it is helpful.
However the main calculation that I'm looking for is to figure out how to add the days and exclude the weekend...
March 12, 2021 at 2:49 pm
Thanks for the input. after your comments , I went and looked at the query executions' plan and based on that added an uncluttered index and Boom. that worked great.
Thanks...
March 11, 2021 at 2:07 pm
Hi ,
I initially thought the "where not exist" was working but it is not....
I have only one new customer this year , and the below query is returning many records....
February 4, 2021 at 4:59 pm
Thank you.. I was only able to get to this today.
I ran this and its seems to be what I needed.
January 21, 2021 at 10:09 pm
Unreal !!
I wont tell you how much time I spent on this.....double checked everything, but didn't see that - Couldn't see the wood for the trees.
Thank you so much.
January 19, 2021 at 9:02 pm
Steve, I miss spoke - you nailed it on the inventory. calc as well. - Wow a big - thank you !!
I was way out of my depth here, thanks...
December 11, 2020 at 7:14 pm
yeeha. - Ok, I corrected the where, I'm getting dry feed. - thanks !
So now that the pivot is working. The tricky calculation is to get the previous days total...
December 11, 2020 at 7:01 pm
Totally understand , it been a busy week. but thank you for taking the time to help me on this. - much appreciated !
So , the pivot on the DW...
December 11, 2020 at 3:51 pm
Steve,
Yes the CTE works. The only thing is its not picking up the dry feed. only wet was returned.
Here is the where clause that filters out the correct...
December 10, 2020 at 4:45 pm
Help from anyone Please !
December 10, 2020 at 1:50 pm
I tried my best to explain with screenshots - sorry.
Below you see the result I'm getting , identify my meshtype, but i need to add additional calculated columns to this.
December 9, 2020 at 11:33 pm
Jeff/Steve a big thank you.
I certainly appreciate all you guys knowledge, its a treat reading the back and forth and learning from the best.
I love the crosstab option, 1st time...
April 11, 2020 at 10:52 pm
Will do... looks like space got in ther somehow -thank you !
April 10, 2020 at 4:26 pm
Viewing 15 posts - 16 through 30 (of 67 total)