Viewing 15 posts - 1 through 15 (of 4,949 total)
I tried your SQL and got an error.
Msg 319, Level 15, State 1, Line 21 Incorrect syntax near the keyword 'with'. If this statement is a common table expression,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 22, 2022 at 3:30 pm
Can you confirm the exact format of JObject? It looks like
{"View"true,"Edit"true,"Admin"true}
Is that right?
It's real fuzzy, but the colons are there. Another reason images of data are bad, Jeffs.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 22, 2022 at 3:13 pm
As it's JSON, treat is as JSON.
I can't test this, as copying text from an image isn't easy (please use DDL and DML statements in the future), but you likely...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 22, 2022 at 3:12 pm
Can you not use SSISDB? The logging available would significantly make this easier to see where things might be going wrong. The deployment method is far better than both the...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 22, 2022 at 3:08 pm
Syntax like FORMAT(tab1.g, 'yyyy-MM-dd')
suggests that you are "rounding" a date and time value to just the date; you would therefore be much better off just casting/converting the value to...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 22, 2022 at 8:22 am
Presumably this is within a ForEach loop container, so seems that setting the Propagate property to False of said Container is what you need; then when the data flow for...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 20, 2022 at 4:09 pm
Do all the linked servers definitely have the table dbo.qc
in the database w
? Are all these objects exactly the same definition? Do you have have to use UNION
(which...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 20, 2022 at 1:25 pm
But I have many tables, many querys, this is only a short part of code, the code have more than 450 lines, I need to do a report, I...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 15, 2022 at 2:25 pm
Why do you mean by a "txt file"? As in the file has a .txt
extension? You define the name of the file with the @query_attachment_filename
parameter; so you could...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 15, 2022 at 10:13 am
any help in how I can do the date format change?
What was wrong with the wealth of replies above about using CONVERT
with a style code (or combined with...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 15, 2022 at 9:53 am
I must admit, the lack of support for table type parameters in SSRS is frustrating. Though, I also feel like the opposite syntax that SSRS allows (SomeColumn IN (@Variable)
)...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 13, 2022 at 12:46 pm
I have a (bad) habit of putting the SQL into the reports when building, but I do think that Procs are actually better; I just end up not always migrating...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 10, 2022 at 8:29 am
Did they actually build the project in VS 2015? Could they have used a newer version? If you have a copy of their original solution file 9not one you have...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 31, 2022 at 1:48 pm
On a side note, I am also putting forward tomorrow we actually consider delaying the migration (as we're so far behind schedule) and wait for 2022 at this point. We...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 30, 2022 at 1:38 pm
A little bit off topic, if you good folks don't mind... I am curious about good experiences in SSIS (and, no... not being ironic there... they made the tool...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 30, 2022 at 1:26 pm
Viewing 15 posts - 1 through 15 (of 4,949 total)