Viewing 15 posts - 2,116 through 2,130 (of 4,080 total)
Hey again Trudye,
We really need to get you out of this idea that dates have to be converted to strings. 😉 Try this:
SET @First_Day_Prev_Month =...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 25, 2009 at 3:10 pm
Hey Barry, I hope you are well along the road to recovery/rehab for your back now. Everything going okay there?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 24, 2009 at 9:09 pm
You could do it in dynamic SQL and probably get better performing results, but otherwise it is as simple as
WHERE @flag = 0 and filter = 2
...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 24, 2009 at 9:00 pm
Jack,
We're all really happy to hear your little girl is doing fine. 😀
Let's hope that's the last time you have to contend with a real injury. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 24, 2009 at 2:58 pm
Hang in there, Jack.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 23, 2009 at 9:18 pm
God bless you all, Jack. We'll say a prayer for her speedy recovery.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 23, 2009 at 6:20 pm
Absolutely not. I haven't worked with one in forever.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 23, 2009 at 4:56 pm
So true, Alvin. 🙂
By the way, thanks for everyone's insights. I always thought that relational was the db model of choice because of flexibility and because it...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 23, 2009 at 3:51 pm
After well nigh unto 9,000 posts, The Thread has taken many turns. The other forums do the same things. Don't sweat it, the pendulum will swing...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 23, 2009 at 3:43 pm
I'll second Jeff's request. Long involved verbal descriptions can't take the place of sample schema, a script to populate sample data, and a visual of what the expected...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 23, 2009 at 8:34 am
It's not simpler than
CREATE dbo.DoomsdayTable (data xml) 😎
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 23, 2009 at 6:29 am
First, there is a concept you need to understand:
Rows in SQL result sets have no "original" order, other than that which you impose on them with an...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 22, 2009 at 5:12 pm
Hi Mattie:
Next time, PLEASE cut and paste the statements you took a screen shot of. It's lovely, but it forces us to retype everything before we can play...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 22, 2009 at 4:47 pm
Could we see some code and sample data?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 22, 2009 at 10:44 am
Of course, if it is necessary to make the JOIN work correctly.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 22, 2009 at 9:07 am
Viewing 15 posts - 2,116 through 2,130 (of 4,080 total)