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
Abhilash J A
534
2.4k
597.2k
Conversion failed converting the varchar value ',' to int
Jan 8 2016 4:24 AM
DECLARE @temp TABLE (Id varchar(MAX) NOT NULL, name varchar(MAX) NOT NULL ,itemtype varchar(50) NOT NULL );
INSERT @temp (Id,name,itemtype)
SELECT distinct STUFF((SELECT ',' + Item.Id FROM Items Item
INNER JOIN ProductDetails on Item.Id=ProductDetails.ItemsId
where Item.BrandsId in (select id from Brands) FOR XML PATH('')),1,1,'') AS ID,Item.ItemName,'Item' FROM Items AS Item
GROUP BY Item.ItemName
Select * from @temp
Reply
Answers (
3
)
How to add in other whenever came from Public holiday date
Is it possible when i want to join data from 2 databases?