Viewing 15 posts - 2,086 through 2,100 (of 2,568 total)
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
select name, is_rpc_out_enabled
from sys.servers
where is_linked = 1
if is_linked = 0 that is the instance itself
November 7, 2018 at 4:28 am
not with standard SSIS methods
Depending on the file you can however use a C# script to parse the file and create the table yourself.
With bulk insert (T-SQL)...
November 6, 2018 at 5:39 pm
I've seen this happen before - on 2008 R2.
It was possible to generate the table and the index, but the filter definition would not be generated depending on the...
November 6, 2018 at 2:43 pm
Was correct in assuming that what you asking for was not really the real requirement.
Changing the delimiter alone is not the solution if you have to parse the...
November 6, 2018 at 1:24 pm
yes assuming that the file is a correctly formed delimited file
read file using old delimiter - split columns - write to new file using new delimiter.
dead...
November 6, 2018 at 12:29 pm
there are a few options - https://www.techradar.com/news/best-virtual-machine-software - some of these would be mainly for presenters out of premises as it allows all in a single computer.
Not mentioned...
November 5, 2018 at 3:45 pm
Viewing 15 posts - 2,086 through 2,100 (of 2,568 total)