The solution provided here is somewhat similar to what Sander has provided, and I am not sure on whether this is going to be faster, but may be you can...

Could you explain more about the requirement & the logic behind it? Also the script of the cursor you have tried so for. And also, the table creation...

I am not entirely sure what you wanted, but I think this one is closer to the requirement...

AND

(

(

@IsNotInTest2 = 1

AND Test1ID NOT IN( SELECT Test1ID FROM Test2 )

)

OR

(

@IsNotInTest2 =...

You have to create the table with a default value of NEWID(), i.e.

CREATE TABLE [dbo].[tblServiceCDR](

[id] [uniqueidentifier] NOT NULL DEFAULT NEWID(),

Have you mapped the local logins with that of remote logins?

If yes then are you executing the query under the context of the local login?

You can test the...

You can have a Conditional Split component that will check the for the values and re-direct the row to appropriate outputs...

How did you connect to the remote server?

What queries you are running on the server?

Have you enable remote connections on the remote server?

Does the firewall is blocking...

Try the following snippet....

SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel 12.0;Database=d:\dasdgigs.xls', 'SELECT * FROM [dasdgigs$]')

You can do this in many similar ways, here I am providing one of the ways

Variables:

@LastID (String): will contain the last unique integer id

Data Flow Task

>> Flat File Source

>> Derived...

Adi, you were right on how to filter the rows that contain newline or carriage return characters in a string. But the OP wanted to eliminate those characters from...

Hi Joseph,

I am providing you the simplified version of your requirement, which can be easily extended to all other tables as specified in your requirement.

-- Get all DDS into a...

Can you cross check the port on which the SQL Server is listening?

And also try connecting the server by both IP & Name.

See this article for your answer

http://wiki.sqlis.com/default.aspx/SQLISWiki/ExpressionDateFunctions.html

...You have added an additional comma in the first column selection, i.e.

WITH CTE AS (SELECT COALESCE (a.DDS + ' , ' + b.DDS + ' ,...

You just need to write the expression (like CONVERT( NVARCHAR(5), ROUND(RAND()*100000,0)) ) & not the entire statement. And also, this will only work if you are inserting one record at...