Search results for query: *

I excuted SP but return value zero. I think the table using in SP is deleting and writing by parameter by another SP. How to get return value while other SP is deleting and writing same sql table by job number? Private Function getSavedJobs() Dim cmdSavedJobs As New SqlCommand...

If [History count} is zero, [Final Count} should have [All count]. But [Final Count] value returns as zero. How to move [History count] into [Final Count]? This is part of SELECT within Store Procedure. ISNULL(cast (([ALL count]-[History count]) as integer(18)),0) AS [Final Count]

I am a beginner and need help. I am getting error message System.Data.SqlClient.SqlException: Error converting data type nvarchar to numeric. at System.Data.SqlClient.SqlCommand.ExecuteReader (Commandbehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) I tried...

FORM1 need to get result from FORM2 and keep run next step in FORM1. So I used .showdialog() instead of .show(). The problem is I get result from FORM2 but looks like FORM2 still running. FORM2 looks like hide. How to end FORM2 after .showdialog()? I am a beginner. I read article about...

Form1 need to get result from Form2 and keep run next step in Form1. So I used .showdialog() instead of .show(). The problem is I get result from Form2 but looks like Form2 didn't closed. How to close Form2 after .showdialog() from FORM1; If dtJobDetailsMileRadius.Rows.Count > 0 Then...

Error 213: Insert Error: Column name or number of supplies values does not match table definition. Insert Error: Column name or number of supplies values does not match table definition. I am getting Error 213 after add ClassKey Varcgar(20)in table @LicenseID_ProfCode. Please help me...

I want to run DTS manually. I clicked Schedule Package and changed end date to TODAYs date on Edit Recurring JOb Schedule but It donsn't let me change it. How to disable auto daily run.

I am new c# and Web App and try to understand it. I would like to know how the following line work and also attached full public void too. I cannot figure out how where GetProgramM get executed. I use Visual Studio 2008 & c#. DataTable _datatable = _dataaccess.GetProgramM(_iPMID); public...

I am try to update seleted check box but it takes so long to save into table. There are only 5,000 records in table. Is there way to make this faster? Here is code; Sub SaveCurrentCheckBox() Static blnSelect As Boolean Set db = CurrentDb() Set myrs = Me.RecordsetClone...

I want to select record which FaceLetter = false only from table. FaceLetter is Yes/No field. When I run execute code I get all record from input table. Here is code; Private Sub CreateTaxCertification_Click() Dim db As Database Dim rs As Recordset ''' record write ''' Dim rs2009...

How to compre 2 decimal only? AmountPD have 2 decimal (ex) 125.54 Discount have 4 decimal (ex) 125.5364 I want to compare AmountPD(125.54) = Discount (125.54). Here is code; If .Fields("AmountPD").Value <> .Fields("Discount").Value Then .Fields("FaceLetter").Value = False...

I want to save the report with date and time to eliminate replace existed report. I am getting a message "The report snapshot was not created because you don't have enough free space for temporary work files." Here is code; Dim stDocName As String Dim stFileName As String Dim...

I have a Access report which is created with recordsoure of parameter query. I want to print this report from FORM and pass paremeter from FORM text box value. How can I print report without POPUP parameter from the FORM. I have to keep parameter query recordsorce on the report. I also try...

Please advise me for this error. This is SQL statement: Create table #LicDel (id bigint identity,liccd numeric (18),profcd nvarchar(8))

I would like to add as new line with HEX(0C)(2F) before Barcode. Could you help the coding? input = 07017-221360 output = /07017-221360 - want to add HEX(0C) (2F) - this should be recognize as new starting line.

I am a beginer SQL. Please advise me. I would to know how to change to create one record by field name(LICENSE_ID). There are multi records with field name [Prof Code] by field name [ICENSE_ID]. -- generate Mailing list with multi job numbers as master job number -- CREATE PROC...

How to modify within full cmd.commandtext. I need to able to pass this full cmd.commandtext to SQL. This error occurs while SQL text thru vb.net because ProsRNCount is zero. This is the part of cmd.commandtext. "ISNULL(cast((RespRNCount/" & _LowestSelectedCityCounter & " ) / ProsRNCount *100...

This error occurs while SQL text thru vb.net because ProsRNCount is zero. This is the part of cmd.commandtext. ISNULL(cast((RespRNCount/" & _LowestSelectedCityCounter & " ) / ProsRNCount *100 as numeric(9,3)),0) as [RNPercResponse] This is full cmd.commandtext from vb.net Cmd.CommandText =...

I am getting error: 137 Must declare the variable '@RNCodes'. Please advide me. CREATE PROCEDURE [dbo].[INRV2_Insert_gdtResultDT_RN_bkup_20090915_TEST] ( @RNCodeXMLString ntext, @XMLString ntext, @JobNo char(5), @UiD UNIQUEIDENTIFIER ) AS SET NOCOUNT ON DECLARE...