Viewing 15 posts - 20,716 through 20,730 (of 26,490 total)
Larry Rebich (5/27/2009)
May 27, 2009 at 2:58 pm
RBarryYoung (5/27/2009)
Just one thing, next time, could your blow a whistle or something first? I almost didn't get out of...
May 27, 2009 at 2:46 pm
lmu92 (5/27/2009)
Lynn Pettis (5/27/2009)
select dateadd(wk, datediff(wk, 0, dateadd(dd, -1, @ThisDate)), 0);
Nice one...
As simple as efficient. 🙂
Thanxalot, Lynn.
Curious, where in Germany. My daughter is over there for a week. ...
May 27, 2009 at 2:43 pm
Larry Rebich (5/27/2009)
May 27, 2009 at 2:38 pm
RBarryYoung (5/27/2009)
Heh. My turn: http://www.sqlservercentral.com/Forums/Topic724398-22-1.aspx?Update=1grrrr... :angry:
Much there is in my Hogwarts Tent, there is. Welcome you are.
I left a "saintly" reply myself.
May 27, 2009 at 2:29 pm
Larry Rebich (5/27/2009)
Who knows how to use SMO/VB.Net to create an Instance of...
May 27, 2009 at 2:24 pm
RBarryYoung (5/27/2009)
GilaMonster (5/27/2009)
Lynn Pettis (5/27/2009)
Florian Reischl (5/27/2009)
@Lynn:Congratulation for 7k points! 🙂
Thanks! 😉
Yeah, congrats. Noticed that you were top of the 'most frequent posters' list yesterday.
Hey, congrats from me too, Lynn!...
May 27, 2009 at 2:07 pm
Imu92(5/27/2009)
your date routines are really helpful!
One question though:
When I try "set @ThisDate = '20090524'" I get "2009-05-25 00:00:00.000" as Beginning of this week (Monday) which is "strange" - at...
May 27, 2009 at 1:57 pm
Absolutely NO GUARANTEES on this code. I have nothing to test it against.
WITH UserGroups (
group_id
) AS (
select
group_id
from
f_get_groups_user(@user_id)
)
SELECT
...
May 27, 2009 at 1:44 pm
Nope. No sample data or expected results.
Please read the first article I have referenced below in my signature block.
May 27, 2009 at 1:33 pm
Where are we again? Oh yea,
44 bottles of beer on the wall, 44 bottles of beer! Take one down, pass it around, 43 bottles of beer on the...
May 27, 2009 at 1:31 pm
I think part of your problem is the mixing of join syntax. You are using both new and old style joins. First thing I'd do is rewrite the...
May 27, 2009 at 1:23 pm
Can't help fix something if we don't have the code, the DDL for the tables involved, sample data (in a readily consummable format), expected results based on the sample data.
Please...
May 27, 2009 at 12:24 pm
GSquared (5/27/2009)
Lynn Pettis (5/27/2009)
Roy Ernest (5/27/2009)
May 27, 2009 at 12:18 pm
Per Books Online (BOL), which should be your best friend next to SSC, synonyms can only be created for views, tables, functions (CLR and T-SQL), and stored procedures. Can't...
May 27, 2009 at 12:17 pm
Viewing 15 posts - 20,716 through 20,730 (of 26,490 total)