Michael Valentine Jones (9/24/2009)

---

Ankur Bajaj (9/24/2009)

...

If having the facility to install Oracle server on windows OS does not limit its utility or performance then what is the reason Microsoft does...

I am...

You're asking about the numerical value being stored in binary form in something that is 1-bit wide. Bit columns...

niall.baird (9/23/2009)

---

Matt - thanks for that. -1 is still more than a bit field, as it takes 8 bits (I think) to store it, whereas 0 & 1...

dubem1-878067 (9/23/2009)

---

Thanks lowell

I don't think I would have imagine a solution like yours, it's brilliant

But I would like to have your opinion on this query assuming I know the ID_COMMUNITY...

Your syntax error is cause by trying to alias part of a calculation.

select

Dispatch_Hour_Sortable

,Dispatch_Month_Sortable

,Dispatch_Month

,Datediff(DD,(dispatch_time-day(dispatch_time)+1),DATEADD(MM,1,(dispatch_time-day(dispatch_time)+1)))as 'days in month'

,Count(v_incident_times.Incident_pk)AS COLUMN_COUNT

,Count(v_incident_times.Incident_pk) / /*'days' = --This is causing the error*/

CASE

WHEN Dispatch_Month_Sortable IN...

Whether it's worth it is up to you. It looks like you need to use it something like that in several places, so I'd think it might be.

Given what...

Also - be sure to set the IsDeterministic and IsPrecise attributes. They can have a big impact on how often your function is evaluated.

Assuming dispatch_month is an actual datetime you're grouping on, you can use something like

datediff(day,dispatch_month,dateadd(month,1,dispatch_month))

to get the days in a given month.

kramaswamy (9/22/2009)

---

Matt Miller (#4) (9/22/2009)

This is bound to go *boom* if ANYONE is doing inserts on the table while you're running this loop.

What is the inner stored procedure doing? ...

Fausto Echevarria (9/22/2009)

---

This is bound to go *boom* if ANYONE is doing inserts on the table while you're running this loop.

What is the inner stored procedure doing? This approach tends...

Fausto Echevarria (9/22/2009)

---

i would do something like this

DECLARE @MAX_ID int, @CONS int, @CURRID int

SELECT @MAX_ID=0, @CONS=1

SELECT @MAX_ID=COUNT(*)

FROM YOUR_TABLE

WHILE @CONS<=@MAX_ID

BEGIN

SELECT @CURRID=ID

from (

select ROW_NUMBER() OVER (order by ID desc) ROWNUMBER,*

from YOUR_TABLE

) a

where...

Per BOL -

If the table contains an identity column, the counter for that column is reset to the seed value defined for the column. If no seed was defined,...

The bigger question is - what do you plan on doing with the results? If you plan on, say, storing the interest earned in a day, and then...

raym85 (9/20/2009)

---

Would putting the queries in a Sproc be faster? I thought both functions and sprocs parsed and pre-compiled the data. Meaning that performance would be better? Well maybe not...