If learning CLR is the objective, take a look at this article. http://www.sqlservercentral.com/articles/SQL+Server+2008/87743/%5B/url%5D

Make sure you read the discussion too. The article is a good example of how to use CLR...

yes

I would certainly never suggest that somebody use a loop or a cursor in the context of what you explained. However I would ask why do you need CLR for...

Yes explaining it make me shudder. It sounds like there is a table for each row in some other table? Sounds pretty scary.

Drop table is "minimally logged". That means it...

The trigger is a delete trigger? And it deletes the table? Not really understanding what you are trying to do here.

If you want to drop 55,000 tables, and some of...

2000+ points and you still post questions that vague? Give us something to work with here. Of course you can save the stuff from excel. The question is what are...

So you want to insert all values between first_in and last_in? You absolutely do not need a loop for this. You need what is called a numbers, or tally, table....

Basic cursor structure.

fetch_next

while fetch_status

begin

--do some stuff here

fetch_next

end

sabercats (4/18/2012)

---

Then i can get something like this

Location Starttime ...

Look closely at where you put your fetch next. It is inside an else block.

Or are you saying you want to get two rows when there are different starttimes??

select Location, Starttime, MAX(Endtime)

from #Testing

group by Location, starttime

Well which San Jose row would you want in that case?

You are going to have to do a better job explaining what you want here.

What are the numbers in the first row??

We are not familiar with your business or your...

Why not just set it up as a sql job and schedule it?

polkadot (4/18/2012)

---

If I could create a query that provided the intended results, I wouldn't be posting the question. I certainly am not able to create a visual using T-SQL without...