Here is what i have tried so far.

CREATE TRIGGER [dbo].[TriggerTestforDelete]

ON [dbo].[TriggerTest]

FOR DELETE

AS

--DECLARE VARIABLES Having one to one Mapping...

You can get all the 4 deleted records. As said by Dave, query the "Deleted" table to get your deleted records..

Here is sample test code

IF OBJECT_ID('TEST') IS NOT NULL

DROP TABLE...

Will something like this help you?

UPDATE REQ

SET consumed = 1 , matched = 1

FROM REQUEST REQ

INNER JOIN

(

SELECT

ROW_NUMBER() OVER(PARTITION BY mobile_phone ORDER BY mobile_phone, parameters) ROW_NUM

,mobile_phone...

you can use something like

Exec Master.dbo.xp_fileexist YOUR_COLUMN_NAME

Go thro this article to know more about xp_FileExist

http://www.sqlservercentral.com/articles/Stored+Procedures/xpfileexist/183/

What and how will...

you have given how your desired result must be withour showing how your initial table looked like..please post some sample for the intial table and even clearer description of what...

Is the ID unique for each mobile_phone and parameter combined?

Here is one version of the code to delete duplicate values

-- Create the table

if object_id('Duplicates') is not null

drop table Duplicates

Create table Duplicates

(

c1 int

)

-- insert some sample records

declare @i int set...

I did not understand your requirement fully, so assuming this is what u are asking, i have made some sample data and query for your requirement.

Assumptions :

You need Employees that...

Mate, post your table structures (CREATE TABLE statements), Some sample data (INSERT INTO script), Indexes and Constraints if any and your expected result based on the sample data. THis will...

LOL 😀

Hi there, this is the working version of the code.. please ignore the code present in the post above

BUT BEFORE U MOVE ONTO THE CODE, I WOULD SUGGEST U READ...

Will this help you?

I am writing this code from my home where i have no access to SQL Server. once i reach office i will check the validity of that...

yes, as vyas pointed out, use BCP.. very fast utility to bulk insert millions of rows..

David, that was not my requirement, the OP has asked for it 🙂 i tried my level best to produce a result without case and dynamic sql 🙂