isozworld

I'm implement if else in stored procedure with and oprator . If both Conditions are true the if statement should return 1 else -1. here username and email should not be duplicate please review query below. alter proc spUserdetailss @name Nvarchar(50), @passwords Nvarchar(100), @emailadd Nvarchar(50), @Gender nvarchar(50) as begin declare …

This function I have created to return all recorded Stock numbers in the Table "ContributorDeeds" the table contains only the start number of the stocks and the end number of the stocks (e.g, from number - to number) I need to get all the numbers between within that range. The …

hello friends I have two tables with column A and column B. I want to update column B of table2 with column B of table1 . I have trying this query in ms access from Vb.net. update table1 t1 LEFT JOIN table2 t2 on t1.a = t2.a SET t2.b = …

Hi, I have to correct some data in SQL Server 2008 R2 database for an accounting system that was accidently over written. Basically I've to take stock items with fixed prices and compare those fixed prices against Sales Order Transactions for the stock item and correct entries where the transaction …

I have written a SQL query to find product information in a c# program and it doesn't seem to work at all! I have tested a variety of other queries with my C# code and it works fine, but this throws an exception every time. SELECT TOP (1) CONVERT(varchar, tmpRptAssetEvent.EventTimeStamp, …

Hi I have an issue in below stored procedure. below Store procedure is working fine. But fixed the Year. Any one know How can do the year dynamically select by user? SELECT * FROM ( SELECT salesEXE,SalesEXEName,name,gross,YearNo FROM vw_Pivot_Month_ALL) TableYearNo pivot (Sum(gross) for [yearno] in ([2008],[2009],[2010],[2011],[2012],[2013],[2014],[2015],[2016],[2017],[2018],[2019],[2020]) )pivotTable pls advice Maideen

Greetings, I'm facing a problem with the SQL Server and this problem concerning numbers when compared each other and these numbers are stored in the columns of data type NVARCHAR or VARCHAR. For example, if I'm having a column with data type NVARCHAR and it contains such values: 1 2 …

Hi guys please am new to c# sharp am having trouble to insert Events into the databse for an application am building I keep haveing the this error"The connection was not closed. The connection's current state is open." please any advice on what to thanks in advance guys. here is …

 Hello again, I am now encountering the above problem. i dunno what to do and tried everything. my Column for Capital is decimal so i dunno why it is saying varchar. my codes are con.ConnectionString = //insert data source; if (con.State != ConnectionState.Closed) { con.Close(); } cmd.Connection = …

I have the following code: if (filtro.FinalDate != null) { FinalDate = String.Format(" Data <= '{0}' ", filtro.FinalDate.GetValueOrDefault().ToString("yyyy-MM-dd") + " 23:59:59"); } But when I compile and type something in the FinalDate, the following message appears in the log: Could not convert string to DateTime: 18/11/2014. Path 'FinalDate', line 1, …

Hello I am Ariflaw. I'm a front-end development. I am newbie, hope I can learn from each other.

hi All, I m new to c#.I m using a HTML table in web browser control and wants to get the rowid of the clicked row in HTML table.bt dont have any idea how to get. IS there any method for getting the row id of the clicked cell. Please …