Let's look at it this way...

- every SubCategory always belongs to some Affiliation, and only to one

- having both FK's in the table Institutions is not correct, because you duplicate...

Aargh didn't come through, have to write again.

To be honest, I would insist that the import file must have values in all columns....

KYSC,

You posted you solved the problem by rewriting the query, but in case you still are interested in finding out what was the problem... there is no way to...

Same as Ryan, I'm not sure how efficient this code is, but it should work - if what you said is correct, I mean if there are no gaps (time...

If so, then the result should be following... is this what you need?

Item  |StartDate  |EndDate    | Price

1        1/1/2004    31/2/2004   100

1        1/3/2004    31/3/2004   150

1        1/4/2004    31/5/2004   250

1        1/6/2004    31/6/2004   100

2        1/1/2004    31/2/2004   200

Please explain the position of the red row :

Item  |StartDate  |EndDate    | Price

1        1/1/2004    31/2/2004   100

1        1/3/2004    31/3/2004   150

2        1/1/2004    31/2/2004   200

1        1/4/2004    31/5/2004   250

1        1/6/2004    31/6/2004   100

As you probably know, rows in tables are...

Ryan, I'm from Europe as well, so DD/MM/YYYY seems normal to me it was really just the dates like 31/2/2004 that made me...

Unfortunately, I wouldn't be so sure this will work. It would, if the StartDate and EndDate are datetime columns... however, a look at posted values tells me that this is in fact...

Hmmm... did you check the job step that is failing? In Advanced properties, there is "Run as user" setting which could play some role in your problems. Otherwise, I have...

You mean like this?

SELECT p.dbid, d.[name], Count(*)

FROM   master..sysprocesses p

JOIN master..sysdatabases d ON d.dbid = p.dbid

WHERE  spid > 50 

GROUP BY p.dbid, d.[name]

Hi,

on a sidenote, if your log grows to 23GB every night, it would be wise to leave it at this size and not shrink it every day. It is quite...

I prefer DISTINCT, if the only thing I need to do is remove duplicate rows. It looks cleaner in the code, you don't have to check select list and group by...

SELECT * FROM your_table where your_column = 'E-02162/06'

I suppose that this is not what you asked for, but I can hardly help you unless you describe what you need - that...

Hmm... you say that entries from last century begin with 9, but as can be seen from your code, they only have 6 digits (otherwise the result would be nonsense)....

Please look up in BOL : Full-Text Indexing Support, sp_fulltext_catalog, sp_fulltext_table and other related entries. I don't think copying and pasting everything here would be of some use... just one little...