SSRS2000 - Specifies Cast Not Valid

May 2, 2007

Hi,



I get the above error everytime I try to export to Excel; exporting to PDF works fine.



The only way I can get rid of the error is by deleting all the data from within the report (not ideal!). Anyone got any ideas on what could be causing this?



Many thanks,



Mani

View 1 Replies


ADVERTISEMENT

Reporting Services :: Value Expression For Text Box Specifies A Scope That Is Not Valid For Nested Aggregate

Apr 22, 2015

I'm trying to sum a column in a report. in Most columns I can just wrap the row level expression with "Sum()" and it works. However, I have run into a few that give the following error. The Value expression for the text box ‘Textbox241’ specifies a scope that is not valid for a nested aggregate.  The scope must be the same name of the scope specified by the outer aggregate or the name of a group or data region that is contained in the scope specified by the outer aggregate.Here is my row level expression that works.

=Code.Divide(sum(Fields!WeeklyUnits.Value),sum(Fields!EstUnits.Value))
*
(Code.Divide(sum(Fields!EstHours.Value),sum(Fields!EstHours.Value,"Job")))

Here is my attempt to Sum the row level for the footer area.

=Sum(Code.Divide(sum(Fields!WeeklyUnits.Value),sum(Fields!EstUnits.Value))
*
(Code.Divide(sum(Fields!EstHours.Value),sum(Fields!EstHours.Value,"Job"))))

View 9 Replies View Related

Specified Cast Is Not Valid

Sep 11, 2006

im doing a sum on a table and it either returns a number in decimal format or 'null' .  The problem is when it returns null i want it to just make the text say '0.00'.  So i did a test on the object that if it returns NULL just print  '0.00' but if it is not null it tells me that there is a number there and i want to store that as a decimal and print it out.  But i get an error for a type cast when im not it should not even be going to that part of the code. In the code below the first executescaler will return null so it should just go straight to the else.  But it gives me the type cast error in the if that shouldnt be seen.  The error and code are below. //Borrower NSF FEES
cmd.CommandText = "select sum(itemamount) from postmtdtls where loanid='" + LoanID + "' and Transactioncode = '310'";
object temp = cmd.ExecuteScalar();
if (temp != null)
{
decimal B_NSFFees = ((decimal)cmd.ExecuteScalar());
borrowerPayoff_NSFFees.Text = String.Format("{0:#,#.##}", B_NSFFees).ToString(); //Borrower NSF FEES
}
else
{
borrowerPayoff_NSFFees.Text = "0.00"; //borrowerPayoff_NSFFees.Text = "0.00";
}  Server Error in '/WebSite5' Application. Specified cast is not valid. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.InvalidCastException: Specified cast is not valid.Source Error: Line 774: if (temp != null)
Line 775: {
Line 776: decimal B_NSFFees = ((decimal)cmd.ExecuteScalar());
Line 777: borrowerPayoff_NSFFees.Text = String.Format("{0:#,#.##}", B_NSFFees).ToString(); //Borrower NSF FEES
Line 778: }Source File: c:ProgrammingFilesWebSite5InvestorPool.aspx.cs    Line: 776 Stack Trace: [InvalidCastException: Specified cast is not valid.]
InvestorPool.GetLoanInfo(String LoanID) in c:ProgrammingFilesWebSite5InvestorPool.aspx.cs:776
InvestorPool.MortAccountText(Object sender, EventArgs e) in c:ProgrammingFilesWebSite5InvestorPool.aspx.cs:660
System.Web.UI.WebControls.TextBox.OnTextChanged(EventArgs e) +75
System.Web.UI.WebControls.TextBox.RaisePostDataChangedEvent() +124
System.Web.UI.WebControls.TextBox.System.Web.UI.IPostBackDataHandler.RaisePostDataChangedEvent() +7
System.Web.UI.Page.RaiseChangedEvents() +138
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4507
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

View 10 Replies View Related

Specified Cast Is Not Valid

Apr 7, 2006

Can't seem to find why I'm getting this error: Specified cast is not valid.
Ok, using a stored procedure for SQL Server 2000 and here is the main part of it:
 SELECT id, rank, firstName, lastName, service, status, createdTime FROM   accessRequest WHERE  lastName LIKE @tLastName     AND    firstName LIKE @tFirstName
