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...

Tracing scalar UDFs adds enormous time to its execution. That is, just trying to compute the time vastly increases the time. Thus, scalar UDFs generally are performing much...

This is an easy one:

ALWAYS use sys.; NEVER use INFORMATION_SCHEMA.

Not only might I_S be inaccurate, I've found it's also much slower and much more prone to locking/deadlocking. The I_S...

MickyD (8/19/2014)

---

Scott

Thanks for this . Could you confirm if I need to add the select statement part ?

Ideal situation would be to read this from a table that exists in...

Something like this should get you going pretty quickly. You can add the "documentation" part by adding a SELECT and/or PRINT to output a message about what is about...