Viewing 15 posts - 556 through 570 (of 2,452 total)
http://www.sqlservercentral.com/articles/Tally+Table/72993/
try the DelimittedSplit8K function (code is at end of article)
edit typo
July 3, 2016 at 6:22 am
The Dixie Flatline (7/1/2016)
That said. This was a fun...
July 2, 2016 at 12:27 pm
The Dixie Flatline (7/1/2016)
Hey JL: You have two groups of IDs. What result are you expecting?
I dont know <grin>...just posted some sample data based on OP...
July 1, 2016 at 3:03 pm
The Dixie Flatline (7/1/2016)
The logic is that 100 is subtracted from the first value, 50 is subtracted from the second value, and...
July 1, 2016 at 2:26 pm
greg.senne (7/1/2016)
If I have several records in a table such as this:100
50
50
20
And I want to subtract 175, I want a result like this:
0
0
25
20
How would I go about doing this?
Thanks
Greg
care to...
July 1, 2016 at 12:54 pm
can you ALWAYS guarantee the number will come immediately before either "admissions" or "discharges"
what happens if someone types this "Since reporting 22/04/2016, the admissions are 5 and the discharges are...
July 1, 2016 at 5:12 am
How can i always pull out the correct number for Admissions and the correct number for Discharges please?
can you please give example of how you want the end result to...
July 1, 2016 at 4:01 am
quentin.harris (7/1/2016)
I have a text string that appears in files as below:
'There were 6 discharges and 3 admission since reporting 21/04/2016'
However sometimes, admissions are swapped around with discharges in the...
July 1, 2016 at 2:34 am
As it happens I work on Salford Quays and it's frankly, shit. Although how much of that is down to our leaky draughty office I don't know.
Well I just I...
June 30, 2016 at 2:00 pm
if i know how to code it in while loop i can easily add extra business rules in it.
what business rules do you foresee that will necessitate a while...
June 30, 2016 at 9:23 am
The following image is the result page I need to produce.
https://This image host is not supported, please use another/image/k6idu0jwn/
sorry...cant see your expected results
June 30, 2016 at 9:18 am
abhas (6/30/2016)
Example, I am having column StarTime with datatype Datetime. For example below.
StartTime ...
June 30, 2016 at 7:23 am
Newbi (6/30/2016)
I am aware that I should be providing the data in correct way, if I want to be helped.
I am trying using the links inside the page....
June 30, 2016 at 7:18 am
Beatrix Kiddo (6/30/2016)
The UK government directs funding disproportionately to the south east, and the rest of the union can go hang as far as the bureaucrats in Whitehall are concerned.
The...
June 30, 2016 at 7:10 am
Viewing 15 posts - 556 through 570 (of 2,452 total)