Hello,

I suppose that from the viewpoint of SQL Server this is export, not import... and I'm a bit confused - what do you mean by smart headers, especially if they...

As far as I know, you simply can't use this type of condition. The asterisk can only be at the end of the phrase when using CONTAINS.

BOL seems to confirm...

goodguy,

the column you are speaking about is DATETIME datatype, right?

Datetime values are not stored in any format, they are stored absolutely unambiguously, as amount of time that has passed since...

David,

is Parsename so efficient that you prefer it over standard conversion?

I would prefer this:

SELECT CONVERT(datetime,'14.08.1924',104)

Mark,

you could also consider changing the datatype of the column to DATETIME if possible, or...

Did you read about SET IMPLICIT_TRANSACTION in BOL? I think it is described pretty well there. If you don't understand something from it, then it would be best to ask...

David,

it would be nice if you included your explanation why you think it isn't a duplicate, then it would be a lot easier for me to reply.

If you refer to...

I think that in fact LEFT JOIN is more appropriate here, because otherwise only those rows of condiguration table that have valid entry in all 4 CCI columns will be...

Duplicate post

It would help to post some example of the data in both tables. As far as I can see now, it is a simple select with LEFT JOIN and WHERE...

"Will it just update what it can or will it update all"

That question looks a bit funny 🙂 if something can't be updated, then it won't be updated. Problem is,...

OK, seems that the time ranges should not overlap, except a single possibility if it happens right on the dot when the shift changes. If the data are as you...

If really the date columns alone are enough to identify the matching rows, then it could be like this:

UPDATE t1

SET Shift_ID = t2.Batch_ID

FROM table1 t1

JOIN table2 t2 ON t1.StartTime...

I'm afraid I don't understand the requirement of "between start and end date".

What do you need to do, just create the FK constraint, or establish the relationship based on new...

Well, not sure, but maybe you want to do something like this?

select cfg.*, v1.EXTERNAL_VALUE, v2.EXTERNAL_VALUE, v3.EXTERNAL_VALUE, v4.EXTERNAL_VALUE

from v_configurationitem cfg

inner join v_valuemapping v1 on v1.INTERNALVALUE = cfg.ccicode1

inner join v_valuemapping v2 on...

The "N" means that the string following it should be treated as NCHAR. I think it isn't necessary here (makes no difference), because BOL says:

"object is either char or nchar....