And the C# code behind from the class file:
SqlDataReader spResults;
conn.Open();
spResults = command.ExecuteReader();
while( spResults.Read() )
{
AccessRequestSearch request = new AccessRequestSearch( (int)spResults.GetInt32( 0 ), spResults.GetString( 2 ), spResults.GetString( 3 ), spResults.GetString( 1 ), spResults.GetString( 4 ), spResults.GetString( 5 ), Convert.ToDateTime(spResults.GetString( 6 )));
searchResults.Add( request ); // Add to Array List
}
spResults.Close();
The part in red is where I think it's happening because that is what I just added to the request.  createdTime in the table is set as DateTime.
Can anyone see what I am missing here?
More info is available if needed.
Thanks,
Zath

View 1 Replies View Related

Error: Specified Cast Is Not Valid.

Jul 11, 2006

 
 
  sqlConnection1.Open();
System.Data.SqlClient.SqlDataReader Dil1;
Dil1 = sqlDilGetir.ExecuteReader();
ddlDil1.Items.Add(new ListItem("1. Dil", ""));
while (Dil1.Read())
{
ddlDil1.Items.Add(new ListItem(Dil1.GetString(1), Dil1.GetString(0)));
}
Dil1.Close();
sqlConnection1.Close(); 

View 7 Replies View Related

DB Engine :: Error Specified Cast Is Not Valid

May 25, 2015

I have a backup of DB with version Microsoft sql 2012 and i need restore this data base on instance Microsoft sql 2008 R2
when i try restore database on SQL server 2008 R2  i have the error:

Specified cast is not valid.
(SqlManagerUI)

View 6 Replies View Related

DB Backup Is Not Being Restored To Another DB - Specified Cast Is Not Valid

May 12, 2015

I have been experiencing "Specified cast is not valid" error while restoring backup of DB. Version of SQL server management tool from which I am taking the backup is "Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (Intel X86) Jun 17 2011 00:57:23 Copyright (c) Microsoft Corporation Express Edition with Advanced Services on Windows NT 6.1 (Build 7601: Service Pack 1) (WOW64) (Hypervisor) ". And restoring to the same version tool.

I have tried all the workarounds like TSQL, Upgrade the version of restoring DB to higher version, MDF and LDF files generation. But they are not working.

View 12 Replies View Related

Cannot Show The Editor For This Task. Specified Cast Is Not Valid

Jul 26, 2006

This error is pretty persistent. I re-installed VS 2005 and SQL Server 2005 but did not help. Every time I try to open a Script Task editor it gives me the same error regardless of the project or package. DO I NEED TO REBUILD MY SYSTEM ?

===================================

Cannot show the editor for this task. (Microsoft Visual Studio)

===================================

Specified cast is not valid. (Microsoft.VisualBasic.Vsa.DT)

------------------------------
Program Location:

   at Microsoft.VisualBasic.Vsa.Dt.VsaIDE.get_ExtensibilityObject()
   at Microsoft.SqlServer.VSAHosting.DesignTime.get_ExtensibilityObject()
   at Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTaskUI.Dispose()
   at Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTaskMainWnd.Dispose(Boolean disposing)
   at System.ComponentModel.Component.Dispose()
   at Microsoft.DataTransformationServices.Design.DtrPackageDesigner.DoDefaultActionForTask(TaskHost task)

 

-------

Any help is appreciated.

Gulden

 

.......

View 9 Replies View Related

Specified Cast Is Not Valid Error In Datagrid/update Script

Oct 5, 2006

