Nice one, Chris!

You can do it quite easily with SSIS.

Have you tried that?

Looks like a bug. Is your SSMS patched to the latest SP and/or CU?

You can convert the string to a date using the CONVERT function and providing an appropriate date style.

See here for more info: http://msdn.microsoft.com/en-us/library/ms187928.aspx?ppud=4

If you provide table scripts, sample data and desired output based on the sample data, I'm sure lots of people will jump in and solve your issue. Until you do...

Yes, but quite cheap. Give it a try.

It's the typical "Islands" problem.

Let's see hot to solve it with ranking windowed functions:

Setup: (fixed a couple of issues in your code and changed to a #temp table)

CREATE TABLE #MeterInterruptions(

[LiveId]...

I see. Here you will find an interesting (beta) project by Adam Machanic that I think will help you with your assignment: http://sqlblog.com/files/folders/beta/entry29021.aspx.

SQL_By_Chance (10/2/2011)

---

There is no requirement as such. I just wanted to know how can I execute the 2 queries together

( Insert into xyz values (1,2,3)

GO

Insert into uvw values (1,2,3)

GO

)

and...

waseem.shahzad 45937 (10/2/2011)

---

Hi Guys!

We are working in .Net and database in SQL Server. I want to...

Jack Corbett (10/1/2011)

---

Hey guys I got some really cool news today. I was awarded MVP status!

I just hope I can honor that award the way that all the MVP's...

Evil Kraig F (10/1/2011)

---

Lynn Pettis (9/30/2011)

---

Okay, for $250 - $750 USD I want the following:

Need Software with following modules and features...

... an entire software suite from the land of the...

Evil Kraig F (10/1/2011)

---

GilaMonster (10/1/2011)

---

Lowell (9/30/2011)

---

Kraig you are alluding to the possiblity of an INSTEAD OF trigger on the view, to handle the logic of insertin/updating tables that are...

You're welcome.

You will find lots of good articles here at SQL Server Central. When you want to know more on a particular subject, try searching the articles and I'm sure...

You're welcome.

Glad I could help.