Roy Ernest (1/22/2010)

---

Born and educated in Kerala, India (Southern tip of India). Our state is known as Gods own paradise because of its beauty. Back waters, Mountains, forests, beaches and...

Have you been there, Gail? We have a surfeit of excellent wildlife programmes covering the big African critters, but a shortage...

GilaMonster (1/22/2010)

---

Windhoek? Why on earth do you want to visit Windhoek? There's desert...

If I were you mate, I'd ditch this and start all over again.

Looking at the two right-joined tables recipe and items, seems they would be best listed first as...

P Jones (1/22/2010)

---

I'm the one with lions wandering nearby - living next to Lord Bath's Longleat house and safari park in...

declare @date1 datetime, @date2 datetime;

set @date1 = '01/21/2010';

set @date2 = '01/22/2010';

SELECT

DISTINCT count(*) AS Form3and4,

br.br_districtid

FROM [192.168.3.201].[fdhs_server].TELEMONITORING.beneficiaryregistration br

INNER JOIN [192.168.3.201].[fdhs_server].TELEMONITORING.beneficiaryvisitrecords bvr

ON bvr.vr_beneficiaryid...

datelligence (1/21/2010)

---

Yes, this is satisfactory. What I need is instead of manually defining the variables in the query, it must be defined dinamically by the selection made...

The 07:41 from Reading to Leamington was cancelled today for the second time this week. This is unusual, it's been an excellent service so far. The jouney home is in...

Just the pivot code, using whatever values for the columns will work - and may be passed in later. Forget about EXECUTE for now. Just a plain old SELECT with...

This won't return any rows because receive_email_notice can't be NULL and NOT NULL at the same time. Something like this should do the trick:

AND (c.receive_email_notice is NULL

OR c.receive_email_notice...

Is travelling in London made intentionally difficult? Not really. The Central and Victoria tube lines are generally very good, the Jubilee line can be a little temperamental, the others are...

Forget about the INSERT for the moment - does the pivot work yet?

Does this query work? It looks like the closing quote is missing.

In most cases a stored procedure would be recommended - you can pass the necessary parameters and receive a...

arun.sas (1/21/2010)

---

or

SELECT title, REPLACE(title, '_', '/') AS NewTitle

FROM #TSRECORD

WHERE...

-- make up some sample data

DROP TABLE #TSRECORD

CREATE TABLE #TSRECORD (title VARCHAR(30))

INSERT INTO #TSRECORD (title)

SELECT '170_2456_03' UNION ALL

SELECT '170_8976_03' UNION ALL

SELECT '170_21456_03' UNION ALL

SELECT '170_82976_03' UNION ALL

SELECT '170_222456_03' UNION ALL

SELECT...