I have a datagrid script where I modify data in an sql dbase in asp.net, when i hit the "update" button, I get a Specified cast is not valid error on my 'descript' declaration, whereas 'descript' is a multiline text box and a varchar datatype (everything else is either a char or a datetime datatype). Am I assigning 'descript' a wrong datatype? Tried making it a nvarchar, still get same result'''''''''''''''''''''''''''''''Sub MyDataGrid_UpdateCommand(s As Object, e As DataGridCommandEventArgs ) Dim conn As SQLConnection Dim MyCommand As SQLCommand Dim strConn as string = "Server=sql.mydomain.com;Initial Catalog=mydb;User ID=DBxxx;Password=xxxxx;" Dim company As textbox = E.Item.cells(2).Controls(0) Dim address As textbox = E.Item.cells(3).Controls(0) Dim city As textbox = E.Item.Cells(4).Controls(0)  Dim state As textbox = E.Item.cells(5).Controls(0) Dim county As textbox = E.Item.cells(6).Controls(0) Dim zip As textbox = E.Item.cells(7).Controls(0) Dim phone As textbox = E.Item.cells(8).Controls(0)'''''' the following line declaring the descript var is the line of the error Dim descript As textbox = E.Item.cells(9).Controls(0) Dim web As textbox = E.Item.cells(10).Controls(0) Dim email As textbox = E.Item.cells(11).Controls(0) Dim datesold As textbox = E.Item.cells(12).Controls(0) Dim dateexpire As textbox = E.Item.cells(13).Controls(0)  Dim strUpdateStmt As String        strUpdateStmt =" UPDATE CPAs SET" & _        " company = @company, address = @address, city = @city, state = @state, " & _        "county = @county, zip = @zip, phone = @phone, descript =@ descript, " & _  "web = @web, email = @email, datesold = @datesold, dateexpire = @dateexpire" & _  " WHERE cpaID = @cpaID" conn = New SqlConnection(strConn) MyCommand = New SqlCommand(strUpdateStmt, conn) MyCommand.Parameters.Add(New SqlParameter("@company", company.text)) MyCommand.Parameters.Add(New SqlParameter("@address", address.text)) MyCommand.Parameters.Add(New SqlParameter("@city", city.text)) MyCommand.Parameters.Add(New SqlParameter("@state", state.text)) MyCommand.Parameters.Add(New SqlParameter("@county", county.text)) MyCommand.Parameters.Add(New SqlParameter("@zip", zip.text)) MyCommand.Parameters.Add(New SqlParameter("@phone", phone.text)) MyCommand.Parameters.Add(New SqlParameter("@descript", descript.text)) MyCommand.Parameters.Add(New SqlParameter("@web", web.text)) MyCommand.Parameters.Add(New SqlParameter("@email", email.text)) MyCommand.Parameters.Add(New SqlParameter("@datesold", datesold.text)) '', dateexpire =@dateexpire MyCommand.Parameters.Add(New SqlParameter("@dateexpire", dateexpire.text))  MyCommand.Parameters.Add(New SqlParameter("@cpaID", e.Item.Cells(1).Text )) conn.Open() MyCommand.ExecuteNonQuery() MyDataGrid.EditItemIndex = -1        conn.close BindDataEnd Sub'''''''''''''''''''''''''''''netsports

View 1 Replies View Related

Cast From String 'OPEN' To Type 'Double' Is Not Valid.

Aug 12, 2007

Hi.. Please help me resolve this error "Cast from string 'OPEN' to type 'Double' is not valid.". Error here If CallStatus = 10 Then ....Code:Public Sub UpdateCallStatus()        Dim CALLID, RequestorID, CommentsFromITD, MessageFromITD, MessageToITD, CallStatus, strSQL As String        CALLID = Request.QueryString("CallID")        RequestorID = Session("USER_ID")        CommentsFromITD = lblcomments.Text        MessageFromITD = lblmessage.Text        MessageToITD = txt_desc.Text        CallStatus = Trim(Request.Form(ddl_callstatus.UniqueID))
        Dim ObjCmd As SqlCommand        Dim ObjDR As SqlDataReader
        Try            If CallStatus = 10 Then                strSQL = "UPDATE CALLS  SET STATUS_ID=" & CallStatus & " WHERE CALL_ID=  " & CALLID & ""                ObjCmd = New SqlCommand(strSQL, ObjConn)                ObjConn.Open()                ObjDR = ObjCmd.ExecuteScalar()                gbVariables.insertuserevents(CALLID, RequestorID, "Call Closed")                Response.Redirect("UserCallClosed.aspx")                ObjConn.Close()            Else                strSQL = "UPDATE CALLS  SET STATUS_ID=" & CallStatus & " WHERE CALL_ID=  " & CALLID & ""                ObjCmd = New SqlCommand(strSQL, ObjConn)                ObjConn.Open()                ObjDR = ObjCmd.ExecuteScalar()                ObjConn.Close()
                strSQL = "SELECT STATUS_LABEL  FROM STATUS WHERE STATUS_ID = " & CallStatus & ""                ObjCmd = New SqlCommand(strSQL, ObjConn)                ObjConn.Open()                ObjDR = ObjCmd.ExecuteScalar()                ObjConn.Close()
                gbVariables.insertuserevents(CALLID, RequestorID, CallStatus)                CallStatus = ""            End If        Catch ex As Exception            lblmsg.Text = ex.Message.ToString        End Try    End SubThanks...

