Viewing 15 posts - 1,246 through 1,260 (of 5,109 total)
No sure if that is your full DDL but you, it appears you're trying to insert the string value "<null>" into a column of the data type datetime. You'll probably...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 17, 2019 at 9:38 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 12, 2019 at 9:04 am
Completely agree that loading 500 tables in a single Data Flow task would unlikely be a good idea. Your data is going to have some kind of relationship definitions, so...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 12, 2019 at 7:51 am
What do you mean by "day 1"? As in at product launch? If so, why not rollback to the pre-release version, as that should be the same?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 11, 2019 at 4:39 am
That second XML isn't valid. The tag Order isn't closed. Sounds like, however, you need to pass all the values as an empty string ('')?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 11, 2019 at 4:27 am
What do you mean by "not matching", different values? Perhaps the deployed report is using a different data source, and thus when the default value is calculated a different value...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 10, 2019 at 10:08 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 10, 2019 at 6:37 am
Duplicate post of https://www.sqlservercentral.com/Forums/2019660/Looking-How-to-achieve-DBMSApplication-DBMSSession-DBMSOutput-in-SQL-server-2017
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 9, 2019 at 6:29 am
Interesting development on Stack Overflow, where they shared email addresses to Amazon without consent. This is a meta post on it (with response from one of their product managers): Thom~ Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 9, 2019 at 4:55 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 8, 2019 at 7:48 am
You're still using execute(@query);. Like I showed above, you need to use parametrised SQL with sp_executesql.
P.s. I still really suggest getting some formatting and...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 8, 2019 at 5:51 am
OK, that explains a lot more. We'll go with the simplified version again, but you need to parametrise your dynamic SQL, rather than passing the dates as literal strings. So,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 8, 2019 at 5:17 am
There's a few problems with that SQL you've posted. Firstly you have:declare @frdate datetime =;01-jan-2019',@todate datetime ='31-jan-2019'
You have a wayward semicolon before your first date's value,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 8, 2019 at 4:51 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 8, 2019 at 3:08 am
Viewing 15 posts - 1,246 through 1,260 (of 5,109 total)