eseosaoregie (12/3/2008)

---

I currently have a select where for one of the fields I need to change the output if it is null or contains the code 'v918899' For eveything else...

Hi Ishaan

Can you please provide some sample data, and an expected result set, as in the link below?

Cheers

ChrisM

Hi 4D

This should start you off.

[font="Courier New"]DROP TABLE #Data

CREATE TABLE #Data ([id] INT, cust_id INT, sales_id CHAR(3), start_date DATETIME, end_date DATETIME)

INSERT INTO #Data ([id], cust_id, sales_id, start_date, end_date)

SELECT 1, 1,...

Grant Fritchey (11/30/2008)

---

Well, it was a thrilling moment, I don't mind saying. I'll be picking up one of those integrated face sheild/helmet/ear protection things soon (read ASAP). First time in...

Corobori (12/1/2008)

---

I think that ROW_NUMBER is a SQL Server 2005 and in my case I am using a SQL Server 2000...

Thanks for the explanation, Gail.

I use 1 just to make it very clear to me and to anyone reading that there's no column access and the column (if any) mentioned...

Chris Morris (12/1/2008)

---

Only the third method would work - and it's exactly the same as the OP's...

A very similar question was asked and answered here...http://www.sqlservercentral.com/Forums/Topic610366-8-1.aspx#bm610396

Cheers

chrisM

Here's a long shot if you'd like to try it:

SUM(IIF(Fields!totalmoney.Value>105,Fields!totalmoney.Value-105,0))*0.128

Cheers

ChrisM

These functions all appear to restrict rows...

Hi KPR

Examining the function which returns a warehouse code, dbo.fn_ProfileWareHouse:

the WHERE clause reads AND B.WHCode = M.WHCode where M is the alias for the table returned by the function.

If @WHCode...

Hi Corobori

This will give you yoyur expected results without randomisation - but I think you should find that part relatively straightforward:

WITH MyCTE AS (SELECT ROW_NUMBER() OVER (PARTITION BY Pr_RealEstateAgent_Id ORDER...

Gail, did you notice in your testing if there was significant benefit in using

Where not exists (Select 1

instead of Where not exists (Select *

in Query 1? I'm...

Grant Fritchey (12/1/2008)

---

Yeah, that's basically it. In most of our instances, we're looking for the latest version of a record, so we're going for one value in each set, not...

Not sure if you can get all three updates into one statement, but you can certainly speed things up:

[font="Courier New"]UPDATE TABLE1

   SET    CHK_DATE = 1

   WHERE  TRXID IN (SELECT A.TRXID

                     FROM   TABLE1...