home Links Articles Books Past Meetings Photos SiteMap
The MDCFUG is sponsored by TeraTech. Visit us at www.TeraTech.com

Please send
comments/questions to

michael@
teratech.com

 
Reinventing the wheel?

    Here's the SQL code
    (with T-SQL syntax):
    declare @cnt1 int
    declare @cnt2 int
    declare @cnt3 int
    declare @res bit
    select @cnt1 = count(*) from A
    select @cnt2 = count(*) from B
    select @cnt3 = count('x')
    from (select * from A
    UNION
    select * from B) as t

    if (@cnt1 = @cnt2)
    and (@cnt2 = @cnt3)
    begin
    set @res = 1
    print 'A = B'
    end
    else
    begin
    set @res = 0
    print 'A <> B'
    end
    go

Previous slide Next slide Back to first slide View graphic version


Home | Links | Articles | Past Meetings | Meeting Photos | Site Map
About MDCFUG | Join | Mailing List |Forums | Directions |Suggestions | Quotes | Newbie Tips
TOP

Copyright © 1997-2017, Maryland Cold Fusion User Group. All rights reserved.
< >