Start out by building a calendar table with all the dates you want to check, and which week each one is in. (I keep a 10-year calendar table handy...

WayneS (1/28/2011)

---

Tom.Thomson (1/28/2011)

---

edit: I missed a whole page of comments - must have skipped accidentally from page 1 direct to page 3 without passing page 2 and without collecting essential...

If you want the data in a particular order, use an Order By clause. Otherwise, SQL will give you whatever order it comes up with, which may or may...

I'm assuming "cast(column as XML)" has been tried and didn't work. If so, I'd assume that SQL Server won't do this for you, and the third-party tool will be...

What defines an "empty target"?

You're giving WAY too little data here to be able to help you on this.

Change the name of "@iNew", either in the dynamic SQL or in the calling procedure. You're using that one twice.

shankarntu (1/28/2011)

---

HI,

Thank you so much. i got the result.

And one more help.

i want to update the same table to Hour slot

For eg,

1/20/2011 12:00 and 1/20/2011 12:30 this need...

I guess I'm used to SSMS 2005. No "Properties" on the right-click menu in that, at least on my machine. I see one in SSMS 2008 now that...

The possibility of a missing end value is why I use an inline subquery instead of the CTE method.

amenjonathan (1/28/2011)

---

Just wanted to post back to this thread that I finished my blog post on handling hierarchies in slowly changing dimensions. If I've misquoted anyone (especially Gus) please let...

Welcome back.

I guess.

Do they all have the same schema and name? If so, you'll need to replicate them into three different databases (so far as I know). You can then...

I've always used replication for that. Easy enough to set up and manage, and it works well.

IsNull will return a secondary value if a value is null. No row = no column value = IsNull doesn't handle that.

Usually, handling of empty datasets is something that's...

I'm not sure I follow you on this.

Transactional Replication has one source and one target. It seems like you're talking about two sources.