Viewing 15 posts - 1 through 15 (of 694 total)
Thank You Sir,You are correct, this is very close. I was trying to take it one small step at a time. I think by doing that, it bit me....
March 27, 2019 at 12:58 pm
Lynn,Then how about the number of products sold per hour. I have listed everything that I can figure in the body of the post.
September 18, 2018 at 9:33 am
Have you performed a count and that same WHERE clause in a query?
That will tell you exactly how many rows have that ID. Or is there a unique...
September 18, 2018 at 8:54 am
Thank You both for the very fast response and the examples.
I greatly appreciate it.
August 23, 2016 at 10:30 am
That is perfect.
Thank You so very much for your help with this. I was not thinking or trying anything that simple. Greatly appreciate it.
November 7, 2014 at 8:43 am
Thank You Very much.
That is exactly what I needed. I was not even close in my code.
September 3, 2014 at 10:44 am
Thank You to you both. That code worked very nicely. I had to change it just slightly, but you got me going down the correct path
Thank you again
July 15, 2014 at 6:54 am
Seems that is exactly what has happened. Someone changed the underlying table(s) that makes the View. I forgot about sp_refeshview.
Thanks again, and happy friday
June 20, 2014 at 5:59 am
What about inserting all the rows into the ETL table that I have already verified, and then delete the rows from the ETL table that are already in the Destination...
May 30, 2014 at 12:50 pm
Thank You to each and every one of you guys for your suggestions. Sorry I was not able to give more details and some examples. I know that is tough...
May 30, 2014 at 12:46 pm
Thank you Everyone
I was actually trying to do this the long roud about hard way. I did not think about using Char() number, I was trying to actually use the...
May 19, 2014 at 9:55 am
I knew there had to be a way. I should have checked sp_Configure before asking. Time for more coffee 🙂
May 8, 2014 at 7:24 am
Thank You John
That is what I tried using a CTE, but I am not getting something correct. I am having trouble with select the correct row to delete.
Would you offer...
May 1, 2014 at 10:53 am
Greatly appreciate all the great code samples, and suggestions
I did not any luck with the ISNUMERIC, I tried that first.
April 17, 2014 at 4:24 pm
I have already tried that.
April 17, 2014 at 1:02 pm