Eirikur Eiriksson (8/29/2014)

---

Thank you Scott, Tom and Lynn, this was the discussion I wanted to get going in this context. The subject is far to dependent on the environment and...

Lynn Pettis (8/29/2014)

---

ScottPletcher (8/29/2014)

---

The page split / fragmentation concern is often overblown. Remember, one INSERT, but you may read the row 1000, 10K, 100K+(?) or more times. Particularly...

The page split / fragmentation concern is often overblown. Remember, one INSERT, but you may read the row 1000, 10K, 100K+(?) or more times. Particularly given the availability...

Eirikur Eiriksson (8/29/2014)

---

ScottPletcher (8/29/2014)

---

patrickmcginnis59 10839 (8/29/2014)

---

CELKO (8/22/2014)

---

I use the encoding that is being used. The IDENTITY property (not a column!)...

patrickmcginnis59 10839 (8/29/2014)

---

CELKO (8/22/2014)

---

I use the encoding that is being used. The IDENTITY property (not a column!) is the count...

amns (8/29/2014)

Instead of a datetime, if I cast a string with format 'yyyy-MM-dd',

will this cast always result in the correct date regardless the collation or other server parameters? (considering this...

j_depp_99 (8/29/2014)

---

thanks much for your response. Testing it now but not sure about the variable. What does this represent? ?

Msg 207, Level 16, State 1, Line 8

Invalid column name...

Something like below. I don't have test data, so haven't tested it yet.

Edit: The WHERE conditions on your original query caused the LEFT JOIN to become a de factor...

Sorry, I have no idea; that's not my area of expertise.

I'm guessing what is happening is that Latin1 has only ascii 0 to 255, not extended characters. So, the double-bytes are being interpreted as single bytes, one of which...

I use "__Archive" (double underscore) for those tables.

I also maintain its structure to match the original table. That is, if the main table changes, I make the same changes...

I guess "UnitNumber" is the "Patient".

SELECT UnitNumber,

MAX(CASE WHEN DiagnosisSeqID = 1 THEN Diagnosis ELSE '' END) AS Primary_Diagnosis,

'427.31' AS Seconday_Diagnosis_Match

FROM test t

GROUP...

Not sure if you want to get the exact proc name being executed or see it and its parameters. Something like this should help you get started, although it...

er.mayankshukla (8/26/2014)

---

er.mayankshukla (8/26/2014)Hello Experts,

I have defined a Nvarchar column of 30 bytes

Lets say

create table demo (name nvarchar(30))

But when I see the length of this column by selecting table and pressing...

See if it's possible to summarize data and get rid of some of the details. Yes, they always say then need "everything", but then frequently they roll things up...