User Profile

Collapse

Profile Sidebar

Collapse
lukaxa
lukaxa
Last Activity: Oct 27 '13, 12:38 PM
Joined: Oct 23 '13
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • lukaxa
    replied to sql find exact string, NOT LIKE
    in SQL Server
    this is not an option. this data is fixed and given from other person.

    how can i normalize data?

    there can be 2 group per user or 1000 group per user. i can't create columns for each one.
    See more | Go to post

      Leave a comment:

    • lukaxa
      started a topic sql find exact string, NOT LIKE
      in SQL Server

      sql find exact string, NOT LIKE

      i have table with two column

      ID and groups.


      ID: (1) (2) (3)
      Groups: (2,12,21) (11,1,31) (43,44,144)


      i want to find id with group 1, if i use "Like" , i am receiving every ID with number 1 in groups: 12,21,11,1,31,1 44.
      answer will be (1) (2) (3)


      i want just second ID with group number 1

      ID (2)

      maybe there is some Substring function,...
      See more | Go to post
      No activity results to display
      Show More
      Working...