order does not matter - and the way it works "logically" is that for each row on the out query (customer) check if a row exists on the inner query...

Have a look at Power BI Report Server - that is the one you need and it is a superset of normal RS server.

Assuming you have SQL Enterprise with...

first.... why in HELL will you have a production database dependent on details stored on a dev database?

second - what SQL Server license do you have on your Development database?...

have a look at https://dba.stackexchange.com/questions/246773/prevent-ssms-from-seeing-the-servers-file-system

but use at your own risk.

why do you need to hide this?

and check if on your 2012 server any permission was removed - either directly or...

what is the final purpose of this SQL - how is it going to be used and where is the final output? e.g. csv file, excel, web page?

I think you have issues understanding exactly what you need - a DATE field has no format.

you can convert a date to any format you want for writing to a...

don't do that on SSIS - do it on the select from the table where it will be a lot easier to do and will be faster than doing it...

do a query on the max and min values for r.ActualAllowed - that * 100.0 is most likely resulting on a bigger value than what a decimal can hold.

so casting...

unless you license your PC with a valid SQL Server Standard/Enterprise you can't do it for production purposes.

If you are not using those daily loads for production then you can...

we are in the process of deploying the packages to an integrated environment

What do you mean by that, as in deploying them to SSISDB? Are the packages all in...

have a look at the following links - they contain some good information even if not exactly what you are asking for.

and you may have seen some of them already.

you may need to speak with the supplier of the file and see how they are generating the file.

you could also try HxD (https://mh-nexus.de/en/hxd/) to edit the file and pick...

you may need to look at adding a codepage to your bulk insert command

or alternatively use powershell - but again you will need to specify the correct codepage to load...

it can be SQL Server - but without the code for both procs there's not much we can say

nearly there as not too hard to put a sample code was it?

unpivot has one small issue - the columns need to be hardcoded (or dynamic SQL used) and they...

• This reply was modified 5 years, 6 months ago by frederico_fonseca.