Sybase ASE 15 SQL Query

• macdca

  SSC-Addicted

  Points: 466

  More actions

  February 18, 2014 at 4:39 am

  #104229

  Im not sure if this the right forum but:

  I have a data output with many rows. In order to group things with flags, I do this in excel using 2 formulas which *** a flag of 0 or 1 in 2 new columns.

  This takes a long long time as I have hundreds of thousands of rows and wondered of I could do it in sql?

  Its transact SQL and the formulas I use in excel are:

  =IF(SUMPRODUCT(($A$2:$A2=A2)*($B$2:$B2=B2)*($C$2:$C2>=C2-1/24)*($C$2:$C2< C2+1/24))> 1,0,1)

  =IF(SUMPRODUCT(($A$2:$A2=A2)*($B$2:$B2=B2))>1,0,1)

  Any idea how I can do this in sql??

  The columns above do not relate to the actual columns I use, just an example.

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  February 18, 2014 at 4:49 am

  #1689829

  This site is for Microsoft SQL Server, not any generic SQL database. Maybe try http://www.dbforums.com, they should have a sybase sections

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass