i ve to display data in commas in sql :-
Returning a Comma

CREATE FUNCTION dbo.fn_GetTherapistName(@AppCode int)
RETURNS VARCHAR(1000) AS

BEGIN
   DECLARE @StudentList varchar(1000)

   --SELECT @StudentList = COALESCE(@StudentList + ', ', '') + CAST(m.TherapistId AS VARCHAR(15))
   --FROM multipleTherapy m
   --WHERE m.AppCode = @AppCode
SELECT @StudentList = COALESCE(@StudentList + ', ', '') + CAST(dbo.staff_Master.firstname AS VARCHAR(100))
FROM         dbo.multipleTherapy INNER JOIN
                      dbo.staff_Master ON dbo.multipleTherapy.TherapistId = dbo.staff_Master.empcode
WHERE     (dbo.multipleTherapy.AppCode = @AppCode)

   RETURN @StudentList
END

Comments

Post a Comment

Popular posts from this blog

Export gridview into excel pdf csv   http://www.aspsnippets.com/ Articles/Print-functionality- in-ASP.Net- GridView -control. aspx  http://www.aspsnippets.com/ Articles/Export- GridView -To- Word-Excel-PDF-CSV-Formats-in- ASP.Net.aspx
Read more
How to insert multiple rows from c# table to sql database table:- Frontend:   <asp:Button ID="Button2" runat="server" Text="Create Table"             onclick="Button2_Click" /> <asp:GridView ID="gveg" runat="server">         </asp:GridView> Backend C#:  protected void Button2_Click(object sender, EventArgs e)     {         //         // Here we create a DataTable with four columns.         //                 DataTable temptable = new DataTable();         temptable.Columns.Add("ProductID", typeof(string));         temptable.Columns.Add("RelatedProductID", typeof(string));       ...
Read more