try pinging the Server IP Address from command prompt to learn if the server is responding or not.

Test your linked server connectivity from SSMS, if unsuccessful then check the SQL Logs.

There exists standard SSIS Package upgrade wizard.

Please refer to https://msdn.microsoft.com/en-us/library/cc280547(v=sql.120).aspx.

additional information:

SQL Server 2016 offers new feature, STRING_SPLIT() which returns delimited strings as records.

e.g.

SELECT STRING_SPLIT('A,B,C',',')

Output:

A

B

C

first thing, you need not define another transaction inside the stored proc.

Except that it seems your code is perfect.

Hi,

I guess you need to create another index explicitly.

I guess using data conversion data transformation would help you.

I got this information online which might help you.

There is this KB article, which lists the required updates you need to install https://support.microsoft.com/en-us/kb/3135244 , which also lists which updates are...

Can you post the structure of the tables used in query along with some sample data to help you better?

What's the problem you are facing here?

Thanks, I agree its always a good practice to define primary key on the standard logic tally table.

You need to define a tally table

create dbo.numbers(n int);

Load the numbers table using standard logic available.

Now to load the data into #insert table,

INSERT INTO #INSERT(txt)

SELECT txt

FROM #TEMP t

CROSS JOIN dbo.numbers...

I think using the T-SQL LIKE clause would help in this scenario.

e.g. in WHERE clause of stored proc use ,

WHERE Address = @inputaddress or Address LIKE LEFT(@inputaddress,1)+'%'

Either Gail or Jeff's solution should work.

And in Gail's solution it just refers to the matching rows and the beauty with EXISTS clause is that it just need one matching...

Hello,

No where in your tables design there is scope for accommodating the string data 'bio', 'eng.1' etc.

Can you eloborate the problem with data in tables.