How to distinguish different data? RSS

• • Reply
  

  cenk1536

  Contributor

  2503 Points

  2118 Posts

  How to distinguish different data?

  May 07, 2012 08:45 AM|LINK

  Hi,

  I am getting data from SQL and setting data into variables. if there are different EventID's then I have to set different variables. How can I make this process fast?

  Best regards.

  Here is sample data: (EventID's are 10 and 11)

  482 NULL 10 TOM TOMSK-SPARTAK NALCHIK Active 0 1 - 0101 1   0101 2.00
  482 NULL 10 TOM TOMSK-SPARTAK NALCHIK Active 1 X - 0102 X   0102 3.00
  482 NULL 10 TOM TOMSK-SPARTAK NALCHIK Active 2 2 - 0103 2   0103 2.10
  482 NULL 10 TOM TOMSK-SPARTAK NALCHIK Active 3 1X - 0104 1X   0104 0
  482 NULL 10 TOM TOMSK-SPARTAK NALCHIK Active 4 12 - 0105 12   0105 0
  482 NULL 10 TOM TOMSK-SPARTAK NALCHIK Active 5 X2 - 0112 X2   0112 0
  482 NULL 10 TOM TOMSK-SPARTAK NALCHIK Active 6 1 - 0113 1   0113 2.00
  482 NULL 10 TOM TOMSK-SPARTAK NALCHIK Active 7 X - 0114 X   0114 1.50
  482 NULL 10 TOM TOMSK-SPARTAK NALCHIK Active 8 2 - 0115 2   0115 3.00
  482 NULL 10 TOM TOMSK-SPARTAK NALCHIK Active 11 Under - 0125 Under   0125 2.05
  482 NULL 10 TOM TOMSK-SPARTAK NALCHIK Active 12 Over - 0134 Over   0134 1.60
  482 NULL 10 TOM TOMSK-SPARTAK NALCHIK Active 13 Under - 0135 Under   0135 2.15
  482 NULL 10 TOM TOMSK-SPARTAK NALCHIK Active 14 Over - 0145 Over   0145 1.55
  482 NULL 10 TOM TOMSK-SPARTAK NALCHIK Active 23 Under - 0215 Under   0215 3.20
  482 NULL 10 TOM TOMSK-SPARTAK NALCHIK Active 24 Over - 0223 Over   0223 1.25
  482 NULL 10 TOM TOMSK-SPARTAK NALCHIK Active 29 Home team - 0245 Home team   0245 2.10
  482 NULL 10 TOM TOMSK-SPARTAK NALCHIK Active 30 Visitor team - 0301 Visitor team   0301 2.90
  482 NULL 10 TOM TOMSK-SPARTAK NALCHIK Active 31 None - 0302 None   0302 3.00
  482 NULL 10 TOM TOMSK-SPARTAK NALCHIK Active 0 1 - 0101 1   0101 2.00
  482 NULL 10 TOM TOMSK-SPARTAK NALCHIK Active 1 X - 0102 X   0102 3.00
  482 NULL 10 TOM TOMSK-SPARTAK NALCHIK Active 2 2 - 0103 2   0103 2.10
  482 NULL 10 TOM TOMSK-SPARTAK NALCHIK Active 3 1X - 0104 1X   0104 0
  482 NULL 10 TOM TOMSK-SPARTAK NALCHIK Active 4 12 - 0105 12   0105 0
  482 NULL 10 TOM TOMSK-SPARTAK NALCHIK Active 5 X2 - 0112 X2   0112 0
  482 NULL 10 TOM TOMSK-SPARTAK NALCHIK Active 6 1 - 0113 1   0113 2.00
  482 NULL 10 TOM TOMSK-SPARTAK NALCHIK Active 7 X - 0114 X   0114 1.50
  482 NULL 10 TOM TOMSK-SPARTAK NALCHIK Active 8 2 - 0115 2   0115 3.00
  482 NULL 10 TOM TOMSK-SPARTAK NALCHIK Active 11 Under - 0125 Under   0125 2.05
  482 NULL 10 TOM TOMSK-SPARTAK NALCHIK Active 12 Over - 0134 Over   0134 1.60
  482 NULL 10 TOM TOMSK-SPARTAK NALCHIK Active 13 Under - 0135 Under   0135 2.15
  482 NULL 10 TOM TOMSK-SPARTAK NALCHIK Active 14 Over - 0145 Over   0145 1.55
  482 NULL 10 TOM TOMSK-SPARTAK NALCHIK Active 23 Under - 0215 Under   0215 3.20
  482 NULL 10 TOM TOMSK-SPARTAK NALCHIK Active 24 Over - 0223 Over   0223 1.25
  482 NULL 10 TOM TOMSK-SPARTAK NALCHIK Active 29 Home team - 0245 Home team   0245 2.10
  482 NULL 10 TOM TOMSK-SPARTAK NALCHIK Active 30 Visitor team - 0301 Visitor team   0301 2.90
  482 NULL 10 TOM TOMSK-SPARTAK NALCHIK Active 31 None - 0302 None   0302 3.00
  482 NULL 11 ANKARAGUCU-KARABUKSPOR Active 0 1 - 0101 1   0101 2.00
  482 NULL 11 ANKARAGUCU-KARABUKSPOR Active 1 X - 0102 X   0102 3.00
  482 NULL 11 ANKARAGUCU-KARABUKSPOR Active 2 2 - 0103 2   0103 2.10
  482 NULL 11 ANKARAGUCU-KARABUKSPOR Active 3 1X - 0104 1X   0104 0
  482 NULL 11 ANKARAGUCU-KARABUKSPOR Active 4 12 - 0105 12   0105 0
  482 NULL 11 ANKARAGUCU-KARABUKSPOR Active 5 X2 - 0112 X2   0112 0
  482 NULL 11 ANKARAGUCU-KARABUKSPOR Active 6 1 - 0113 1   0113 3.00
  482 NULL 11 ANKARAGUCU-KARABUKSPOR Active 7 X - 0114 X   0114 2.10
  482 NULL 11 ANKARAGUCU-KARABUKSPOR Active 8 2 - 0115 2   0115 2.00
  482 NULL 11 ANKARAGUCU-KARABUKSPOR Active 11 Under - 0125 Under   0125 2.15
  482 NULL 11 ANKARAGUCU-KARABUKSPOR Active 12 Over - 0134 Over   0134 1.55
  482 NULL 11 ANKARAGUCU-KARABUKSPOR Active 13 Under - 0135 Under   0135 1.90
  482 NULL 11 ANKARAGUCU-KARABUKSPOR Active 14 Over - 0145 Over   0145 1.70
  482 NULL 11 ANKARAGUCU-KARABUKSPOR Active 23 Under - 0215 Under   0215 2.05
  482 NULL 11 ANKARAGUCU-KARABUKSPOR Active 24 Over - 0223 Over   0223 1.60
  482 NULL 11 ANKARAGUCU-KARABUKSPOR Active 29 Home team - 0245 Home team   0245 2.60
  482 NULL 11 ANKARAGUCU-KARABUKSPOR Active 30 Visitor team - 0301 Visitor team   0301 2.40
  482 NULL 11 ANKARAGUCU-KARABUKSPOR Active 31 None - 0302 None   0302 3.00

  Keep your friends close and your enemies even closer
• • Reply
  

  sriramabi

  Contributor

  4351 Points

  1277 Posts

  Re: How to distinguish different data?

  May 07, 2012 10:06 AM|LINK

  pls refer this

  http://blog.sqlauthority.com/2007/12/20/sql-server-distinct-keyword-usage-and-common-discussion/

  http://blog.sqlauthority.com/2007/03/29/sql-server-difference-between-distinct-and-group-by-distinct-vs-group-by/

  • Marked as answer by Catherine Shan - MSFT on May 14, 2012 01:55 AM
• • Reply
  

  Catherine Sh...

  All-Star

  23382 Points

  2490 Posts

  Microsoft

  Re: How to distinguish different data?

  May 09, 2012 08:32 AM|LINK

  Hi cenk1536,

  If you want to distinguish different data from SQL, you can try to use SQL GROUP BY Statement. The reason is that it is used in conjunction with the aggregate functions to group the result-set by one or more columns.

  Syntax is as follows:

  SELECT column_name, aggregate_function(column_name)
  FROM table_name
  WHERE column_name operator value
  GROUP BY column_name

  For details about it, please check the link below:

  http://www.w3schools.com/sql/sql_groupby.asp

  Best wishes, 

  Please mark the replies as answers if they help or unmark if not.
  Feedback to us
  
  Develop and promote your apps in Windows Store
  
  • Marked as answer by Catherine Shan - MSFT on May 14, 2012 01:55 AM