I wouldn't actually use a join.

Instead just use a condition to get values after the last non zero value. In order to do that, you need to figure how...

I'm not sure what's the problem. SQL Server will handle unicode characters just fine.

--Do a direct select

SELECT N'????'

--Using a table

CREATE TABLE #HindiText( myString nvarchar(10));

--Insert into...Select

INSERT INTO #HindiText SELECT N'????';

SELECT *...

You're comparing the same value (Dyn_Assessments.field_name) twice and expecting it to have different values, which won't happen because it compares row by row.

I'm not sure about the rules to work...

It's popular when there's no DBA that can bring people to reason. Other than that, it's hard to see something so convoluted.

I remember a horror story about an implementation...

I'm not sure if I should have read all the replies before, but this seems like a good option. I started by using a CASE for each column, but this...

Can you post DDL and sample data that we can actually use? Your solutions use 3 columns and you only showed one.

Partitioning tables is a great tool to manage the archiving process for large tables. However, this is something that has to be well planned and consider all the needs and...

Home

It actually should work with previous versions as well. Documentation for SQL Server 2000 includes it, but I couldn't test on anything older than 2008R2.

https://technet.microsoft.com/en-us/library/aa258231(v=sql.80).aspx

It's weird that this is so...

You left my method out

I feel excluded.

You missed the relationship between the inner and the outer query.

select Item

,(Case

When Exists(SELECT t.Item

...

I believe that you need to give us more detail. Why is it being slow? Is it the query to generate the source data? Or just writing the table to...

I made the code work by adding 4 characters in different parts of the...

Of course you're getting yelled. Why would you want to turn off xp_cmdshell? 😀