Heh right...

IgorMi (9/14/2012)

---

SQL Kiwi (9/14/2012)

---

ChrisM@Work (9/14/2012)

---

[font="Courier New"]

Table Ind_level External Fragm(%) Avg Frag Size Page_count Internal Fragm(%) Ind_size (KB)

identity ...

Andy Hyslop (9/14/2012)

---

ChrisM@Work (9/14/2012)

---

Andy Hyslop (9/14/2012)

---

ChrisM@Work (9/14/2012)

---

SELECT i.*

FROM tbItems i

CROSS APPLY (

SELECT [active inventory] = CASE

WHEN Solddate >= CONVERT(DATETIME,'01/11/2011',103)

AND Solddate < CONVERT(DATETIME,'01/12/2011',103) THEN 1

WHEN Purchasedate >= CONVERT(DATETIME,'01/11/2011',103)

AND...

Andy Hyslop (9/14/2012)

---

ChrisM@Work (9/14/2012)

---

SELECT i.*

FROM tbItems i

CROSS APPLY (

SELECT [active inventory] = CASE

WHEN Solddate >= CONVERT(DATETIME,'01/11/2011',103)

AND Solddate < CONVERT(DATETIME,'01/12/2011',103) THEN 1

WHEN Purchasedate >= CONVERT(DATETIME,'01/11/2011',103)

AND Purchasedate < CONVERT(DATETIME,'01/12/2011',103)...

SELECT i.*

FROM tbItems i

CROSS APPLY (

SELECT [active inventory] = CASE

WHEN Solddate >= CONVERT(DATETIME,'01/11/2011',103)

AND Solddate < CONVERT(DATETIME,'01/12/2011',103) THEN 1

WHEN Purchasedate >= CONVERT(DATETIME,'01/11/2011',103)

AND Purchasedate < CONVERT(DATETIME,'01/12/2011',103)

AND Solddate IS...

denis.gendera (8/31/2012)

---

I've got following query

select machine_id, MONTHS =

CASE

WHEN DATEDIFF("m", firstseen, getdate()) = 0 then 'AUG'

...

"Internal fragmentation" = "average page density", although the latter seems more sensible to me.

SQL Kiwi (9/14/2012)

---

IgorMi (9/13/2012)

---

The above from BOL has proved true in a test i did some weeks ago. I wanted to see the fragmentation, page counts, index sizes for int,...

Two stored procedures are run at the same time by agent jobs.

SystemCheck2.dbo.sp_IMPORT_UTILITY_RUN_PROCESS_tb_Import_Data

- UPDATE [dbo].[tb_Import_Data]

SystemCheck2.dbo.sp_IMPORT_CLEAN_tb_Import_Data

- Copy rows FROM tb_Import_Data i to [dbo].[tb_ARCHIVE_Import_Data]

They should be run serially with the...

aaron.reese (9/13/2012)

---

fine, but if you are...

For us humans, and you too Eugene, it is - even for so-called "identical twins".

Eugene Elutin (9/12/2012)

---

...(that is why forensic DNA-result doesn't...

Here's a useful script which Lynn Pettis prepared earlier: http://www.sqlservercentral.com/Forums/FindPost1357526.aspx

You have 4...

raghuldrag (9/13/2012)

---

Hai friends ,

i ve one doubt in subqueries in oracle

select col1,col2 from @tab1 where(col2,col3) in(select col2,min(col3) from @tab1 group by col2)

while i am executing these...

Luhar (9/13/2012)

---

I am not running it in transaction.

No one will access the DB when this procedure runs as it runs nightly.

I just want to modify the procedure so as...

oscarooko (9/13/2012)

---

...

Folks, thanks for the help. i have solved the issue, and more importantly, I learned a few new tricks from you. Mine was mostly a case of poor design....