please, edit the question

maybe "you must open UDP port 1434"

EXEC master..xp_fixeddrives

louislsh

use union

select [Sales Date], Store, Product, Sold, cast(Null as Int) As SOH From TableA

union all

select Null As [Sales Date], Store, Product, Null As Sold, SOH From TableB

MVDBA (Mike Vessey) gave a good idea

I meant something like this

CREATE TABLE #Catalog_Data(

[Product_Catalog_ID] [int] IDENTITY(1,1) NOT NULL,

[Main_Product] [varchar](50) NULL,

[Product_Colour] [varchar](50) NULL,

[Product_Size] [varchar](50) NULL,

[Tax_Class_ID] [varchar](10) NULL,

[Outer_Print_Name] [varchar](100) NULL

)

Insert into #Catalog_Data

select '245862118101DRK_SGE',...

type sample data

binary_checksum() ?

type your query please

• This reply was modified 6 years, 2 months ago by handkot.

Because @@FETCH_STATUS is global to all cursors on a connection, use it carefully. After a FETCH statement executes, the test for @@FETCH_STATUS must occur before any other FETCH statement executes against another cursor. @@FETCH_STATUS is undefined before...

Some brilliant idea that I can't think of?

maybe use "database snapshot"?

Devil's in the details. 🙂

What about https://www.sqlservercentral.com/questions/running-a-docker-container

yes.

int columnCount = table.Columns.Count;

char[] charsToTrim = {','};

foreach (DataRow row in table.Rows)

{

string columnvalues = "";

for (int i = 0; i < columnCount; i++)

{

string value = row.ToString().Replace("'", "''");

columnvalues +=...

• This reply was modified 7 years, 2 months ago by handkot.

string value = table.Rows[index].ItemArray

columnvalues += “‘” +  value.replace("'", "''")+ “‘,”;

https://www.mssqltips.com/sqlservertip/3575/continue-a-foreach-loop-after-an-error-in-a-sql-server-integration-services-package/

• This reply was modified 7 years, 2 months ago by handkot.