Click here to Skip to main content
The default search term operator is AND.

You can use brackets, AND, OR, and NOT to improve your search. For example: C# AND NOT(VB or SQL)

A query of a single * will return everything, filtered by any filters.

Filter examples:
Search by Author  author:"author name"
Filter by tag  tag:C# or tag:(C++ or Java)
Wildcard search  use "?" or "*" eg. gr?d or gr*
  
216 Results

Search



Sort by



Match


Rating Range

Advanced Filters:


Page 1 of 22
Page Size: 10 · 25 · 50

Author filtered by: gvprabu [x]
Forum Message 13 May 2013  
Hi, Check the Script SELECT M.ID,(ROW_NUMBER() OVER(PARTITION BY M.EmpID ORDER BY M.EmpID)) 'RowNumber', M.EmpID, M.Leave_Year, M.Taken, M.Credit, (SELECT SUM((ISNULL(Balance,0
Answer 13 May 2013   license: CPOL
Hi,Try this...SELECT distinct r.rate as Rate,f.bthid as Batchid,CASE WHEN r.rate = '1' THEN '100' WHEN r.rate = '2' THEN '75' WHEN r.rate = '3' THEN '50' WHEN r.rate = '4' THEN '25' ELSE '0' END AS Translated_Rate FROM bthfac fINNER JOIN faculty fa ON...
SQL-Server
Answer 13 May 2013   license: CPOL
Hi,Check the following CodeSELECT GETDATE()GO-- SQL Server 2000/2005SELECT CONVERT(VARCHAR(8),GETDATE(),108) AS HourMinuteSecond,CONVERT(VARCHAR(10),GETDATE(),101) AS DateOnly;GO-- SQL Server 2008 OnwardsSELECT CONVERT(TIME,GETDATE()) AS HourMinuteSeconds;SELECT...
ASP.NETSQL-ServerDateTime
Answer 10 May 2013   license: CPOL
Hi,Check the following Script...SELECT COALESCE(From_Place,SUBSTRING(Area,1,CHARINDEX(' TO ', Area, 1))) 'From_Place',COALESCE(To_Place,SUBSTRING(Area,CHARINDEX(' TO ', Area, 1)+4,LEN(Area))) 'To_Place',NULL AreaFROM SOURCE Regards,GVPrabu
SQL-Server
Answer 9 May 2013   license: CPOL
Hi,You can use COALSEC[^] and BETWEEN[^] logic for this. Try like this....create procedure [dbo].[SP_RPTGetMRFsForResMgr] ( @MRFM_FrDt varchar(10), @MRFM_ToDt varchar(10))asbegin select ..... from...
SQL-ServerSQL2008
Answer 9 May 2013   license: CPOL
Hi ,Check the following linksNULL, NULL, NULL and nothing but NULL[^]Difference between NULL and Empty/Blank value[^]Null vs Empty (Zero Length) string[^]SQL: empty string vs NULL value[^]Regards,GVPrabu
SQL-Server
Answer 9 May 2013   license: CPOL
Hi,Check the following Query... use OR Operator for this simple checking.Declare @RRPTDemandStatus char(7) = nullselect mpd.MPD_DemandStatus, m.Description,* from RPT_MRFProgressDetails mpdleft outer join MasterData M on mpd.MPD_DemandStatus = M.Idwhere ((mpd.MPD_DemandStatus =...
SQL2005SQL-Server
Answer 8 May 2013   license: CPOL
Hi,Check the following links....Comparison Operators (Transact-SQL)[^]Use NOT operator in where clause[^]Null Values And The T-SQL IN Operator[^]SQL Server All, Some and Any Operators[^]Regards,GVPrabu
SQL-Server
Answer 8 May 2013   license: CPOL
Hi,Check the following links.. u will get Idea.Export in Excel With using OPENROWSET from Stored Procedure[^]Using T-SQL, export resultset to Excel [^]Exporting A Csv File Via A Stored Procedure[^]Once try, If any difficulties then get back to us...Regards,GVPrabu
SQLServer
My vote of 5 by gvprabu
Forum Message 8 May 2013  
Nice examples and fully informative. thanks a lot for your article.
Page 1 of 22
1 2 3 4 5 6 7 8 9 10
First · Prev · Next · Last


Advertise | Privacy | Mobile
Web04 | 2.6.130513.1 | Last Updated 14 May 2013
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid