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
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 3, 2016 at 6:22 am
The Dixie Flatline (7/1/2016)
That said. This was a fun...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 30, 2016 at 2:00 pm
oops...wrong post !
apologies
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 30, 2016 at 9:56 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 30, 2016 at 9:18 am
abhas (6/30/2016)
Example, I am having column StarTime with datatype Datetime. For example below.
StartTime ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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....
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 30, 2016 at 7:10 am
Viewing 15 posts - 556 through 570 (of 2,452 total)