TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Mangesh barmate
NA
118
136.7k
how to get value by passing multiples value in T-Sql ?
Feb 7 2013 9:19 AM
Hi,
I have a table which has 2 columns namely PlanId and RiderId in below format-
Query is- I want pass multiple riderid and i want to get PlanId on the base of multiple RiderId.
In this case i will pass 327,329,330,326,355.
But 327 available in 2 times in planId column having 356349 and 356347 but here i want only one PlanId which is 356349 , because it hold combination values. How i accomplish this.
PlanId RiderId
356348 330
356348 355
356348 327
356348 329
356349 327
356349 329
356349 330
356349 326
356349 355
Reply
Answers (
1
)
Auto Increment nvarchar Column in Sql Server 2008
how to use function in sql server with simple example