Advertisement

05.02.2008 at 01:31PM PDT, ID: 23372937
[x]
Attachment Details
[x]
The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

  • The Grade of the Solution
  • The Zone Rank of the Expert Providing the Solution
  • The Number of Author and Expert Comments
  • The Number of Experts Contributing
  • The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!
9.6

Implicit conversion from data type datetime to numeric is not allowed. Use the CONVERT function to run this query.

Asked by kwh3856 in SQL Server 2005, Microsoft Visual C#.Net

Tags: , , ,

When I look at my fields that I have designated as DateTime, they have the same setting in the database.  Whatelse am I missing?  Here is the code:

@REFERRAL_DATE DateTime,
@DATE_OF_APPOINTMENT DateTime,
@MPI int,
@REFERRING_PROVIDER_NPI varchar,
@REFERRAL_QUEUE_ID int,
@ICD9_1 varchar,
@ICD9_2 varchar,
@ICD9_3 varchar,
@ICD9_4 varchar,
@REFERRAL_REASON varchar,
@PHYSICIAN_ORDERS varchar,
@BIOPSY varchar,
@ARTERIOGRAM varchar,
@OTHER_INTERVENTIONAL varchar,
@MRI varchar,
@MRI_WO_CONTRAST bit,
@MRI_WWO_CONTRAST bit,
@MRI_W_CONTRAST bit,
@MRA varchar,
@MRA_WO_CONTRAST varchar,
@MRA_WWO_CONTRAST varchar,
@MRA_W_CONTRAST varchar,
@REFER_TO_PROVIDER_NPI int,
@GENERAL_XRAY VARCHAR(100),
@mammo VARCHAR(100),
@Flouro VARCHAR(100),
@Bone_density  VARCHAR(100),
@Ct VARCHAR(100),
@CT_WO_CONTRAST varchar,
@CT_WWO_CONTRAST varchar,
@CT_W_CONTRAST varchar,
@ULTRASOUND varchar,
@NUCLEAR_MED varcharStart Free Trial
 
Keywords: Implicit conversion from data type dateti…
Title
1 convert datetime to varchar
2 Converting varchar to a Datetime
3 Convert (varchar to datetime) in a no…
4 inserting datetime values manually
5 MySQL DATETIME
6 Nuclear Hypocracy
 
Loading Advertisement...
 
[+][-]05.02.2008 at 01:34PM PDT, ID: 21489870

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.02.2008 at 01:34PM PDT, ID: 21489872

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.02.2008 at 01:35PM PDT, ID: 21489877

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.02.2008 at 01:35PM PDT, ID: 21489880

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.02.2008 at 01:36PM PDT, ID: 21489885

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.02.2008 at 01:48PM PDT, ID: 21489946

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.02.2008 at 01:56PM PDT, ID: 21489977

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.02.2008 at 01:57PM PDT, ID: 21489983

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.02.2008 at 02:13PM PDT, ID: 21490079

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.02.2008 at 02:16PM PDT, ID: 21490097

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: SQL Server 2005, Microsoft Visual C#.Net
Tags: Microsoft, Visual Studio 2005, SQL, C#, Store Procedures
Sign Up Now!
Solution Provided By: chapmandew
Participating Experts: 4
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628