Monthly Archives: December 2012

//Thank you >>>  Credit from this site http://sarangasl.blogspot.com/search/label/C%20Sharp http://sarangasl.blogspot.com/2010/10/install-iis-in-windows-7-or-vista.html   // Service1.asmx using  System; using  System.Collections.Generic; using  System.Linq; using  System.Web; using  System.Web.Services; namespace   myFirstWebService { ///<summary> /// Summary description for Service1 ///</summary> [WebService(Namespace = “http://tempuri.org/&#8221;)] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]  [System.ComponentModel. ToolboxItem(false)] // To … Continue reading →

ALTER FUNCTION [dbo].[GetStarFromMatrixTbl]( — Add the parameters for the function here @TransactionType VARCHAR(5), @InstrumentType varchar(5))RETURNS VARCHAR(1)ASBEGIN — Declare the return variable here DECLARE @Star varchar(1) — Add the T-SQL statements to compute the return value here DECLARE @MatrixTable TABLE ( … Continue reading →

To query data by using  condition from  dropdownlist or combobox and there is a keyword of seaching.   First I am thinking to write it as CTE but  it is failed and I found out that “A CTE must be … Continue reading →

— ============================================= BEGIN — SET NOCOUNT ON added to prevent extra result sets from — interfering with SELECT statements. SET NOCOUNT ON; ;WITH ISKAccounts AS ( SELECT a.AccountNumber AS AccountNumber,cs.OwnerTypeId AS OwnerTypeId, cs.Country AS Country, a.AccountType AS AccountType, re.AccountRole AS … Continue reading →