Dear all,

thank you so much for the explaining and the syntax.
Now i have  options to choose..

Dear all, 

I made the Stored procedure to search Years, Months, days by looping
@EXP_DATE --> Expired_Date

SELECT @@DIFF = DATEDIFF(DAY, GETDATE(),@EXP_DATE)
SELECT @@DIFF1 = DATEDIFF(DAY,@EXP_DATE,GETDATE())

thank you Jhon and Kingston for the link

whenriksen (11/30/2016)

---

On an unrelated note, you've created these objects in the master database. That is a very bad idea. If at all possible, you should move those to...

azdeji (11/28/2016)

---

Hi

I’m attempting use the output statement to populate the audit table for scd1 columns that are overwritten from a merge into a secondary history table –

That shows the...

hii,,

Try using dtexec Utility (SSIS Tool)

WhiteLotus (11/23/2016)

---

Hi all ,

I have to compare all tables in 2 databases . these 2 databases have the same table structure but different content

If the content in table A...

DesNorton (11/18/2016)

---

The MERGE statement will take all of the data that you provide...

DesNorton (11/18/2016)

---

OK. So it seems that your TEMP_SUPPLIER has duplicate values for SUPPLIER_CODE.

To prove this, let's create a simple data set that will cause the PK error

CREATE TABLE #M_SUPPLIER...

--M_SUPPLIER

Column_nameTypeComputedLengthPrecScaleNullableTrimTrailingBlanksFixedLenNullInSourceCollation

SUPPLIER_CODE(PK) varcharno6 ...

DesNorton (11/17/2016)

---

MERGE M_SUPPLIER A --- TARGET

USING TEMP_SUPPLIER B --- SOURCE DUMMY

ON A.SUPPLIER_CODE = B.SUPPLIER_CODE

-- You are matching on A.SUPPLIER_CODE = B.SUPPLIER_CODE

-- Then you say WHEN A.SUPPLIER_CODE <> B.SUPPLIER_CODE

WHEN MATCHED --AND...

John Mitchell-245523 (11/17/2016)

---

Not if there's no row to update, no. But say, for example, you were testing for rows that have a match on m_id but have different values...

John Mitchell-245523 (11/17/2016)

---

But if the data doesn't exist at the destination server, there's nothing to update. You need to do an INSERT instead. In the absence of the...

John Mitchell-245523 (11/17/2016)

---

You are using SQL Server, aren't you? What version?

Your update statement doesn't make sense, either. You're updating to set m_id in the outer table to be...