Andy, how about you going through this following article and helping us help you?? 🙂

FORUM POSTING ETIQUETTES - JEFF MODEN

When u do so, i am sure a lot...

Yes and as Jeff pointed out, make sure your path is a shared drive with the account that is going to execute the query have ALL the necessary permissions to...

Hi there... Check if the following code works for you

IMPORTANT : Follow the comments in the code block and customize it with appropriate values for your needs...

--Performance improver.

SET NOCOUNT ON

--Local...

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

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