Please have a look at the link in my signature and post sample data as shown in it. People will find it a lot easier to work on your requirement...

shubhamagrawal.107 (5/23/2012)

---

actually, i created a table before some time and now i want to see what query i used to create that table.

now tell me can i see the...

Depends on the Stored Procedure that you are talking about. But, generally there are a few things you need to...

I could have been more precise if you had given me some sample data to work with.

Anyways, you can accomplish what you are trying to do by using UNPIVOT. Here...

You're welcome!! 🙂

You're Welcome. 🙂

I'm glad, I could help.

Look at the very data you've presented. Where is 6:07 and has more than 10 minutes gone by since 6:00 with the levels indicated? I think not. The final answer...

Doesn't it still work Mr. Jeff Moden??....The CTE give the following result set:

InterfaceName TheDateTime ...

I couldn't think of it the way you thought.....its a good trick and...

I think you can get it by Count() Over Partition as follows:

--Creating Table

Create table StoreGroup (

StoreGroup int,

Store int

)

--Inserting Sample Data

insert into StoreGroup values

(1,1),

(1,2),

(1,3),

(2,4),

(2,5),

(2,6),

(3,7),

(3,2),

(3,8),

(4,1)

--Query For Your Requirement

Select StoreGroup, Store From

(Select *,...

dwain.c (5/21/2012)

---

I'm not sure exactly if this fits the definition of islands and gaps because you seem to have complete data for each minute of time interval.

This approach should work...

This link on...

sivag (5/21/2012)

---

hi

Gullimeel

our query was working fine but if want to

get the out put like this mean what...

Yes, I agree with Steve....you need to use Dynamic SQL for this as follows:

Declare @name1 varchar(max) = 'abhi.Test.dbo', @name2 varchar(50) =

...

David Webb-200187 (5/21/2012)

---

If it's happening every minute, I'd be willing to bet someone has a SQL Agent job set up to check something on a dev server every minute and...