Viewing 15 posts - 2,161 through 2,175 (of 2,651 total)
easier does not mean better or correct.
And as the output is being loaded by a COBOL program what is the exact layout it needs?
fixed length file?
November 11, 2018 at 6:22 pm
and most important where is the code you surely have already tried to do to address your requirements.
As well as the rules and the desired output.
And that...
November 11, 2018 at 3:29 pm
you still didn't understand the main issue.
Most people will not download a file that can contain anything at all.
DDL and SQL unless extremely big (10K lines...
November 11, 2018 at 12:58 pm
In my current (and some of the previous) company we definitely have audit controls.
Not in all systems (yet) but at least on the core ones.
so every time someone...
November 11, 2018 at 12:09 pm
similar results for me
As the results I had given before only related to the date part I've also run your code with just the date bit.
and also...
November 10, 2018 at 2:06 pm
November 10, 2018 at 12:51 pm
November 10, 2018 at 12:37 pm
Jeff Moden - Saturday, November 10, 2018 11:30 AMThanks, Frederico. Time for some play.
just in case having a single value was an...
November 10, 2018 at 12:34 pm
November 10, 2018 at 12:31 pm
November 10, 2018 at 11:03 am
Cool. The only thing is that I try to avoid trips through...
November 10, 2018 at 10:36 am
one other option (and there are more)
declare @tbl table
( juldate decimal(18, 0)
, timei float
)
insert into @tbl select 118063, 11456
insert...
November 10, 2018 at 9:31 am
November 10, 2018 at 8:09 am
Error looks quite clear.
----------
Could not use view or function 'InvoiceTotals' because of binding errors.
----------
one of your view is invalid because the underlying objects changed ...
November 7, 2018 at 8:47 pm
not quite
is_linked = 0 - reports the instance settings
is_linked = 1 - reports the specific linked server settings
Having the instance rpc_out enabled does not enable it...
November 7, 2018 at 4:47 am
Viewing 15 posts - 2,161 through 2,175 (of 2,651 total)