Use either Merge Join or Lookup transformation in the Data Flow.

😎

venkyzrocks (4/21/2014)

No master table exists. The temporary master table has been posted below. I'll probably create one. So stripping off the FY** values and create a master list and...

You should use a text editor rather...

Just remove the @ from the column aliases to get the result as a node.

As I said in the previous post, switching encoding is not supported so the output will...

Nats007 (4/22/2014)

Getting the following warning in SSIS - SQL 2012:

[SSIS.Pipeline] Warning: Could not open global shared memory to communicate with performance DLL; data flow performance counters are not...

According to the RFC4180, a double quote (text qualifier) must be escaped by a double quote, don't think this is the actual cause.

How does the 246th row compare to other...

Firstly, the character code for upper and lower cases are different, even on a case insensitive system:

;WITH NB(N) AS (SELECT N FROM (VALUES...

If you are going to switch the encoding from UTF-16 to Windows-1252, you will have to work with the final output as NVARCHAR(MAX) as it cannot be cast back to...

You are better off using the CHARINDEX function, and CHAR or NCHAR functions when dealing with special characters.

😎

DECLARE @TEST_STR NVARCHAR(128) = N'ASDFGHJ[QWER';

SELECT CHARINDEX(NCHAR(91),@TEST_STR) AS POS

Result

POS

----

8

First a question, is float the correct data type for the query, most certainly not if dealing with monetary values.

To print the number, you can use either the STR or...

Do a loop or a cursor, construct a SQL statement for each database, and execute separately.:cool:

If I understand the question correctly, you can use the UNICODE function to determine the case if the characters, even if the column/db is case insensitive.

😎

Quite some room for improvements, start by moving the parameters to the sp_executesql params and validating the inputs.

😎

You are almost there, look at this code, should get you over this hurdle

😎

SELECT

SDH.SalesOrderID AS '@SalesOrderID'

,(SELECT

...

Question: where...