As Grant mentioned in order to achieve a similar functionality like Oracle you need to have your database set with Read Committed Snapshot (RCSI).

Basically with RCSI your readers will not...

did you bother reading my reply?

you do need to look at the output of your print command - that will show it what is wrong.

try the following - removed some of the single quotes on...

using https://mh-nexus.de/en/hxd/ - its a must have tool for a developer that deals with multiple type of files. with it you can see if the row delim is "0d", "0A"...

If you're going to split the data on the way in, even if it's just two columns, you're going to need a "Format File" to do it.  If no...

apologies.

Bulk insert (done this way) requires a slightly different setup

working example below - note that i have removed the record type from the temp table as bulk would fail because...

can you post here the bulk command you used please.

yes that would be a way - where I do "insert into #data .......

you can do it 2 ways

1 - use parameters instead of string replacements - this is the best option- google and you will find some code with it for powershell

2...

I think the record layout is correct - its just that column "provider name" should be further divided into LastName, FirstName, Middle Initial (probably)

if object_id('tempdb..#data')...

I think the record layout is correct - its just that column "provider name" should be further divided into LastName, FirstName, Middle Initial (probably)

if object_id('tempdb..#data') is not...

not my group by - I just copied the original code and moved the top 5 to the inner sql - and removed the outer sql as not required

so if...

look at the properties of the linked server you are using and enable the RPC options

select top 5 c.companyname as companyname, sum(j.cost) as cost
from job j
inner join customer c
on j.cus_guid = c.guid
where j.duedate >= dateadd(day,-7,getdate()) and
j.duedate < dateadd(day,+1,getdate())
group by c.guid,c.companyname,j.cost
order by cost...

And I have to ask - what is your trillion size number - please put it fully here

1.000.000.000 -- for me this is 1 billion

and 5 GB ... that's a...