So I took the exam yesterday and wasn't asked this question.  Part of me is annoyed as I wanted to get it so I could answer it.  Not sure if...

Here is the full scenario:

 

You run the following query:

select * from tblTest

where TestNumber = 20012

The query output window displays the following error: "Conversion failed when converting the varchar value 'AB012'...

Thanks for the input as it is appreciated.

Just to be clear, this is geared towards CAST questions I read about on the 70-761 exam that i am taking today and...

This was a topic that I am covering for the 70-761 exam.  The CAST isn't in a join and I read in the study guide that if performance isn't an...

Yes, I did think of that too but the topic was about using cast and I was confused why I was reading cast didn't work when it does for me.

Thanks!

Thanks.  All good advice and I'm seeing a few things I need to do.

I already have staging table (the month_year ones) but I may collapse them to 1 table with...

I always try to be brief in postings but know that short changes the description of the issue.  Sorry about that.

In theory, I could import the last file of the...

John - I scanned the values and ran a query to check for any non-numeric values outside of '%' and nothing.  Your last query supports that as it returned the...

Erland - This is a 3rd party app and I have no control over it.  Also, I have been asking for an upgrade from 2008 for 2 years and it...

John,

That is perfect.  Thanks!

Mark

I don't have direct access to this server but I'll pass this on to the DBA and ask him to look in to it.

Thanks for the suggestions!

Mark

Sean Lange (4/14/2014)

---

Mark Eckeard (4/14/2014)

---

Keith,

I'd like to see the actual SQL. That would allow me to conduct a more specific search within the app to (hopefully) find it. ...

Keith Tate (4/14/2014)

---

Mark Eckeard (4/14/2014)

---

It's worth noting that I'm not 100% sure it's imbedded sql. There's a chance it's a sproc. I would need to account for that...

Keith,

It's worth noting that I'm not 100% sure it's imbedded sql. There's a chance it's a sproc. I would need to account for that possibility.

Thanks,

Mark

Keith,

I'd like to see the actual SQL. That would allow me to conduct a more specific search within the app to (hopefully) find it.

Thanks,

Mark