That helps.

regarding data by all means do not put real data.

something like

patient 1

patient 2

treatment 1

treatment 2

will do fine as long as the joins work.

And I hope you have dummy data...

complex - and a few answers required.

your code only contemplates 2 treatments and 2 courses - what if there are 5 or 10 treatments? or if there are more than...

have a look at http://hownottoprogram.azurewebsites.net/?p=631 - maybe it applies

ensure your backets are really as they should be.

you got 3 conditions - see which one is "incorrect" according to your expectations.

CASE

WHEN

-- condition 1

(CalendarSchool.schoolLevelOPS IN ('All', 'Elem') AND ScheduleStructure.name...

rowversion is only used to determine if a row has been changed on the following cases

1 - syncronization with another systems (but it won't catch deletes)

2 - to ensure that...

look here https://msdn.microsoft.com/library/mt204009.aspx

As said you can do it with C#. - but execute it on the SQL Server server machine, not locally on the users machine.

see https://msdn.microsoft.com/en-us/library/ms403355.aspx for ways to...

newer versions of VS are supposed to be backward compatible..

and at least with SSDT for VS 2015 on the Integration Services project properties there is a TargetServerVersion property that allows...

you can do it in c# or powershell - see a good example here https://blog.netnerds.net/2015/01/powershell-high-performance-techniques-for-importing-csv-to-sql-server/

main thing is not loading everything in one go to a data table -...

I'm sure others will give more feedback.

from my point of view having data and logs on the same drive are not necessarily bad - all depends on the workload.

If nothing...

imani_technology (8/30/2016)

---

By the way, I have three questions about the code

C:\DTEXEC -f test.dtsx > C:\folder\output.csv

1. PowerShell won't allow "&gt". Is that a typo?

2. How do I pass...

hi,

In terms of getting the output of the DTEXEC command onto a file how it is done depends on how you execute it

- if executed from a SQL Server...

theres no limit to the number of columns you can update in one go.

UPDATE a

SET a.color_cat = b.category

, a.location = b.location2

FROM objects_table a

JOIN shades_table b

ON a.[object_name] LIKE...

you already have your answer - you need to create a paging mechanism, and the API documentation should state how that is done.

And without us knowing what is the...

easiest way is to build the records on SQL and then just output to the flat file as a single column.

One approach I've taken on this is to have a...