How about this:

--== TEST DATA ==--

declare @data as table

(

CustID int,

ProdFamily varchar(15),

Route tinyint,

#ofStops int

);

insert @data values (10001, 'Dairy', 101, 14)

insert @data values (10001, 'Dry Groceries', 101, 14)

insert @data values (10001, 'Meat',...

salliven (2/22/2013)

---

If the created_date and modify date are not nullable, then please check this code.

create procedure usp_switch_data

@create_date datetime = null

,@modify_date datetime = null

as

if @create_date is not null or @modify_date...

There's a Sage SalesLogix Forum at:

community.sagesaleslogix.com/

They might be your best bet.

Why not use SUM()? This will count the 1s & effectively ignore the 0s.

I had a similar problem. The table included a date, so I made the date a compulsory filter & added an index with date first, then all the other...

mkswanson (2/21/2013)

---

I tried this, but I'm having the same problem I seem to have had with the other approaches I've taken. In this case, I'm getting a number of...

You appear to have 2 'ON' clauses in the RIGHT OUTER JOIN.

You could use aliases to simplify the code & make it more readable...

Like this:

SELECT SAL.businessDate,...

How about = instead of 'AS'

create view dbo.GlobaldataEOLT2

as

select [NUMCAM]

,[C_Fourn]

,[date_passage]

,[heure_passage]

,[banc]

,[NUMPale]

,[Module_Status]

,[Code_defaut]

,[Total_TestTime]

,[Purgerunin_TestTime]

,[ShifterPosHyst_TestTime]

,[ShifterActRespTime_TestTime]

,[GearActStroke_TestTime]

,[GearActRespTime_TestTime]

,[LeakageON_TestTime]

,[K1K2Leakage_TestTime]

,[QPVK1DeliveryTest_TestTime]

,[PPVK2PressureTest_TestTime]

,[LeakageOFF_TestTime]

,[PRVTest_TestTime]

,[OPS_NRV_Test_TestTime]

,[version_prog]

,[Jourprod] =

CASE WHEN heure_passage BETWEEN '00:00:00' and '05:59:59' THEN day(jour_passage) -2

ELSE day([date_passage]) -1

END

FROM dbo.T_EOLT_BRUTE_FLOAT

or

CASE WHEN heure_passage BETWEEN '00:00:00' and '05:59:59' THEN...

When you say it's not working - do you mean it errors or it produces unexpected results?

I haven't got SQL2000, but I think this will work.

Assuming I've understood the problem, ie it's the comparison & not the fact it's across databases...

I've used 3 tables on the...

Can you post some sample data in the same format as my test data. That would show what the problem is.

Here's a possible solution, if I've understood your requirements:

--== Create test data ==--

use tempdb;

go

drop table dbo.Trackthis;

drop table dbo.Trackingthis;

create table dbo.Trackthis

(

TrkthisID int,

name varchar(50),

Active char(5)

);

insert Trackthis values (1, 'Call', 'True');

insert Trackthis values...

This is not a good idea. It's best to use an identity for auto-incrementing numbers.

This has been covered here quite recently, & the consensus seems to be that you...

This might be a better way of doing it, if I've understood the requirement:

--== TEST DATA ==

-- Don't run this on your real table!!!

--IF OBJECT_ID('stk_matrix') IS NOT NULL

--DROP TABLE stk_matrix;

CREATE...

I don't use cursors myself but...

Surely you need a BEGIN -- END block for the WHILE?

Have you inserted the "IF @code2 = 'SUPPORT'

/* Move Support Discount to new variable...