Viewing 15 posts - 57,526 through 57,540 (of 59,049 total)
Serqiy, cool function... especially great for bi-monthly paydays on the 1st & 15th, etc.
Bellefso... this returns the first date of the current month... was in both Serqiy's and my examples...
SELECT
September 26, 2006 at 9:41 pm
In a function, instead of (over simplified example)...
..etc..
I use,
September 26, 2006 at 9:12 pm
September 26, 2006 at 9:00 pm
I'm still looking for the function that will split a 2gb string on a delimiter, Serqiy... any chance of you posting it or the URL you got it from? Thank...
September 26, 2006 at 8:41 pm
I wondered when you were going to show up on this one ![]()
September 26, 2006 at 1:26 am
I agree about the BEGIN/END where no transaction is defined... however, if you check out Books Online, you'll find that BEGIN/END is required syntax in UDF's
September 26, 2006 at 1:24 am
Sorry... didn't see Remi's solution, which is obviously spot on! ![]()
September 26, 2006 at 12:14 am
If this in in a complex GROUP BY, forget COUNT... you have a condition and COUNT isn't going to do it for you... SUM(CASE will....
September 26, 2006 at 12:13 am
Not sure how you're using it, but "IF" smacks of Cursors, While Loops, and other forms of "RBAR"... if you really want you code to fly, write it set-based with...
September 26, 2006 at 12:08 am
I know it's just an experiment but, ugh... if you end up counting transactions in your code, ya just might have a bigger problem with your application...
September 25, 2006 at 11:43 pm
First, not sure how you'd do a like with the values "mashed" together even if you were looking at a single column. I can tell you that anytime you can...
September 25, 2006 at 11:38 pm
Ok.... thought you'd gone nuts on me for a minute
Short naps get me through the day
September 25, 2006 at 11:28 pm
Be patient with me, Serqiy... I'm confused
... I thought you were saying before that you didn't need SQL, just the file system...
September 25, 2006 at 9:16 pm
p.s. Just to save face... if this is NOT a simple denormalized reporting table, you need to change my statement from...
"and everyone who has code that adds columns uses the...
September 25, 2006 at 9:05 pm
Both methods are good... so long as you are in the correct data base and the table actually exists in that data base...
if it doesn't, the code will not...
September 25, 2006 at 9:01 pm
Viewing 15 posts - 57,526 through 57,540 (of 59,049 total)