View 1 Replies View Related

Cast From String &"&" To Type 'Date' Is Not Valid

Mar 12, 2006

Hello, I am using an SQLDataReader called DrCoInfo to check if any matching records exist in a table.

My code is as such:

Line 119:DrCoInfo = comm1.ExecuteReader()
Line 120:While DrCoInfo.Read()
Line 121: If DrCoInfo("DateOfMan") <> "" Then
Line 122: BValid = True
Line 123: End If

However, it fails to work with the message :System.InvalidCastException: Cast from string "" to type 'Date' is not valid.

Any suggestions? Thanks.

View 4 Replies View Related

SSRS2000 To 2005 RSExecRole

Apr 9, 2008

We are upgrading SQL2000 to 2005 database at new server.
I used to backup and restored method to transfer all databases etc. (Side by Side method)

In the same manner I did for SSRS, but when I try to upgrade the database from 2000 to 2005 through RSCM. I am getting following error.

Cannot find the user 'RSExecRole', because it does not exist or you do not have permission

Both Master, and Report Server got RSExecRole.

I am not sure what I am missing here. Can any anyone help me?


hey

View 7 Replies View Related

Manual Uninstall Of SSRS2000?

Jan 16, 2007

I'm trying to install SQL2005 Express Edition, the adv. version that includes SSRS. The installation fails because it cannot upgrade the existing SSRS2000. I tried to uninstall the latter from the Add/Rem. Programs, and I get "Fatal Error during installation".  IIS was stopped prior to the uninstall attempt.

SSRS2000 will thus not uninstall. How can I do a manual uninstall of it? I need to retain my SQL2000 instance, so the manual uninstall of SSRS must not injure it.

View 4 Replies View Related

DDL Is Not Valid

Jul 24, 2006

hello,everybody ,i use the AnalysisServicesExecuteDDLTask ,but it dap an error "DDL is not valid",i don't konw what is the problem and how to solve?thank you!

View 1 Replies View Related

Instance Specified Not Valid

Feb 27, 2004

Hi,

I'm trying to install MSDE SP3 which I downloaded from MS at http://www.asp.net/msde/.
Following the instructions as best I can I unzipped the file into a Folder now called MSDE located on C: I then went to a command prompt and typed in the command given to start the install:

setup SAPWD=testsite SecurityMode=SQL

Hit enter and the installer started up and ran for a few secs and then came back with

The Instance named specified is invalid

There was no mention of including an instance name or the format for it.

Suggestions please?

Also, if I want to completly uninstall MSDE if I need to how would I do it?

Thanks,
Bob

View 1 Replies View Related

Valid User

Jun 17, 1999

Hello:
I am getting an error:
User id 12 is not a valid user in database Dest_db
While using Database object transfer.

Using mixed security on the source database.
copy data and replace existing data options are selected.

View 1 Replies View Related

Trigger ... Is This Valid?

Nov 24, 2004

Is the following valid syntax? Thanks for your help!

IF (SELECT chargeID FROM inserted = 0) BEGIN

END

OR, should I be doing something like this:

DECLARE @thisChargeID as int
SET @thisChargeID = (SELECT chargeID FROM inserted)
IF (@thisChargeID = 0) BEGIN

END

View 14 Replies View Related

Valid Backup To Use

Jan 11, 2006

I have a question regarding the backup to use in case of consistency errors.

