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 4 years, 8 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 5 years, 7 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 5 years, 7 months ago by  handkot.

my solution.
it's not good, but it can help you

;
With h As (
 Select
  o.Hierarchy
  , o.ItemID
  , StartDate = IsNull(t.StartDate, '19000101')
  , EndDate = IsNull(t.EndDate, '30000101')
  , o.ID
  , o.OccupantTypeID
--  , ot.Name
 From
  #Occupant o
 Left Join #Term...

maybe this will help

declare @xml as xml = '
<Data>
 <Interventions_x0020_Provided>
  <Interventions_x0020_Provided_x0020_SubTable>
   <Intervention>On-site (Observations, Consultation)</Intervention>
   <Provided>true</Provided>
   <Minutes>35</Minutes>
   <Describe>Completed observation. Discussed with Janet (teacher) how Aisling''s behavior has...