Viewing 15 posts - 8,266 through 8,280 (of 10,144 total)
Bhuvnesh (1/11/2010)
yes row count is correct and time taken = 18 secs
but my concerns is UNION ALL ...
January 11, 2010 at 3:29 am
Bhuvnesh (1/11/2010)
yes row count is correct and time taken = 18 secs
but my concerns is UNION ALL ...
January 11, 2010 at 3:11 am
Bhuvnesh (1/11/2010)
thanks for ur reply but its not working
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...
January 11, 2010 at 3:01 am
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, ...
January 11, 2010 at 2:41 am
Of course...
drop table #test
GO
CREATE TABLE #test (
[order] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[year] [varchar]...
January 11, 2010 at 2:28 am
drop table #test
GO
CREATE TABLE #test (
[order] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[year] [varchar] (50)...
January 8, 2010 at 10:23 am
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.
January 8, 2010 at 9:32 am
Lynn Pettis (1/8/2010)
Sample data? INSERT INTO statements.
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...
January 8, 2010 at 9:26 am
whitlander (1/8/2010)
thanks for your help guys.I'm not sure how to re-write the sub query, what functions do I use to return the negative value?
I've got a solution ready to test,...
January 8, 2010 at 8:02 am
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
January 8, 2010 at 7:14 am
Lynn Pettis (1/8/2010)
whitlander (1/8/2010)
IDSource_IDEventType_ID Use_ID Period
34022 ...
January 8, 2010 at 7:09 am
whitlander (1/8/2010)
IDSource_IDEventType_ID Use_ID Period
34022 10 ...
January 8, 2010 at 6:57 am
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...
January 8, 2010 at 6:50 am
Where are the rules which dictate what earnings match to what deduction?
BASIC Earnings 5000 PF Deduction 2000
How do these two entities relate?
January 8, 2010 at 6:28 am
rpatil22 (1/7/2010)
'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...
January 8, 2010 at 6:25 am
Viewing 15 posts - 8,266 through 8,280 (of 10,144 total)