I'm backing up my dbs daily and logs hourly with 'verify the integrity of the backup when completed' checked. Today I found out one of my tables has 1 page id error (dbcc checkdb message from yesterday), I'm wondering if I can use yesterday's full backup even if it's done after the dbcc, that way I don't have to apply a lot less log backups. In other words, does or does not the full backup inherit the corruption if it is done after consistency errors and the backup passes the integrity verification.

Thanks,
Markham

View 11 Replies View Related

Valid T-SQL Syntax?

Jul 20, 2005

Version 1:--------------------------------If Condition = AUPDATE query 1UPDATE query 2ELSE IF Condition = BUPDATE queryVersion 2:--------------------------------If Condition = ABEGINUPDATE query 1UPDATE query 2ENDELSE IF Condition = BBEGINUPDATE queryENDOr are they functionally equivalent?Thanks

View 2 Replies View Related

Certificate Not Yet Valid

Dec 22, 2006

Hi guys,



I'm having this really strange issue with mirroring.

I've followed the instructions on http://msdn2.microsoft.com/en-us/library/ms191140.aspx to the letter, leaving out the witness server part, as I don't have one.



All works OK, but when activating the mirroring on the principal server I get the usual error 1418 error. I fired up SQL Server Profiler to see what was happening, and the following error emerged.

Connection handshake failed. The certificate used by the peer is invalid due to the following reason: Certificate not yet valid. State 104.



Anyone have any ideas?

View 3 Replies View Related

Character Is Not Valid

May 4, 2007

Hi,



I do not know what I did wrong. I tested a simple function in my custom code and get the error saying "Character is not valid". Any help is appreciated!



Here is the function inside my custom code.



Shared Function test() As string

Dim items As Fields
Return items("DataField1").Value;

End Function




I call the function in the body of my report using: Code.test()



and the error says "There is an error on line 18 of custom code: [BC30037] Character is not valid."





Thanks,

Tabbey



View 6 Replies View Related

The Index Is Not Valid.

Dec 1, 2006

I get this error in a package which was executing previously. This is in SQLServer OLEDB DATASOURCE 
Error at Membership_Other_Payer [DTS.Pipeline]: The index is not valid.
 
ADDITIONAL INFORMATION:
Exception from HRESULT: 0xC0048004 (Microsoft.SqlServer.DTSPipelineWrap)
 This error occurs when I try to open my existing Oledb datasource.  I have added some columns in my database
Any body has solution for this?

View 18 Replies View Related

CAST

Jan 16, 2007

Hi
Can anyone tell me how I can CAST these fields AS DECIMAL (19, 2) please?

(SELECT ([Total students] - [withdrawn] - [transferred] - [cancelled]) / [total Students] * 100 AS [Percentage Retained])

Thanks
Daniel

View 6 Replies View Related

CAST

Dec 14, 2007

I have

CASE
WHEN (a.type_id in (9))
THEN a.duration
ELSE 0 --CAST ( expression AS data_type )
END 'Time'


I need the duration to be displayed if type is 9 only.
so otherwise id ideally want 'N/A' displayed..
but it won't display it as its not an int ..

is there a way i can just display it temporarily
instaed of 0 ?

View 5 Replies View Related

Need Help With A CAST

Feb 5, 2008

I am having a little trouble with the CAST in my SELECT statement below. Any help is greatly appreciated.



SELECT
group_id_ AS [Group ID],
vendor_id_ AS [Vendor ID] ,
project_id_ [Project ID],
resource_id_ [Resource ID],
vendor_price_ [Old Price],
new_price_ [New Price],
(CAST (new_price_/vendor_price_)-1 AS DECIMAL (4, 2)) AS [Difference]
FROM hbs_vnpq
WHERE (group_id_ = '210') AND (vendor_id_ = '08416') AND (new_price_ >0) AND (vendor_price_ >0)
ORDER BY [Difference]





Server: Msg 1035, Level 15, State 10, Line 7
Incorrect syntax near 'CAST', expected 'AS'.

View 5 Replies View Related

Connection String Not Valid !

Apr 12, 2007

