Have you checked that the system date and time on the server are correct?

Fantastic, a conversation about grammar Sorry fhanlon, but going back to the Dictionary.com reference, if you follow the link for "Usage Note"...

I think in the question it should be 'effect', rather than 'affect' (otherwise, which UPDATE statement is affected?) - and, being a grammar nazi, I therefore got this question 'wrong'...

I'm afraid I am now in the same boat as Jeff. I do not understand what you are trying to achieve. Can you explain the problem without trying...

Ilan, it looks like you're trying to do some update processing that depends on the results of several select queries (but as Jeff said, it's not 100% clear from your...

Something like this?

declare @a varchar(50), @b-2 varchar(50)

set @a = '+002345'

set @b-2 = '-002345'

select cast(@a as decimal(19,2)) as 'a', cast(@b as decimal(19,2)) as 'b'

Regards

Phil

Not quite sure I understand what you're trying to do. You say that this is an INSERT trigger - ie a trigger which is run when a new record...

Anne's nearly got it.

Try this:

select replace(convert(varchar(12),getdate(),114),':','')

Regards

Phil

Presumably you have a reason for using fixed-width files rather than [tab] or [comma] delimited? A mainframe background, perhaps

When you open the fixed-width...

Here's another version that does not require any joins:

Select ClientID from ClientRegs

where RegionID = 1 or RegionID = 28

group by ClientID

having count(ClientID) > 1

Regards

Phil

Hi Val

It seems that your original statement is nearly giving you what you want, except that you have spaces where you want zeroes to appear. So can you just...

Not sure how you are achieving this - Enterprise Manager or Query Analyser? I would expect the sp_rename stored procedure to work the fastest via QA. It was...

Hi Bernard - what sort of constraint? Some constraints (eg PK, FK) do not need to be dropped before renaming fields.

Otherwise, can't you just drop the constraint, rename the...

I must admit - I just assumed that a field called GivenName would be a string

DATALENGTH is a more general function, as it...

If I work on the assumption that you have a table 'tblNewRecords' that contains the daily updates, you can work along these lines:

--First do the updates

update all

set all.* = new.*...