First let me thank everyone for the help in that past I may not post many questions but I learned SQL by reading tek-tips for direction and the looking up the details in BOL. Without the hints I would have been lost.
I have a problem that I have been trying to work through for a while. I want...
I am attempting to assign a batch and line number for a set of transactions. The batch number is unique for each batch code date combination and the line number is unique for each for each batch code.
The interesting thing is that if I run the query with a “top 1” everything works fine, any...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.