Bhuvnesh (1/11/2010)

---

sample data is not possible , as it includes amny tables

yes row count is correct and time taken = 18 secs

but my concerns is UNION ALL ...

Bhuvnesh (1/11/2010)

---

sample data is not possible , as it includes amny tables

yes row count is correct and time taken = 18 secs

but my concerns is UNION ALL ...

There's always a danger of this when there's no sample data to test against. Could you provide some details of why it's...

No problem. Note - this is UNTESTED.

select

reg_id = ISNULL(dr1.reg_id, dr2.reg_id), -- changed

invitee_id = ISNULL(di1.invitee_id, di2.invitee_id), -- changed

contact_type = isnull(ct.cont_type_name, ''),

item_id = I.item_id,

item_type = i.item_type, ...

Of course...

drop table #test

GO

CREATE TABLE #test (

[order] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[year] [varchar]...

drop table #test

GO

CREATE TABLE #test (

[order] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[year] [varchar] (50)...

Please read the link below in my sig, it will show you how to create tables and load sample data for people to test their solutions to your problem.

Hi Whitlander

without this essential information, I can't test and complete the code I've written and have to leave here soon because trains are...

I've got a solution ready to test,...

Hi Scott

Run this 'ere bit of code, and the answer will come to you in a flash:

SELECT Customer, COUNT(*) AS trxTotal, COUNT(trx) AS trxNonNULL

FROM YourTable

GROUP BY Customer

Lynn Pettis (1/8/2010)

---

whitlander (1/8/2010)

---

Example from 'event' table:

IDSource_IDEventType_ID Use_ID Period

34022 ...

whitlander (1/8/2010)

---

Example from 'event' table:

IDSource_IDEventType_ID Use_ID Period

34022 10 ...

SELECT planned.ID,

planned.Source_ID,

planned.Event_ID,

planned.User_ID,

planned.Period,

(SELECT TOP (1)

ABS(DATEDIFF(dd, Period, planned.Period)) AS Expr1

FROM Event AS actual

WHERE (Source_ID = planned.Source_ID)

AND (EventType_ID IN (5, 6))

ORDER BY Expr1) AS 'KPI (Days Over/Under...

Where are the rules which dictate what earnings match to what deduction?

BASIC Earnings 5000 PF Deduction 2000

How do these two entities relate?

rpatil22 (1/7/2010)

---

Guys I will receive a string

'name',a1,b1,c1,a2,b2,c2,a3,b3,c3,a4,b4,c4

i want to make data in table

name a1 b1 c1

name a2 b2 c2

name...