u need to utilize the case statement in ur query.

it just seems to be redundant because everything is related to the first param. so if i have all sorts of replaces in the first param then i have to...

also it is bad proctice to default ur input params to null. If its a varchar it's not so bad however dates. Not so good.

if ur able to pull out the actual function from excel then i'm sure someone can duplicater it in tsql.

--Why not update the count in a pre-allocated table with (start_time, end_time) ranges already filled in?

Not sure what u mean. You saying adjust the process to insert a row...

anyone interested in the solution here it is. The solution was by good ol Itzik Ben-Gan. It's called Islands and Gaps. And it deals specifically w/ this solution to this...

--you could count all of the records that were during consecutive minutes, but what if it ran twice over 2 minutes?

Maybe but what if a few times it didnt span...

Sorry guys. i need the offerid, the hour, and number of runtimes. Also it will never run twice for a given offer in separate consecutive minutes

/* should return. The offerid,...

also if u think about it most of the code is already there in your app. just delivered in a different way.

good point. Hadnt thought of that. I need to dabble w/ .net when i have time and build this over time. I'll be honest though i could see this as...

wow thats pretty cool. Not sure if it satisfies my needs however. I'm looking for an executable that takes in some params such as the delimiter, export location, includeHeaders. Stuff...

sorry. the executable doesnt have to send the file. just build it and save it locally.

exporting. I'm fed up w bcp. I cant get the column headers to appear w/o a workaround that in my opinion should be built in. Staying away from ssis for...

noted

Funny. i remember those days. Not sure whats worst. Not encripting credit card numbers or posting that fact accross the world. you would be very wise not to give your...