:w00t:

SQL Saturday Chicago, here I come! (I was wait listed when I originally signed up...)

WayneS (3/21/2011)

---

It looks like there's quite a few of us jumping into this twitter thing all at once....

You're welcome. Glad it helped!

Let me try to tackle this from another direction. Based on the information you provided, I set up this data set:

create table #AVGtest

(LOS int)

go

insert into #AVGtest (LOS) values (8)

go

insert into...

Can you post a sample table definition and sample data? I built a test bed for this and couldn't get avg(LOS) to return anything but an integer result on my...

hbanerje (3/18/2011)

---

Hi,

I am struggling to get two decimal places in an AVG number

so I wrote

select

cast(avg(LOS) as decimal (9,2))

from the table1

---it is giving me the result 9.00

LOS is an integer...

not...

Try running it. I thought it would fail, but I decided to test the code...

Grant Fritchey (3/17/2011)

---

Brandie Tarvin (3/17/2011)

---

Every so often, I stop and remember that I learn (or remember) things much better if I have to explain it or teach it to someone...

Steve Jones - SSC Editor (3/15/2011)

---

Points have been awarded back and the question corrected to ask which one should be used, and then to note the DMV is the correct...

CirquedeSQLeil (3/14/2011)

---

bitbucket-25253 (3/14/2011)

---

Here we go again -- the specified as correct answer is an item to be depreciated in a future release of SQL Server and one possible answer, and...

Jeff Moden (3/14/2011)

---

It'll be my pleasure to take a gander and maybe run some code, Craig. Lemme know. Actually, you could do the same for me soon and...

I found a few minutes I wasn't expecting to have and mocked up a sample for you:

create table auditData

(pk_id int

,fk_id int

,column1 varchar(15)

,column2 varchar(15)

,column3 varchar(15)

)

go

insert into auditData (pk_id, fk_id, column1, column2,...

Have you looked at UNPIVOT as an option?

That's certainly what...

GSquared (3/10/2011)

---

To truncate a table in Rhode Island, you first get a chainsaw, then you lock the chairs so no one new can sit down at the table, unless they...