Continued CTE Issue
Jan 17, 2008
Please reference http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2699377&SiteID=1 The results sets are below:
RESULT SET #1
Date_IN
Account_Number
Patient_Name
Care_Unit_Key
Care_Unit
Care_Unit_Desc
Date_Time_In
Time_IN
Duration_Hours
Duration_Minutes
20080102
777777
DOE, JANE
1488748
3
SURGERY
NULL
NULL
NULL
NULL
20080102
777777
DOE, JANE
1509344
S4C
11TH ST 4 CENTER
1/2/08 5:38
5:38
3
57
20080102
777777
DOE, JANE
1509426
SREC
11TH ST RECOVERY
1/2/08 9:35
9:35
1
22
RESULT SET #2
Date_IN
Account_Number
Patient_Name
Care_Unit_Key
Care_Unit
Care_Unit_Desc
Date_Time_In
Time_IN
Duration_Hours
Duration_Minutes
20080102
777777
DOE, JANE
1488748
3
SURGERY
NULL
NULL
NULL
NULL
20080102
777777
DOE, JANE
1509344
S4C
11TH ST 4 CENTER
1/2/08 5:38
5:38
0
3
20080102
777777
DOE, JANE
1509426
SREC
11TH ST RECOVERY
1/2/08 9:35
9:35
0
27
20080102
888888
DOE, JIM
1496201
3
SURGERY
NULL
NULL
NULL
NULL
20080102
888888
DOE, JIM
1509361
S4C
11TH ST 4 CENTER
1/2/08 6:45
6:45
0
6
View 4 Replies
Sep 4, 2007
Thanks for previous help, I am however continuing to have problems as I attempt to search a table for a value keyed by the user (e.g. AccessionPresent= 3624-01). The input value that is being searched against is stored in the table as an INT. I have cast the INT to a VARCHAR on the line described as "MSQL=....
Can anyone ascertain why I get the error, described below? The query works in the Query Analyzer?? What am I doing incorrectly... Any assistance will be appreciated...
Thanks !
Dim DS As DataSetDim MyCommand As SqlDataAdapterDim AccessionPresent, strsearchedfor, strsearchresult As StringDim RcdCount As IntegerDim ResultCount As IntegerAccessionPresent = Accession.Textstrsearchedfor = "The Keyed Accession Number "strsearchresult = " Does Not Exist. Please Verify Your Entry. "ErrorLabel.Text = String.Format("{1}<b><font size=ex-small color=003399>{0}</b></font>{2}", AccessionPresent, strsearchedfor, strsearchresult)Dim MySQL As String
MySQL = "SELECT * FROM ClinicalSpecimen WHERE CAST(SpecimenID AS varchar(50))='" & AccessionPresent & "'"Dim objConnValidate As SqlConnectionDim mySettingsValidate As New NameValueCollectionmySettingsValidate = AppSettingsDim strConn As StringstrConn = mySettingsValidate("connString")objConnValidate = New SqlConnection(strConn)
MyCommand = New SqlDataAdapter(MySQL, strConn)DS = New DataSetMyCommand.Fill(DS, "SpecimenID")RcdCount = DS.Tables("SpecimenID").Rows.Count.ToString()If DS.Tables(0).Rows.Count > 0 ThenResponse.Redirect("Accession_Result.aspx?AccessionResult=" & AccessionPresent)
ElseIf DS.Tables(0).Rows.Count = 0 ThenResponse.Redirect(http://www.aol.com)
IS CAUSING THE FOLLOWING ERROR:
Server Error in '/ClinicTest2' Application.
Syntax error converting the nvarchar value '3624-01' to a column of data type int.
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.Data.SqlClient.SqlException: Syntax error converting the nvarchar value '3624-01' to a column of data type int.Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:
[SqlException (0x80131904): Syntax error converting the nvarchar value '3624-01' to a column of data type int.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +95
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +82
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +346
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +3244
System.Data.SqlClient.SqlDataReader.HasMoreRows() +194
System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) +262
System.Data.SqlClient.SqlDataReader.Read() +29
System.Data.ProviderBase.DataReaderContainer.Read() +26
System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) +240
System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) +257
System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) +383
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +251
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +308
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +152
System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +2859
System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +84
System.Web.UI.WebControls.DataBoundControl.PerformSelect() +153
System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +99
System.Web.UI.WebControls.GridView.DataBind() +23
System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +92
System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +100
System.Web.UI.Control.EnsureChildControls() +134
System.Web.UI.Control.PreRenderRecursiveInternal() +109
System.Web.UI.Control.PreRenderRecursiveInternal() +233
System.Web.UI.Control.PreRenderRecursiveInternal() +233
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4436
View 6 Replies
View Related
Oct 25, 2006
When I add a referrence to
Imports Microsoft.AnalysisServices.AdomdClient
Imports Microsoft.AnalysisServices.AdomdClient.AdomdConnection,
Because I need the for an adomd connection
I receive the following problem
'MiningStructre' is ambiguous, imported from the namespaces or types
'Microsoft.AnalysisServices.AdomdClient', 'Microsoft.AnalysisServices'
with any Mining structure declaration like Dim m_ms As MiningStructure
View 1 Replies
View Related
May 7, 2007
I continue to have issues with SP-2 for SQL 2005 suite. It has now gotten so bad, I have multiple installations, including the TOOLS ONLY on my laptop failing, that I am going to stop ALL future installations of SP-2. The COM+ failures have not been resolved that I can determine. I have tried uninstalling, I have tried SP-1 before SP-2, every combination one can find. HELP.
Time: 05/07/2007 13:24:05.631
KB Number: KB921896
Machine: GA029-MDGRAVES
OS Version: Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
Cluster Installation: No
**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed
**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Setup Support Files ENU 9.00.1399.06 x86
SQL Server Native Client ENU 9.00.3042.00 x86
Client Components ENU RTM 9.00.1399.06 x86 STANDARD
MSXML 6.0 Parser ENU 6.00.3883.8 x86
Backward Compatibility ENU 8.05.1054 x86
**********************************************************************************
Products Disqualified & Reason
Product Reason
**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID
**********************************************************************************
Product Installation Status
Product : Setup Support Files
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SqlSupport.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : SQL Server Native Client
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : Client Components
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log
Error Number : 29549
Error Description : MSP Error: 29549 Failed to install and configure assemblies c:Program FilesMicrosoft SQL Server90NotificationServices9.0.242Binmicrosoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501
Error description: MSDTC was unable to read its configuration information. (Exception from HRESULT: 0x8004D027)
----------------------------------------------------------------------------------
Product : MSXML 6.0 Parser
Product Version (Previous): 3883
Product Version (Final) : 6.10.1129.0
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_msxml6.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Backward Compatibility
Product Version (Previous): 1054
Product Version (Final) : 2004
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SQLServer2005_BC.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
**********************************************************************************
Summary
One or more products failed to install, see above for details
Exit Code Returned: 29549
View 3 Replies
View Related
Mar 21, 2002
Thanks for the replies but...
I doesn't work!!!!
Anymore ideas?
---------------------------------------------
Hi,
I have a rather odd problem that hopefully you'll be able to shed some light on (nobody else has come up with anythig sensible).
We want to back up the databases to a hard drive held on another server so I mapped the drive in explorer to the drive then went into Enterprise manager and tried to create a backup device and it won't see the mapped drive.
I've tried mapping to my PC and I can see that via enterprise managers backup stuff (infact any PC in the office works) but it won't see any of the servers even though we can map to them and access them via windows explorer.
I've tried when logged on via sa and the windows NT administrator and still no luck. In fact no matter what I type or do it fails and keeps telling me device error or device off line which it isn't.
On our test instance of SQL Sever we can backup to other servers but not the new live version!
Any thoughts on what might cause this to happen?
Helen
View 3 Replies
View Related
Mar 13, 2007
I have one report (R1) which includes a list of ports ("=Fields!Port_Name.Value")
Another report (R2) supplies details for individual reports and has a parameter named PortDWIDPortName which gets port names from the same dimension as those in R1. So in the field properties of the Port field in R1, I selected Navigation > Jump To Report and entered PortDWIDPortName = Fields!Port_Name.Value (also tried changing .Value to .Key or .UniqueName) but although it jumps to report R2 it does not enter a value for the parameter (ie leaves it blank or displays <Select Value> depending on whether multivalue or not).
Does anyone know the right syntax to pass the parameter ? If not, does anyone know to view what Jump To Parameter is returning so I can figure how to doctor it!
Thanks
View 1 Replies
View Related
Jan 18, 2006
We currently have access to another department's SQL server. However they are taking that server offline within a few months, and we will need to migrate our data and DTS packages to a new solution before then. We have about 30 databases and 20 somewhat simple DTS packages, but only a few users need access. Funding is very tight.
SQL 2005's support of DTS is somewhat of a mystery to me. Docs state with 2000 Enterprise client tools installed + Express edition, that I can run DTS packages on Express edition. But the docs do not state the procedure for doing so, and I cannot register the Express server in the Enterprise manager(states must be using 2005 version of Enterprise manager). It seems I can Design a DTS package that resides on the 2000 server and specify a connection to the Express server, but the DTS package would not run, stating always that the table was in use, and I haven't explored it any further. May have just been a quirk.
I'm trying to conquer this in two pieces:
Cheapest solution for graphical design of DTS packages, or some techniology similar(I think I understand that this is called SSIS in 2005?). This would be needed by 1-4 users.
SQL 2005 Developer Edition for each user, only about $50 per user.
MSDE for each user, but can this house DTS packages and be connected to by enterprise manager?
Cheapest solution for data access and ability to run DTS packages by 2-10 users.
If SQL Express Edition is used to house data, can the DTS packages be distributed in some way that allows the users to run them? I.E. exported as VB code or some sort of file that can be loaded by an Access 2002 or VB.NET frontend.
Can all users have Developer Edition or Desktop edition and run the DTS package from it, but have the DTS package connect to the Express Edition server where the data is housed? Or would this be a violation of what the Developer Edition is intended to be used for?
Any other suggested scenarios are welcome.
Are we allowed to continue using the 2000 Enterprise manager after we no longer have access to a licensed SQL 2000 Enterprise server?
The feature comparison for the different 2005 editions doesn't mention DTS, but I know it works for some editions if the add on components are installed. I'm just not sure which versions support this.
View 1 Replies
View Related
