need help in sql

• LutzM

  SSC Guru

  Points: 107049

  More actions

  February 28, 2010 at 2:59 am

  #1126225

  tabrez.test (2/27/2010)

  ---

  also ihave tried above sql they are also displaying policies which have trans add and trans can and in between other trans like ren,adj,,,(which should not )

  i want policies with has trans ADD and followed by CAN imeediately

  Would you please provide some sample data that will actually support your statement? (meaning: give us some ready to use sample data including your ID column and the values that you have in there for the data that fail).

  I'm guessing you apply a different ORDER BY to your data than we all assume right now.

  Show us where you get stuck and we'll most probably be abel to help you. Those verbal descriptions won't really help.

  ---

  
  Lutz
  A pessimist is an optimist with experience.

  How to get fast answers to your question[/url]
  How to post performance related questions[/url]
  Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]