anudata (8/31/2010)

---

Thanks for your post. i am facing a similar issue. i have a table which is having the following fields and samle data

empid Transacttiondate ...

niyinks (8/23/2010)

---

The ACTUAL PROBLEM IS GETTING A TABLE TO DISPLAY A 28 DAY READMISSION RATE, THE PARTITION DOES HELP IN SORTING THE DATES BUT HERE LIES THE PROBLEM WHEN YOU...

niyinks (8/20/2010)

---

The code only takes into account one coulmn for dates, while I have two columns for date the first being an entry date the other being an exit date,...

niyinks (8/20/2010)

---

Hi

while the forum does try to aid things, some of us (me) are quite new to this, and would appreciate help. I have tried to tweak the code from...

CTE's cannot be replaced by mere views, see below why:

1. If you need to query specific operations, that do not make any sense when viewed separately from the main query,...

I agree on all aspects for the full 100%, even while I do not blog myself. I say this on two basis:

* Responding to blogs myself, poking holes or getting...

I very much like SQL even while over the time I encounter or read about quite a few quirks. The problem I have with the case I brought forward is...

Mike C,

I understand you point, I hope you can see mine too. In fact I never used the querky update anywhere as I never needed it. But more demanding cases...

Jeff Moden (7/22/2010)

---

Peter,

I've not tried this particular example but I'm pretty sure that you don't actually need the index hint when you use an ORDER BY to get the correct...

Mike C (7/21/2010)

---

Jeff Moden (7/21/2010)

---

Gosh, Mike, I'm...

In my oppinion ANSI padding (for storage) should always be on and I cannot see any justification for it not to be.

If my program stores the varchar 'A' plus a...

james.burnell (6/22/2010)

---

We don't actually do this yet, but I'm trying to convince our group to do it:

Our project is subordinate to another SOA project that conglomerates data from multiple sources...

A schema can best be seen as a namespace, separating one functional group of entities from another. This allows modular design and reuse of these functional modules without naming collisions....

I have to say I exclusivly work with the simple recovery model myself. Over time I learned that for those, it is best to have a fixed size, but **...

The CRUD concept itself is very old (I know of implementations from over 20 years back). It is also kind of crude/limiting in that operations apply per record (from what...