Hi, This post is quite the opposite of the previous post. That is, in the previous post, We inserted a comma separated string into separate rows. Here we will return a single comma separated string by concatenating values from separate rows. The query for this is very simple. Say, our table has two columns, UserId and […]
Month: September 2012
Adding items in comma-separated string into separate rows in SQLServer
Hi, In this post, I’ll show how to insert a items in a comma-separated string into separate rows in a table. Consider for example we have a comma-separated string such as “amogh, anish, anvesh, uday”. after inserting into the table, the output should be like: I have written a stored procedure which will […]
Happy Ganesh Chaturthi to all :-)
Hi, I wish you all a very Happy Ganesh Chaturthi.!! Hope you have a great day and year ahead! Ganapathi Bappa Morya!! Also, I would like to request all of you to only use Ganesh idls made from clay and not P.O.P. Idols made from clay are environment friendly and don’t cause […]
Webhooks, webhook urls and an implementation of webhooks (sample)
Hi, Today I would discuss about webhooks, webhook Urls and finally how to implement a webhook url. I had to implement the webhook url concept recently and boy! I had to struggle a lot for understanding what webhook actually means and also the implementation of a webhook. But when I actually got the whole idea, […]