And Mr.adarsh.u.tholar.b , never put your new request in form of reply to an ongoing thread, open a new thread and place forth your new request. There by many...

adarsh.u.tholar.b (4/8/2010)

---

Hii

In converting a Single Row to a columns:

In my case the row is consisting of gmail id's separated by commas ie aa@gmail.com,bb@gmail.com,cc@gmail.com

I wanted the SQL Query where the colums...

adrian.sudirgo (4/8/2010)

---

Hmm.. not really. Actually I'm looking for the capability so that when 2 or more results came in simultaneously, they will not be matched to a single request (with...

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...