Hi Damon, I'm picking up some useful information here, might be worth a look for you too.

Cheers

ChrisM

Damon Wilson (12/17/2007)

---

Chris,

We have a SQL Server 2000, Crystal Reports XI and Lawson 9, with Lawson Business Intelligence 9 environment (LBI).

The Crystal Report and SQL Server issue is difficult enough,...

Thanks again...but...one of the reports returns 4.4 million rows and since this is financials, the NOLOCK hint is "probably best not used" (see today's editorials). This one report can and...

Hi Yvan

Many thanks for the quick reply. I've figured out that it's the SQL side where...

Welcome, Lenard. Good luck!

It's not so bad here in London - see Jobserve.

Most of my contractor mates start looking 4 weeks before term. Until a renewal is signed, we're actively looking for...

Karthik

You need to account for the duration and cost of travel. London is about 30 miles across, and people live within and outside its limits. Cheaper accommodation further away from...

You could try these as an alternative:

SELECT

p.ID,

p.FirstName,

p.LastName

FROM Person p

INNER JOIN @searchParts s

ON (p.FirstName...

Yay! 😀

Hi David

Working with person names and addresses is far easier than working with company names and addresses because company names are likely to contain common elements which relate to the...

Use table aliases to make your query far more readable, and correct your join syntax:

SELECT gr.Code_t,

SUM(case when gr.RevDate = '1/1/07' then gr.CommissionableRevenue end) as JanCommis,--

SUM(case when gr.RevDate = '1/1/07' then...

Do you know any of the details? Some older db's e.g. xbase clones had implementations of SQL which worked perfectly well using IIF() instead of CASE;

SUM(IIF(today = 'wednesday', 1, 0))

What's your linked server, Edmund?

Adam is spot on, but you only need to join your recoverable costs table once:

[font="Courier New"]SELECT UVS.StockbookNumber,

UVS.FullChassis,

UVS.SellingPrice,

UVS.RegistrationNumber,

Sum(CASE OTn.RecoverableNRC WHEN 'N' THEN VSn.ActualCost ELSE 0 END) AS 'NR Sum of ActualCost',

Sum(CASE...

Blimey! That would sure confuse the hell out of anybody trying to maintain it! Here's a way of doing it which is very close, but which we've all seen and...