I've build a website with asp.net and on my local machine it run very we. but when I store my website on a server, I have a error : ...error: 25 - Connection String not valid...
This is my connection string on my local machine : "add name="csIyp" connectionString="data source=.SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|iyapason.mdf;User Instance=true" providerName="System.Data.SqlClient" "
And the connection string on my webserver : "add name="csIyp" connectionString="data source= .MSSQLSERVER;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|iyapason.mdf;User Instance=true" providerName="System.Data.SqlClient" "
So, what can I do to solve this probleme.
Thanks !

View 3 Replies View Related

Is This A Valid Table Schema

Aug 11, 2007

GO
CREATE TABLE [dbo].[CmnLanguage]( [Id] [char](2) NOT NULL CONSTRAINT PkCmnLanguage_Id PRIMARY KEY, [UniqueName] [varchar](26) NOT NULL, [NativeName] [nvarchar](26) NOT NULL, [DirectionType] [smallint] NOT NULL, [IsVisible] [bit] NOT NULL, [CreatedDateTime] [datetime] NOT NULL DEFAULT GETDATE(), [ModifiedDateTime] [datetime] NULL)
 GO
CREATE TABLE [dbo].[CmnLink]( [Id] [int] IDENTITY(1,1) NOT NULL CONSTRAINT PkCmnLink_Id PRIMARY KEY, [UniqueName] [varchar](52) NOT NULL, [IsVisible] [bit] NOT NULL, [CreatedDateTime] [datetime] NOT NULL DEFAULT GETDATE(), [ModifiedDateTime] [datetime] NULL)
GO
CREATE TABLE [dbo].[CmnLinkCmnLanguage]( [LinkId] [int] NOT NULL CONSTRAINT FkCmnLinkCmnLanguage_LinkId FOREIGN KEY (LinkId) REFERENCES CmnLink(Id) ON DELETE CASCADE, [LanguageId] [char](2) NOT NULL CONSTRAINT FkCmnLinkCmnLanguage_LanguageId FOREIGN KEY (LanguageId) REFERENCES CmnLanguage(Id) ON UPDATE CASCADE ON DELETE CASCADE, [CreatedDateTime] [datetime] NOT NULL DEFAULT GETDATE(), [ModifiedDateTime] [datetime] NULL)

View 4 Replies View Related

Is This SQL Stored Prodcedure Is Valid

Jan 30, 2004

what i want to achive is the proc sh'd return a master-detail value in one go.
master value should be returned with Out Parameter and detail value as a recordset.

will it return the recordset of detail table as below....

Create Procedure ProductDetail
(
@ProductID int,
@ProductCode varchar(15) OUTPUT,
@ProductName varchar(60) OUTPUT,
@CategoryID int OUTPUT,
@CategoryName varchar(60) OUTPUT,
@Image1 varchar(256) OUTPUT,
@Image2 varchar(256) OUTPUT,
@UnitPrice smallmoney OUTPUT,
@UOMValue numeric(9) OUTPUT,
@UOMName varchar(10) OUTPUT,
@ShippingWeight numeric(9) OUTPUT,
@Directions varchar(1500) OUTPUT,
@Ingrediants varchar(1500) OUTPUT,
@Warnings varchar(1500) OUTPUT,
@ShortDescription varchar(1000) OUTPUT,
@LongDescription varchar(2000) OUTPUT,
@NutritionFacts varchar(1000) OUTPUT,
@SearchKeywords varchar(500) OUTPUT,
@IsTaxable varchar(15) OUTPUT,
@CreatedBy varchar(60) OUTPUT,
@CreatedOn varchar(15) OUTPUT,
@UpdatedBy varchar(60) OUTPUT,
@UpdatedOn varchar(15) OUTPUT,
@Status int OUTPUT
)
AS

