Viewing 15 posts - 1 through 15 (of 123 total)
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...
August 6, 2020 at 1:13 pm
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'...
August 5, 2020 at 3:20 pm
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...
August 5, 2020 at 11:31 am
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...
August 5, 2020 at 12:48 am
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.
August 5, 2020 at 12:05 am
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...
May 14, 2020 at 5:32 pm
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...
May 14, 2020 at 3:59 pm
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...
January 23, 2020 at 1:14 pm
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...
January 23, 2020 at 12:21 pm
That is perfect. Thanks!
October 11, 2019 at 5:59 pm
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!
May 14, 2015 at 5:44 am
Sean Lange (4/14/2014)
Mark Eckeard (4/14/2014)
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. ...
April 14, 2014 at 11:40 am
Keith Tate (4/14/2014)
April 14, 2014 at 10:25 am
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.
April 14, 2014 at 9:52 am
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.
April 14, 2014 at 9:47 am