Viewing 15 posts - 8,101 through 8,115 (of 8,753 total)
Tania Mofflin (6/3/2014)
Msg 8114, Level 16, State 5, Line 1
Error converting data type varchar to numeric.
Seems to be an issue with how...
June 3, 2014 at 1:02 am
Jeff Moden (6/2/2014)
Unless this was an accidental duplication of data, there's no way that I'd do this. You're destroying historical data.
Second that but then again that's pondering on the...
June 3, 2014 at 12:43 am
Thank you Andy for a good question.
Quite certain I checked the right answer but still came as wrong. Either a bug or lack of industrial strength tanker sized espresso in...
June 2, 2014 at 11:13 pm
This should get you started. In order to produce a complete answer, a order must be specified for the set, as it is, it is not possible. A hint for...
June 2, 2014 at 10:06 pm
The Dixie Flatline (6/2/2014)
Eirikur Eiriksson (5/29/2014)
I have found that one should generally (as much as I dislike generalization) avoid AUTO_GRID.😎
Would you care to elaborate why?
Using the automatic settings for the...
June 2, 2014 at 9:33 pm
Not without dissecting the code as only CLR procedure parameter defaults are listed in sys.parameters. More can be found here http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=234143%5B/b].
😎
June 2, 2014 at 9:08 pm
vasuarjula (6/2/2014)
I have a procedure (a) where i call another procedure (b) passing @message as a parameter to procedure B.
Ex:
Create procedure a
as
Begin
declare @prevyear
exec b @message = 'avvasdva' + cast(@prevyear as...
June 2, 2014 at 1:05 pm
Is something like this what you are looking for?
😎
USE tempdb;
GO
;WITH XMLNAMESPACES (DEFAULT 'http://tempuri.org/Ultimate')
,XML_DATA AS
(
SELECT
EX.ID
...
June 2, 2014 at 12:22 pm
d. There is nothing you can do except update your resume
Smells like irony...:-P
😎
June 1, 2014 at 3:21 pm
TomThomson (6/1/2014)
June 1, 2014 at 1:08 pm
Igor Micev (6/1/2014)
2312 - http://support.microsoft.com/kb/2801413
Use when running SQL Server 2014 with database compatibility level 110, which is the compatibility level for SQL Server 2012. Trace flag 2312 forces the query...
June 1, 2014 at 9:19 am
Have you implemented the changes suggested by myself and Steve?
Few questions:
1. Do you use variable(s) to hold the date and time value during the processing of each file?
2. Are you...
June 1, 2014 at 8:53 am
Check out this article XML Schema validation in SQL Server[/url], the last part demonstrates similar error handling.
😎
June 1, 2014 at 4:39 am
Good question, thanks Steve.
😎
Still some confusion in the documentation at support.microsoft.com:
The following plan affecting trace flags are available in Microsoft SQL Server 2014:
9481
Use when running SQL Server 2014 with the...
May 31, 2014 at 9:12 pm
baddulas (5/31/2014)
Hi Eirikur Eiriksson,I am using Hours and Minutes and Seconds that's why it is changing.
If you look at the error message, it says
D:\ZIPPINGFILE\20140528_225754.txt.zipD:\FLATFILEGENERATE\20140528_225754
when it should be
D:\ZIPPINGFILE\20140528_225754.txt.zip D:\FLATFILEGENERATE\20140528_225754
Add as space...
May 31, 2014 at 1:33 pm
Viewing 15 posts - 8,101 through 8,115 (of 8,753 total)