Good one Eugene.

I was on the same logic after I saw the OP's second post where he altered the result set.

marclas (5/8/2012)

---

HI

how can i set a null value when declaring a parameter

example

CREATE PROCEDURE dbo.GestionStatutDossier

-- Add the parameters for the stored procedure here

@StaId int NULL,

@DosID uniqueidentifier,

@staDate datetime,

@staBL nvarchar (50),

@staCRprod nvarchar...

One way you can disable the trigger by using following sql script

ALTER TABLE Table_Name DISABLE TRIGGER Trigger_Name

Other way programaticlly handle it by checking a condition inside the...

Please post DDL of the tables and some sample data.

kirkm 55368 (5/7/2012)

---

Hi Vinu, I had a look but its a little too advanced for me.

Where has has, e.g.

Select *

From Table1 t1

LEFT OUTER JOIN Table2 t2

ON t1.Col1 = t2.Col2

What are...

Going by what you posted Anthony is absolutely right.

He told you what the Error means. We as real people can only tell you the meaning of the Error by looking...

This might work too:

;With CTE

As

(Select *, Row_Number() Over (Partition by a,b Order By a Desc) As rownum From

(SELECT 'W1' AS A, 'WWW' AS B, 'W2' AS C

UNION ALL

SELECT...

Yes you can do it as follows:

Select (Case When field1 IN (Select field1 From Tbl Where field2 = 'Ann') Then field2 Else '' End ) From Tbl

I hope by Dynamically...

Sony Francis (5/8/2012)

---

try this

select DISTINCT Field1,

STUFF

(

(

...

I don't really think I understand what your requirement is. But, I came up with something. Hope it helps you:

Select b.origin_code, b.Id, b.over_weight_qty, b.over_weight_um From

(Select Origin_Code, Id,

(Case When...

Lynn Pettis (5/8/2012)

---

We need the DDL (CREATE TABLE statement) for the tables involved in the query, including any indexes. Also the actual execution plan, saved and uploaded as a...

I haven't done this before. But you can use the REVOKE command inside your trigger to alter the privileges of a User.

But, I don't think you can do it for...

This is my shot at it:

DECLARE @temp1 VARCHAR(MAX);

DECLARE @temp2 VARCHAR(MAX);

DECLARE @temp3 VARCHAR(MAX);

SELECT @temp1 = COALESCE(@temp1,'') + ',' + CHAR(39) + field2 + CHAR(39) + ''

FROM tbl Where field1 = 1

SET...

You're Welcome:-)

It would be very nice of you and very helpful to everyone who might provide a solution to your requirement if you could have a look at the link mentioned...