SELECT
@ProductCode = ProductCode,
@ProductName = ProductName,
@CategoryID = CategoryID,
@CategoryName = (select CategoryName from mCategory where CategoryID=a.CategoryID),
@Image1 = isnull(Image1,''),
@Image2 = isnull(Image1,''),
@UnitPrice = isnull(UnitPrice,0),
@UOMValue = isnull(UOMValue,0),
@UOMName = isnull(UOMName,''),
@ShippingWeight = isnull(ShippingWeight,0),
@Directions = isnull(Directions,''),
@Ingrediants = isnull(Ingrediants,''),
@Warnings = isnull(Warnings,''),
@ShortDescription = isnull(ShortDesc,''),
@LongDescription = isnull(LongDesc,''),
@NutritionFacts = isnull(NutritionFacts,''),
@SearchKeywords = isnull(SearchKeywords,''),
@IsTaxable = case when isnull(IsTaxable,0)=0 then 'No' else 'Yes' End,
@CreatedBy = isnull((select LName + ',' + FName from mUser where UserID=InsertedBy),''),
@CreatedOn = InsertedOn,
@UpdatedBy = isnull((select LName + ',' + FName from mUser where UserID=UpdatedBy),''),
@UpdatedOn = UpdatedOn,
@Status = Convert(int,isnull(Status,0))
FROM
mProduct a
WHERE
ProductID = @ProductID


SELECT
ID as PricingDetailID,
isnull(PricingFromQnty,0) as PricingFromQnty,
isnull(PricingToQnty,0) as PricingToQnty,
isnull(RangePrice,0) as RangePrice,
Convert(int,isnull(Status,0))as Status
FROM
dProduct
WHERE
ProductID = @CategoryID


GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

Regards,
Bhairav

View 4 Replies View Related

Character Is Not Valid Error

Nov 17, 2005

Here's my code: Dim Cmd as New SQLCommand(sqlString, conn) cmd.CommandType=CommandType.StoredProcedure    Breaks Here  ----->>cmd.parameters.add(New SQLParameter(@OrdAlias, OrdNum)) cmd.parameters.add(New SQLParameter(@AliasSourceCode, 4))The error says:compilation error - - then, on the line that is in red:Compiler Error Message: BC30037: Character is not valid.I have 'OrdNum' declared globally, and OrdNum is assigned right away in the Page_Load event. I've checked the spelling of the SQL parameters (OrdAlias is a varchar, and AliasSourceCode is a tinyInt)After all this - then, this code runsAny ideas why I'm getting this error??

View 1 Replies View Related

Help Pls!! &#39;Not Defined As Valid User&#34;

Dec 16, 1999

all schedulled task on server failed for 18450 Process Exit Code 1. ...t Utility, Version 6.50.240 Copyright (C) Microsoft Corporation, 1995 - 1996 [Microsoft SQL-DMO] Error 18450: [SQL Server] Login failed- User: sqlexec Reason: Not defined as a valid user of a trusted SQL Server connection.
Any information on how to solve it

View 1 Replies View Related

Dollar Sign Is Not A Valid Name ?

Nov 30, 2006

Code:


objrs.Open "Select * from [klcc_f$]", objConn, adOpenStatic



why IM getting dollar sign is not a valid name ?

View 2 Replies View Related

Valid Rule For Begin/End??

Feb 7, 2008

I wonder about whether this rule is valid or invalid for nested BEGIN/END statement...


Code:


BEGIN

BEGIN
--Query #1 (blah)...
END

WHILE EXISTS (SELECT TOP 1 * FROM #tmpTblPurchaseRaw)
BEGIN
BEGIN
--Query #2 (blah)...
END
BEGIN
--Query #3 (blah)...
END
END

END



I have no idea if nested BEGIN/END is allowed or not...

View 1 Replies View Related

Dateime Valid Ranges

Mar 17, 2004

I've got a linked server setup to DB2, and some of the
date fields in the DB contain 1/1/0001 values.

I've got views created in SQL2000 against the DB2 linked server.

When I run a query against a particular table that contains multiple field of datetime type.

I get the below error
Server: Msg 8114, Level 16, State 8, Line 1
Error converting data type DBTYPE_DBTIMESTAMP to datetime.

This only happens when I include in the select the field that contains 1/1/0001 values.

I assume since valid dates ranges in SQL are from
January 1, 1753 through December 31, 9999, this would be
what's causing this.

I tried to covert in the select but that failed as well. The only thing that I've been able to do, is to use a DTS to pull the data from the DB2 to a local SQL2000 table, with that fields type set as varchar. This works.

Using a DTS to pull the data to a local table in production isn't a viable workaround, since this table contains 1.8 million rows.

How is DTS converting this field, when convert fails in the select?

How do I get around this?
Thanks

View 13 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved