Case in SQL

-

CASE ebv.db_no WHEN 22978 THEN 'WECS 9500' WHEN 23218 THEN 'WECS 9500' WHEN 23219 THEN 'WECS 9500' ELSE 'WECS 9520' END

Comments

Post a Comment

Popular posts from this blog

Uploading Image to Sql Server Image Datatype in asp.net using fileupload Control

-
Uploading Image to Sql Server Image Datatype in asp.net using fileupload Control  Byte[] imgbyte = null;  if (FileUpload1.HasFile)             {                 string fileName = Path.GetFileName(FileUpload1.PostedFile.FileName);                 FileUpload1.PostedFile.SaveAs(Server.MapPath("~/UserPhoto/") + DateTime.Now.ToString("_MMddyyyy_HHmmss") + fileName);                 photo = "UserPhoto/" + DateTime.Now.ToString("_MMddyyyy_HHmmss") + fileName;                 string fpathPhoto = Server.MapPath(photo);                 FileInfo fInfo = new FileInfo(fpathPhoto);                 long numBytes = fInfo.Length;                 //Open FileStream to read...
Read more

Get Running Sum of Query SQL Query

-
 select RequestNo,FileName,PaymentStatus,count(0) as TxnCount,SUM(PaidAmount) as Amount ,SUM(SUM(PaidAmount)) over(Order by RequestNo) as RunningSum from Tbl_T_CommunityPaymentOnline where  IsDeleted is null and RequestNo>=131 and PaymentStatus='Inprocess' group by RequestNo,PaymentStatus,FileName
Read more
-
Image
G H RAISONI INSTITUTE OF BUSINESS MANAGEMENT HAS ORGANISED PINNACLE 2014. THAT INVOLVES PROGRAMS LIKE POSTER PRESENTATION, IT QUIZ , C & C++ PROGRAMMING CONTEST & COMPUTER GAMING COMPITITION.DATE WILL BE ANNOUNCED SOON.
Read more