I'd check for NULL decsription in the source table:

DECLARE MOVEITEMS_CUR CURSOR FOR

SELECT MOVEITEMSID, MOVEDATE, ITEMID, [DESCRIPTION], USERID

FROM MYOB_IMPORT..MOVEITEMS

WHERE [DESCRIPTION] IS NOT NULL

The code is horrible! I gave...

Can you work it out from this:

SELECT

d.Today,

StartTime = DATEADD(hour,8,d.Today),

EndTime = DATEADD(hour,10,d.Today)

FROM (SELECT Today = CAST(CAST(GETDATE() AS DATE) AS DATETIME)) d

Is column [LINE_CODE] correctly populated in all of the tables?

-- use proper join syntax

-- don't use double-quotes for identifiers unless absolutely necessary

-- write queries using TOP 1...ORDER BY and ROW_NUMBER() and choose quickest of the two

-- CROSS APPLY is...

-- Expanding the date range out by months rather than days might be 30x cheaper

;WITH OrderedData AS (

SELECT *,

rn = ROW_NUMBER() OVER(PARTITION BY AccountID ORDER BY DataDate DESC)

FROM...

Welcome. It's one of those things we take for granted after a while, not really...

UNION on it own dedupes the result set which is almost certainly not what you want.

Try combining the two queries into one so you're not reading tables twice, unnecessarily:

SELECT

TT.ID,...

"Complicated" is a relative word. If you're...

Those are 'rows' in...

Ganga-236835 (4/26/2013)

---

Well, not quite. There could be multiple regional offices for "Organizations", with each one having their own unique set of phone numbers. Again, for the purposes...

Ganga-236835 (4/26/2013)

---

patrickmcginnis59 10839 (4/26/2013)

This is an interesting case, so I'm guessing that it really depends on how important the functionality of the foreign key constraint is for your needed functionality....

Ganga-236835 (4/26/2013)

---

....

Adding these columns to each parent's object just does not make sense. There is no supporting case, at least in this system, where it would make sense to add...

+1

Ganga-236835 (4/26/2013)

---

Although I agree in principle that most common scenario regarding phone numbers is that there is one per person, in the system that I am designing that is just...

davidandrews13 (4/26/2013)

---

is it possible, or even considered OK, to put all your different Members tables (Clients, Staff, Managers) into one table called 'Clients', and have a Foreign Key to a...