You need to get rid of the pivot and make it into a crosstab. Have a look at the crosstabs post in my footer. Jeff Moden describes in the linked...

Your requirements are indeed not clear on the topic of the 5 days period. I was little afraid of that already (and that's why I asked you to post your...

Can you post your end result so others may learn from it too and (as a plus for yourself) have your solution reviewed for any errors / options for improvements.

Please post some ddl (table definitions) plus some example data. From just your query it is not clear from which tables columns like 'Period' and 'YEAR' are taken. Knowing this...

Chris, I still don't understand your functional requirements. But I've found that creating an instead-of-trigger on a view can be a handy way of hiding from the caller the actual...

And if you create a view over the both tables and create an instead-of-trigger on that view. This trigger excutes code alike that was presented. This way you can do...

Then the example is wrong: In your example A00000 is missing in between 999999 and A000001 and this pattern seems to be repeated in ...

Does the sequence not have any zero's in the rightmost position? for example, is 000010 in your sequence or is that skipped, like A00000?

Thanks for the explanation, Paul.

This is not my day :doze:. You can forget about my improvement: Paul excellently implemented that already too...

I'm not sure though whether the lock hint on the select in...

elogen (9/7/2011)

---

Also R.P.Rozema, when you say by using DYNAMIC cursor, the 'state' of the table is re-read on each fetch, by 'state' do you mean whether the table is locked?

Having...

paul_ramster (9/7/2011)

---

If converting to XML works for you, then fine, but the very simple solution to your problem as just to add an IsNull() within the SQL that you're executing:

declare...

First of all you can have a look at your cursor type. FAST_FORWARD means your cursor will fetch all rows in one go, then to feed them one row at...

ghanshyam.kundu (9/7/2011)

---

thanks all,

as per sean, i am thinking to come up with a solution that at the time of saving the datetime i have to save the offset of it...

Replace '&' by '& amp ;' (without the spaces in between) in the source string. Same thing applies for any '<' & '>'s in your texts, these need to be...