It would be FAR better to remove the cursor from both of your procs. 😀

Count is one...

anthony.green (2/8/2013)

---

You cant use a * in an aggregate query unless you group...

dwain.c (2/7/2013)

---

How about something like this to avoid the self-join? Uses Sean's setup data.

SELECT Div_time, Unit_id

,TimeDifferenceMin=DATEDIFF(minute, MIN(Filled_Time), MAX(Filled_Time))

FROM #Something

GROUP BY Unit_id, Div_time

HAVING MAX(Filled_Time) <> MIN(Filled_Time)

Edit:...

Great question. I don't do much with full text indexing but that is going to change for a project in the very near future so the timeliness was good for...

I am willing to help you but you have to put in the effort to provide tables and data to...

You haven't received much response because your question is so vague. I think this may be what you are looking for.

Notice how I provided a table and sample data. This...

asco5 (2/7/2013)

---

hi i would like to understand how to count in sql with different parameters?

for example i have

Date, ...

OK last try. You think you need a loop but you don't. A loop is not the answer here. Sadly I can't help you with the answer because I still...

justsidu (2/7/2013)

---

So here's what I need help with.

I want to automate the @asofdate so that I can increment @createdate by 1 day to get the historical data from that day...

justsidu (2/7/2013)

---

Apologies everybody, here is my refined version of my post.

I am new here and I will make sure I will abide by the etiquette from now. could do...

akberali67 (2/7/2013)

---

The code ran for about a day on my 3 TB partition and I got an error. My dataset is really small but the combinations increase the size. This...

I took the liberty of attempting to format your script but it has a number of syntax errors, variables missing etc...

DECLARE @startDate AS DATETIME

,@endDate AS DATETIME

,@lastRunDate AS DATETIME

SELECT @lastRunDate =...

Please take a few minutes to read the first link in my signature. There is nowhere near enough information here to even begin thinking about an answer. You have an...

akberali67 (2/7/2013)

---

Ok.

What I am trying to do is to filter a dataset on all possible combinations.

My code does create combinations in a separate dataset but I am unable to completely...