Viewing 15 posts - 48,871 through 48,885 (of 59,065 total)
helloanam (8/7/2008)
first date: 01/01/ year
last date: 31/12/ year
therefore, no need to use...
August 7, 2008 at 7:36 pm
Except for the occasional mispelling, that should do it...
August 7, 2008 at 6:49 pm
Good idea, but be careful... the Tally table is not a panacea. For example, there is code that will beat the pants off the Tally table for finding missing...
August 6, 2008 at 11:58 pm
Tomm Carr (8/6/2008)
Jeff Moden (8/6/2008)
Heh... provided that an inter rate, tax rate, discount rate, or any other rate is never used.
None of which are Money. All those rates will be...
August 6, 2008 at 11:55 pm
Thank you for the feedback... glad you solved it. 🙂
August 6, 2008 at 11:49 pm
Heh... reminds me of the ol' hand assembly days... "Shift Left, Load Zeros". 😀
August 6, 2008 at 7:12 pm
john.arnott (8/6/2008)
August 6, 2008 at 7:09 pm
Heh... provided that an inter rate, tax rate, discount rate, or any other rate is never used.
August 6, 2008 at 6:25 pm
drari (8/6/2008)
I know that there are actually5 data rows + 1 header and 1 footer thus 7 rows
But what I say is that I'm...
August 6, 2008 at 6:16 pm
Boy, isn't THAT the truth! That's why I always try to come up with test data and code... I figure if I can't prove it with code, I can't...
August 6, 2008 at 6:10 pm
Heh... never mind... OP says the PK is actually 3 columns... really makes all of this a moot point. 😛
August 6, 2008 at 6:02 pm
TheSQLGuru (8/6/2008)
Jeff Moden (8/6/2008)
No problem... PK can be nonclustered.
Yep. And then we have this situation:
Clustered index: order_id (assume int - 4 bytes), order_date (assume datetime - 8 bytes),...
August 6, 2008 at 5:59 pm
Idea for article on forum etiquette... ummm... wait a minute... 😉
August 6, 2008 at 8:38 am
toprprasad (8/6/2008)
I need a script which can generate insert statements for all the records in a table.
for eg: if a table abc has 2 records, then on executing this...
August 6, 2008 at 8:34 am
Viewing 15 posts - 48,871 through 48,885 (of 59,065 total)