Viewing 15 posts - 1 through 15 (of 38 total)
January 5, 2019 at 3:48 pm
January 4, 2019 at 8:05 am
February 16, 2018 at 5:09 am
February 16, 2018 at 3:16 am
Luis Cazares - Thursday, February 15, 2018 1:52 PMWhy is this different from your previous post?
https://www.sqlservercentral.com/Forums/1922239/Increament-id-if-running-total-for-group-exceeds-value
Similar but I need the...
February 15, 2018 at 2:00 pm
February 6, 2018 at 12:08 pm
February 6, 2018 at 12:05 pm
that works very well. Thought it would be a more complicated code!
and correct on the new column, i needed that too!
Expanding the code, looking at the new column [OrdersInGroup], a...
February 4, 2018 at 4:51 pm
to be honest, it could be a numberCode rather than letterCode, i just need a way to group the Points together.
February 4, 2018 at 12:15 pm
it would for sure stay under 26 letters, i think the max ive counting is around 15 letters.
business reason: my university assignment and i want to group these orders...
February 4, 2018 at 11:55 am
not quite.
what the above code does is links the point ON the id in alphabet table.
Point can be any number ie see below.
February 4, 2018 at 11:12 am
Really appreciated.
Last week I imported 30 files one by one, and each of those had a few tabs. Very time consuming and risky if I miss a tab or...
November 7, 2017 at 8:34 am
currently i import within SQL server management studio.
right click the database name > task > Import
this is done on an individual file basis.
November 7, 2017 at 2:53 am
no correlation between filename and sheet name.
is there a way to do it without SSIS method?
October 18, 2017 at 2:55 pm
This works very well!
i was able to test it on a large dataset, works blindingly fast!
really appreciate this
September 13, 2017 at 2:32 am
Viewing 15 posts - 1 through 15 (of 38 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy