Viewing 8 posts - 1 through 8 (of 8 total)
Hi Steve,
I would rather not do that but this is the final stage of a busier query. Initially, I am doing a running total against on hand inventory and creating...
October 27, 2021 at 3:06 pm
That is so great, thank you! It works perfectly. I am going to study it to wrap my head around what is happening here.
I am assuming that I can change...
July 29, 2019 at 11:32 pm
That looks like it is working, Jeff. There was only an extra parenthesis on the second line change.
Again, I really appreciate your help and have a better idea...
May 11, 2018 at 8:26 am
Okay, thanks. That sets me in the in a direction.
I am getting an error 'Incorrect syntax near '.' on this but will work with it to see if...
May 11, 2018 at 8:02 am
Hi Jeff,
I ran in to a little wrinkle in this line:
hPath = CONVERT(VARBINARY(4000),CONVERT(BINARY(4),CONVERT(INT,ISNULL(SupplyJob,'9999999'))))
My Supply Job Number is often a string and it gives...
May 11, 2018 at 7:03 am
Wow, Jeff. That is awesome and I so appreciate it! It works perfectly and I learned something new.
Thank you!
Ross
May 2, 2018 at 9:17 pm
--===== If the test table already exists, drop it
IF OBJECT_ID('TempDB..#mytable','U') IS NOT NULL
...
May 2, 2018 at 6:22 pm
Viewing 8 posts - 1 through 8 (of 8 total)