kgillispie (8/13/2012)

---

I've read some suggestions on this forum, but none were able to help.. so am posting a new question.

I am running the below query but I end up with...

Possibly, depends on how much.

It will be very interesting to see how this approach compares with the more conventional one,...

Eugene Elutin (8/13/2012)

---

Actually, you wouldn't even need a lot of experience to choose surrogate PK over natural key. Use common sense or apply...

sradez_DBA (8/13/2012)

---

Hey Phil,

Thanks for the reply.

Our project involves storing the every detail of a product(example).When the users search for the product from the UI, they get this file which has...

carl6885 (8/12/2012)

---

Thanks for the help! Got it working with:

SELECT tblErrors_ER.ErrorID, CASE WHEN Count(tblPolicyNumbers_ER.PolicyNumber) = 1 THEN MIN(tblPolicyNumbers_ER.PolicyNumber) ELSE 'Multiple' END

FROM tblErrors_ER

INNER JOIN tblPolicyNumbers_ER ON

tblErrors_ER.ErrorID = tblPolicyNumbers_ER.ErrorID

GROUP BY...

Lynn Pettis (8/10/2012)

---

...

I like the idea of having a sid (a surrogate id) on my tables, even if I do have a natural key that can serve as a primary...

Jeff Moden (8/10/2012)

---

...My favorite question is becoming "Discuss the differences between a Clustered and Non-Clustered Index". 95% of the time I'm told "The Clustered index is always the PK...

Meths

SELECT *

FROM #Temp t

CROSS APPLY (

SELECT AVGfield3 = AVG(field3*1.00) FROM #Temp s

WHERE s.field2 = t.field2

AND s.field1 IN ( t.field1, DATEADD(YY, -1, t.field1), DATEADD(YY, -2, t.field1) )

) x

Here's another way:

declare @cattyp varchar(3) = 'cri'

SELECT a.alid,

a.cattyp,

a.altitle,

...

Lowell (8/7/2012)

---

I had a similar interview like laurie had years ago; they were interested in whether I knew vb6, ADO and whether i knew javascript; the questions had a couple...

Cadavre (8/3/2012)

---

Is this an intellectual challenge? Because otherwise, use reverse().

I guess you could do something like...

Why don't you want to use reverse() ?

No functions...

-- sample data

declare @test1 table(

id int,

telephone varchar(4000)

)

insert into @test1

select 1,'004-26487,004-84576,9845678682' union all

select 2,'99942078682,002-2687,002-84576,99945678682' UNION ALL

SELECT 3,'002-2687' UNION ALL

SELECT 4,'' UNION ALL

SELECT 5, NULL

-- solution

SELECT

id,

NumberList =...