Interested to Buy Any Domain ? << Click Here >> for more details...
when will entrance exam of axis bank western zone will be held?????can anyone tell me what type of questions were asked in the examination?????how was the level of written????
2563Post New WIU General Aptitude Interview Questions
-
WIU General Aptitude Interview Questions (1)
how to select first 5 records from a table? : Sql dba
Explain package.json file in angular?
Can sharepoint be linked to an external data source?
Define tracert?
What is array initialization in java?
what are the data modeling tools you have used?(polaris)
What is javac used for?
What are the symptoms of broke piston ring?
we have 2.2kw,Y,3000rpm motor but 6leads found in TB what happen if we connect in delta?
Which is the fastest implementation of python?
In real world when do you recommend aggregate?
Explain pre-order and in-order tree traversal.
what is some typical usage of middlewares in django?
From the following information you are to prepare a Cash Budget for the period from July to December 2008. (i) The estimated sales and expenses are as follows: June July Aug. Sep. Oct. Nov. Dec. Sales 35,000 40,000 40,000 50,000 50,000 60,000 65,000 Purchases 14,000 16,000 17,000 20,000 20,000 25,000 28,000 Wages & Salaries 12,000 14,000 14,000 18,000 18,000 20,000 22,000 Expenses 5,000 6,000 6,000 6,000 7,000 7,000 7,000 Interest Received 2,000 - - 2,000 - - 2,000 Sale of Fixed Assets - - 20,000 - - - - (ii) Sales are 20% in cash and balance on credit. 50% of the debtors are collected in the month of sales and the remaining in the next month. (iii) The time lag in payment of purchases and expenses is 1 month. However, wages and salaries are paid fortnightly with a time lag of 15 days. (iv) The company maintains a minimum cash balance of Rs. 5,000. The cash balance in excess of Rs. 7,000 is invested in government securities in multiples of Rs. 1,000. Short falls in cash balance are made good by borrowing from banks. The interest received as well as paid is to be ignored.
Please can the SQL code below be interpreted IF @xMatchCriteria='MATCH12' BEGIN IF EXISTS (Select * from #InsightData where (EmailAddress=@xDCPEmailAddress ) ) BEGIN SET @xTestMatchCriteria = @xMatchCriteria; SELECT @xCRMCustomerId=CustomerId, @xCRMDcpCustomerId=DcpCustomerId, @xCRMPortalCustomerID=PortalCustomerID,@xCRMDcpID=DcpID, @xCRMCardNumber=CardNumber, @xCRMEmailAddress=EmailAddress, @xCRMfirtLetterFirstName=firtLetterFirstName, @xCRMLastName=Surname,@xCRMAddressLine1=AddressLine1, @xCRMPostCode=PostCode FROM #InsightData where (EmailAddress=@xDCPEmailAddress ) END ELSE BEGIN SET @xTestMatchCriteria='No'+@xMatchCriteria; END END
