I'd also suggest that you have a carefull look in books online at the reference material for

set concat_null_yields_null on

set concat_null_yields_null off

these change the default behaviour of string concatenation involving...

SELECT l.Id

, MAX(CRM.dbo.fn_ConvertSFDateTime(e.CreatedDate)) AS lastevaluationdate__c

, e.ProductId__c AS lastevaluationproduct__c

FROM Customers.dbo.Evaluation__c AS e

INNER JOIN Customers.dbo.Lead AS l...

so the format of your query is

select x,y,max(z)

from mytable

where x<5

GROUP BY x,y

you must include all columns (except those you are aggregating) into the group by clause

oh - also if you have the budget for in house training then you might want to talk to a company based in Nottingham called "Quantix"

http://www.quantix-uk.com/

I worked for them for...

if you're planning to learn then aim for the OCP qualification, you'll pick up a lot more if you aim at passing the exam

https://blogs.oracle.com/certification/entry/0118

littlelisa1111 (5/4/2012)

---

SELECT l.Id, CRM.dbo.fn_ConvertSFDateTime(e.CreatedDate) AS lastevaluationdate__c, e.ProductId__c AS lastevaluationproduct__c

FROM Customers.dbo.Evaluation__c AS e INNER JOIN

...

capn.hector (5/4/2012)

---

Eugene Elutin (5/4/2012)

---

Jeff Moden (5/3/2012)

---

BWAAAA-HAAAA!!!!! Ask that question on the receiving end of an interview...

Steve Thompson-454462 (5/3/2012)

---

I think thats fine if you are only storing the role and thats as far as you go with it, so I'm ok with this. If you are...

rabisco (5/3/2012)

---

From the following string.....

<p style="text-align: justify;">Embedded link <a class="productLink href=";" macro="productLink" code1="1055288" uid="_13360741834971941">code1</a>sku</p>

I'm trying to detemine the position of "<a class="productLink" working backwards from the position of "code1="

Thanks

...

nice - not sure it's got too many practical implementations other than showing a junior how to run and correct checkdb, but it's still nice to have in your arsenal

Cadavre (5/2/2012)

---

michael vessey (5/2/2012)

---

depends if you need a BIGINT or not - i'd suggest just using yours for anything when max-min > 32,767 - otherwise use the nice small (low...

mohan.bndr (5/1/2012)

---

Hi,

If the current buffer hit cache ration is consistently above 99% then, Is it benefit to adding RAM to a server to boost hardware performance of sql server? why?

And...

+1 GSquared - he beat me to it

to find the first instance of a character in a string use "charindex"

to find the last instance use a combination of charindex and REVERSE

select LEN(col3) - CHARINDEX('A',REVERSE,col3)) as last_a, CHARINDEX('B',col3))...

does the following count as a loop?

INSERT INTO dbo.yourTable default values

go 100

??:-P??