SQL Server Performance

Search Results

Search Again
  1. Sandeep Mittal

    syntax error in function SP

    Post by: Sandeep Mittal, Jan 6, 2013 in forum: ALL SQL SERVER QUESTIONS
    OMG!!! I am sorry for the silly answer. While posting answer, I never realized, delete statement is not allowed in scalar functions. As suggested...
  2. Sandeep Mittal

    syntax error in function SP

    Post by: Sandeep Mittal, Jan 3, 2013 in forum: ALL SQL SERVER QUESTIONS
    CREATE FUNCTION delUserGrp (@name nvarchar(15)) RETURNS INT AS BEGIN DECLARE @RETVAL INT IF NOT EXISTS (SELECT * FROM...
  3. Sandeep Mittal

    Where Clause Help

    Post by: Sandeep Mittal, Jan 3, 2013 in forum: ALL SQL SERVER QUESTIONS
    SELECT InsuranceID , Round(Sum((CASE WHEN Month(BatchDateTime) = 7 THEN Amount ELSE 0 END)*-1),0) AS July , Round(Sum((CASE WHEN...
  4. Sandeep Mittal

    Getting a list of days of a given month

    Post by: Sandeep Mittal, Dec 17, 2012 in forum: SQL Server 2005 General Developer Questions
    Refer this link http://itdeveloperzone.blogspot.in/2012/11/generate-list-of-dates-in-sql-server.html
Showing results 1 to 4 of 4
Search Again