here is the smart question.............

• sqlmaverick

  Default port

  Points: 1462

  More actions

  June 10, 2011 at 6:01 pm

  #239047

  I have created two partitions on different columns for same table. I posted queries below

  ON Datetime:

  Create partition function archive_dtPF(datetime)

  as range right for values('20110101','20110401','20110701','20111001')

  Create partition scheme archive_sh as partition archive_dtpf

  to (archive2010q4FG, archive2011q1FG, archive2011q2FG,

  archive2011q3FG, archive2011q4FG, archive2012q1FG)

  &&&&&&&&&&&&&&&&&&&&&&&&&&&&&&

  ON Platform_ID

  Create partition function platform_idPF(varchar(50))

  as range left for values ('AVMselect','RealQuest','Vector')

  Create partition scheme platform_idsc as partition platform_idPF

  to( platformavmFG, platformrealFG, platformvectorFG) but i am getting error for creation of scheme,,the error msg is shown below

  I have a question here.........

  There is any relation builds between the two partition, if not how can i build the relation. I tried in practical but i can't find any relation.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736524

  More actions

  June 10, 2011 at 6:11 pm

  #1337333

  Whatever code page you used for posting has mangled this so that it's a little hard to read.

  Also, no error message is shown