Forum Replies Created

Viewing 15 posts - 12,151 through 12,165 (of 12,247 total)

  • RE: Determine character in database field

    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...

  • RE: Determine character in database field

    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

  • RE: Cursor or the While loop?

    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

    ...

  • RE: Cursor or the While loop?

    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...

  • RE: Cursor or the While loop?

    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...

  • RE: how to test for condition??

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

  • RE: how to test for condition??

    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)...

  • RE: I dont want datatime datatype ...just date

    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...

  • RE: Problem with adding a month to February 28

    Something like this should do the trick:

    declare @date1 datetime

    set @date1 = '20050228'

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

    Phil

  • RE: SP wildcard

    Thanks Steve, saves me responding

    Phil

  • RE: SP wildcard

    Hi Nathan

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

    WHERE LastName = IsNull(@var1,LastName) AND

    IsActive = IsNull(@var2, IsActive)

    Phil

  • RE: Effective dated query

    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...

  • RE: sql server 2000 trigger for checking duplicate email in a table

    "... 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

  • RE: SQL SERVER 2000 trigger for Audit trail

    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...

  • RE: sql server 2000 trigger for checking duplicate email in a table

    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...

Viewing 15 posts - 12,151 through 12,165 (of 12,247 total)