Same here. I PM'd but should have replied publicly. Yes the results of this script are amazing and I just could not get my head around it either.

Performance is...

Thank you, I was just preparing to post the create statements and a text file of some data.

I will take a look at your code. With regards to all rows...

Thank you sir.. I shall give it a try.. I was always very strong with complex T-SQL in 2000... Been out of the game for a little while and have...

LOL Yeah I guess I did hijack

I figured while I had your ear I would avoid a whole new thread. Then again someone else may find the information useful...

🙂

Hey one more question for you if you don't mind.

I am writing an automated route that I do not want to run (will be scheduled as a job) unless the...

STUPID mistake! 🙂 Thank you.

Actually I did not need to cast, all of the variables ARE varchar. I thought that ModuleID was a int however it is a...

Just my two cents.

If you are establishing a cursor to work with data that can not be a set based query / update / ect. And the data set...

Sounds like you work in the telecom space, as do I.

Feel free to contact me directly if you like. I would like to know a little more about the application...

Good evening.

Someone correct me if I am wrong.

You can not Embed an Order By in a view.

A view is handled by SQL as a logical table. You can create a...

Jeff,

Thank you for your input. In this case I am not looking for the end time or making any sort of rating determination based upon the end time or...

Thank you as well, Looking over everything now.

To explain the intent here. I only care about when a call starts. Think of this as a cell phone and...

I will take a look at your example. Just commenting on your first line.

As far as the assumption; I only care about when the call started not the duration or...

I will try this, thank you.

I have a datetime field as well for this that I was playing with.  The problem here is that the DATE portion is not used...

Mark,

I hate tables such as this however here it goes.

You can build a table that would contain (and I NEVER call things JUST   [ID]) the following example fields:

ContentID  (AutoNumber /...

You don't really want to do this. It provides for more overhead for one thing. Secondly when multiple SP's are in question often times it is a case of say...