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)