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

MickyD (8/19/2014)

---

ScottPletcher (8/19/2014)

---

You should be able to get the spreadsheet into a table by right-clicking on the database to load it into, selecting "Tasks", then "Import Data...", and go thru...

You should be able to get the spreadsheet into a table by right-clicking on the database to load it into, selecting "Tasks", then "Import Data...", and go thru the wizard...

My preference would be this (the "extra" parentheses are important to properly match the requirements):

SELECT *

FROM YourTable

WHERE (SnapshotDate > @from AND SnapshotDate < @to)

OR (SnapshotDate = @from...

How many rows will be added / changed between uploads / syncs?

I suggest considering Change Tracking or some other automated method of determining changes rather than trying to do it...