helloanam (8/7/2008)

---

I think first and last date of year will always be same irrespective of what year is it. 😉

first date: 01/01/ year

last date: 31/12/ year

therefore, no need to use...

Except for the occasional mispelling, that should do it...

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...

Tomm Carr (8/6/2008)

---

None of which are Money. All those rates will be...

Thank you for the feedback... glad you solved it. 🙂

Heh... reminds me of the ol' hand assembly days... "Shift Left, Load Zeros". 😀

john.arnott (8/6/2008)

---

I wasn't trying so much to improve on anyone's solution, but found that just trying to find an alternative approach helped me understand the concept of a tally table....

Heh... provided that an inter rate, tax rate, discount rate, or any other rate is never used.

drari (8/6/2008)

---

I just sent you a bigger file

I know that there are actually5 data rows + 1 header and 1 footer thus 7 rows

But what I say is that I'm...

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...

Heh... never mind... OP says the PK is actually 3 columns... really makes all of this a moot point. 😛

TheSQLGuru (8/6/2008)

---

Yep. And then we have this situation:

Clustered index: order_id (assume int - 4 bytes), order_date (assume datetime - 8 bytes),...

Idea for article on forum etiquette... ummm... wait a minute... 😉

toprprasad (8/6/2008)

---

Hi...

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...

No problem... PK can be nonclustered.