benjamin.reyes (4/6/2012)

---

That's not a very good way to handle you tempdb files, but in this example sql server will still run, as long as there's someplace to expand the tempdb.

Where...

jerry209 (4/6/2012)

---

Thanks Chuck Hottle and ColdCoffee for your quick response

I am debugging a Stored Procedure and came across this SQL Statement.

The actual sql statement is some what like:

DECLARE @itemId INT

SET...

with out ddl and sample data for all the tables i cant be sure.

the first thing i would do is add a where clause to the query creating the CTE...

xenophilia (4/6/2012)

---

Look here's what I've tried. I have been reading about CTE and I must be fried but it is not going anywhere for me. spinning my wheels horrifically.

Please...

NM was a response to drew misreading the sql

you need to add a where clause to your query. see this link to read up on them

http://msdn.microsoft.com/en-us/library/ms188047.aspx

njdevils39 (4/6/2012)

---

LutzM (4/6/2012)

---

Are you looking for something like this?

WITH cteRates AS

(

SELECT

o.EMP_ID,

(ROW_NUMBER() over(partition by o.EMP_ID order by x.r.value('@date_changed','DATETIME') desc)) as RowNum,

convert(VARCHAR(10), x.r.value('@date_changed','DATETIME'), 101) AS DATE_CHANGED,

...

jewel.sacred (4/6/2012)

---

capn.hector (4/6/2012)

---

jewel.sacred (4/6/2012)

---

capn.hector (4/6/2012)

---

to lynn's point. if 6 months after you start using this you have to change the pieces per pack you have to make sure to...

sharky (4/6/2012)

---

Hi Jeff,

Thanks for the UPPER fix.

I have created the table using a clustered index with 50 rows

--

SELECT TOP 50 IDENTITY(INT,1,1) AS N

INTO dbo.Tally

FROM Master.dbo.SysColumns

ALTER TABLE dbo.Tally ...

jewel.sacred (4/6/2012)

---

capn.hector (4/6/2012)

---

to lynn's point. if 6 months after you start using this you have to change the pieces per pack you have to make sure to update every...

i would see...

Lynn Pettis (4/6/2012)

---

jewel.sacred (4/6/2012)

---

capn.hector (4/6/2012)

---

ok first thing is i would move your conversion factor to your unit table, makes for easier changes with out haveing to make sure you update...

ok first thing is i would move your conversion factor to your unit table, makes for easier changes with out haveing to make sure you update every conversion factor in...

to limit the patients returned you can put your conditions in a where clause in the query (the self join giving your results) or if its a large table your...

with cte as (select row_number() over (Partition by PATIENT_NUM order by REGISTER_DTIME asc) AS Row, * FROM #Tbl_PATIENT_ADM)

select a.PATIENT_NUM, a.ADT_SOURCE, a.PATIENT_NURSESTATION, a.REGISTER_DTIME, b.REGISTER_DTIME, DATEDIFF(Day,a.REGISTER_DTIME,b.REGISTER_DTIME)

from cte a

LEFT...