Eric M Russell (2/23/2011)

---

TravisDBA (2/23/2011)

---

The mindset of most managers will never support this at most companies. Most managers I know need to know you are on site to verify you...

UMG Developer (2/18/2011)

---

lnoland (2/18/2011)

---

UMG Developer (2/18/2011)

---

Really? I've been doing correlated subqueries that way for quite awhile and never had any problems. I would have thought that if the...

UMG Developer (2/18/2011)

---

Les,

I see you basically came up with the same solution as mine, but you didn't alias the tblCaseLog table in your NOT EXISTS query, so it is ambiguous...

tacy.highland (2/18/2011)

---

That doesn't quite work either. I tried that in the earlier post (the "variation"). I've found other Cases which should be included in my resultset but aren't....

ron.richardson (2/1/2011)

---

I have updated the statistics, but I don't know if I did FULL SCAN or not. Most likely I have not.

Query:

SELECT DISTINCT TOP 10

s.sale_key,

fc.freight_carrier_name,

isnull(os.freight_charges,0),

isnull(os.weight,0)...

ntran777 (1/26/2011)

---

I'm creating a table for reporting that has too many columns in it to return as one. The rows go over SQL's 8060b limit. To solve this, I'm gathering...

dlam 18073 (1/24/2011)

---

The thing I didnt do at the beginning, was test the query in a very large database, was large enough I thought, then the process timeout in the...

dlam 18073 (1/23/2011)

---

I understand your query now, I know its abit late to say that.

Related question about the code below

select *

from tblCallLog r

Where DateCall =

(

...

dlam 18073 (1/20/2011)

---

DateCall >=@callFrom and DateCall < @callTo <<< does this part of code already set the range of dateCall

without

not exists

(

select 1

FROM tblCallLog

WHERE phNu=r1.phNu

AND DateCall > @callTo

)

also it select all...

dlam 18073 (1/20/2011)

---

yes, ur right i only want the phone number within the rang,

so DateCall >=@callFrom and DateCall < @callTo

is alreadly set the rang,

one thing here iam not understand, do...

dlam 18073 (1/19/2011)

---

below is the table and some data

tblCallLog

id (int, not null)PK

DateCall(datetime, null)

logStatus(nchar(10), null)

phNu(int, not null)

pplName(nchar(100), null)

id, DataCall, logStatus, phNu, pplName

400123, 2011-01-10 15:15:00.000, n, 31695555, b johnson

400124, 2011-01-10 15:16:00.000, b,...

I thought, perhaps, that was...

zlthomps (10/21/2010)

---

Would this even remotely be close?

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

CREATE TRIGGER [EquityLeadDeDup]

ON [dbo].[WebLead]

INSTEAD OF INSERT

AS

BEGIN

SET NOCOUNT ON;

DECLARE @EQ_CID INT,

@EQ_MsgDate SMALLDATETIME,

@EQ_ToAddress VARCHAR(64),

@EQ_LeadType INT

IF EXISTS(

SELECT

...

Jeff Moden (10/24/2010)

---

I'm not sure why everyone thinks this stuff has to be done in a single query. And, it probably should NOT be done in a single query....

GSquared (3/31/2010)

---

Gift Peddie (3/30/2010)

---

This is one of the things which so bothers me about software patents on generic techniques. If, as is often the case, it is something which is...