Viewing 15 posts - 811 through 825 (of 851 total)
Jeff Moden (2/2/2009)
Jeff Moden (2/2/2009)
noeld (2/2/2009)
Bruce W Cassidy (2/2/2009)
OMG, did I really just say that? And I was just reading an article by Joe Celko too!...
February 2, 2009 at 5:52 pm
noeld (2/2/2009)
O M G !
[font="Verdana"]Snap![/font]
February 2, 2009 at 5:43 pm
[font="Verdana"]Is the MyDateColumn unique? Because if it's not, the second form could return more than one row.
Ooops, really should read all of the replies before posting. Someone already...
February 2, 2009 at 5:35 pm
Jeff Moden (2/2/2009)
Heh... on that note, I'm glad I do all this stuff in T-SQL. 😛
[font="Verdana"]Me too! My personal rule is to use stored procedures to do all of...
February 2, 2009 at 5:33 pm
Sergiy (2/2/2009)
Bruce W Cassidy (2/2/2009)
[font="Verdana"]But if you keep it around as a permanent table within your database, you will find it useful. [/font]
I'd suggest ot have it in a...
February 2, 2009 at 5:24 pm
[font="Verdana"]I'd be interested in learning what sort of scenario you use that for.[/font]
February 2, 2009 at 5:02 pm
[font="Verdana"]I'm still holding out the frying pan, waiting for the pork chops to land.[/font]
February 2, 2009 at 3:38 pm
Jeff Moden (2/1/2009)
I'd suggest the creation of a Calendar table. It has many uses including this one.
[font="Verdana"]Wot 'e said.
My Calendar table is called (surprisingly) Calendar. It includes Year,...
February 2, 2009 at 3:37 pm
[font="Verdana"]To add to the discussion (and to reiterate what was mentioned earlier), I've found the best answer is to keep around a table of dates (I call mine "Calendar", although...
February 2, 2009 at 3:30 pm
[font="Verdana"]Relational Integrity is over-rated.
OMG, did I really just say that? And I was just reading an article by Joe Celko too! Aaaargh! 😛
[/font]
February 2, 2009 at 2:55 pm
[font="Verdana"]I don't have enough points (yet) to risk it...[/font]
February 2, 2009 at 2:54 pm
[font="Verdana"]I was going to suggest you check the version of the database on which you are trying to create the function. I'm glad someone beat me to it. ...
February 1, 2009 at 1:58 pm
[font="Verdana"]If you post the code you have in the stored procedure, and some details on what the indexing on the tables are, we can look at ideas for optimisation.[/font]
February 1, 2009 at 1:55 pm
[font="Verdana"]Embarcadero's ERStudio was a favourite of mine in the past.
I never really liked ERWin (even before CA bought it, and it's only gotten worse since then.) But some people...
February 1, 2009 at 1:50 pm
GSquared (1/30/2009)
February 1, 2009 at 1:33 pm
Viewing 15 posts - 811 through 825 (of 851 total)