Sounds like a process/application change to me. Hardware should have nothing to do with this.

As far as testing for invisible characters is concerned, you were on the right track...

Could it be a zero-length string? Try running

select *

from table where id = 12345 and GivenName = ''

If the record is still returned, you've cracked it.

Regards

Phil

Hi Maria

Something like this gets rid of the cursor and does everything in far fewer statements:

update wtp

set MinDate = (SELECT min(wtf.create_dt) FROM WT_ESPP_FACT wtf

...

Hi Maria, had a quick look at this and I think it can be re-coded, without needing a cursor and using fewer lines of code. However, no time at...

Can you expand a bit on what your problem is? Many people here try to avoid cursors as much as possible, for performance reasons, but sometimes you just have...

Hi Kristin, no problem. I don't think I was too far away with my last attempt Here's a refined version (it...

I'm sure that we can help you out with just a bit more information.

1) What is the link between Records and Chains?

2) What do you want to set Records.Chainpath to?

3)...

It's not as easy as you might expect. Here's a bit of SQL that might get you heading in the right direction:

select getdate() as datetime, cast(floor(cast(getdate() as float)) as...

Something like this should do the trick:

declare @date1 datetime

set @date1 = '20050228'

select dateadd(day,-day(@date1),dateadd(month,2,@date1))

Phil

Thanks Steve, saves me responding

Phil

Hi Nathan

I've had to solve this before. Try this:

WHERE LastName = IsNull(@var1,LastName) AND

IsActive = IsNull(@var2, IsActive)

Phil

I don't think there's a really nice solution to this one. But this might work:

select t1..., t2..., t3...

from

t1 inner join t2 on t1.id = t2.id cross join...

"... If so, make sure you create an update trigger ..." - no need. Just change the create trigger line as follows:

CREATE TRIGGER dbo.EmailINS ON Email FOR INSERT, UPDATE

Phil

Something like this should get you most of the way:

create TRIGGER [name] ON

FOR INSERT

AS

update

set created_by = SUSER_SNAME(),

last_modified_by = SUSER_SNAME(),

date_created = GETDATE(),

date_last_modified = GETDATE()

from inserted

where .Seqno = inserted.seqno;

create...

Hmmm - not quite sure what you're after. Do you have a 'person' table containing an e-mail field and want to maintain a separate table which contains just e-mail address...