What are you trying to do?

Import flat files from Server1 into a database on Server2?

If so ensure that you have setup the correct file shares, use UNC paths in your...

yes as long as DataA and DataB have a joining column, then you just need to use the lookup function to pull the right column from DataB where it matches...

Yep, query msdb.dbo.sysjobschedules, link it back to msdb.dbo.sysschedules to get the schedule id, pass it into sp_update_schedule with an enabled param of 0

In the footer of a subscription email? Not that I am aware of.

In the report itself, you could use an expression on the text box

Ensure the path is correct

A backup every...

sp_update_schedule

sp_update_jobschedule

Query sys.default_constraints, link it back to sys.columns and you get the default name, table name and column name.

For rules, they are a depereciated feature, you should consider changing them all...

Many ways

exec xp_msver 'ProcessorCount'

SELECT cpu_count FROM sys.dm_os_sys_info;

Sure if you google "Number of Processors SQL" you will find others.

That would be one for a ranking function. Depending on how you want to do what you need to do and then also what you want to do if...

Use an expression in the text box which is the title, like the below

="Report with "+CStr(Paramaters!Param.Value)+" persons"

Time plays a big factor in the deletion as it looks for anything which is directly 15 days or older.

For example, day 1 backup finishes at 00:10, day16 finishes at...

That would then call for something to be coded in the app which will FTP up the file to a specific location, then connect to SQL and issue something like...

So the computed column is ColA / ColB, what do you want the output to be.

If ColA is 10 and ColB is 0, do you want the computation to be...

I would say this is a task for SSIS.

Use it to download the files from the FTP server and then if it downloads any execute a for each loop to...

Hi

Something like this?

DECLARE @Client TABLE (ClientID INT, Expected INT)

DECLARE @JobHis TABLE (ClientID INT, JobInfo INT)

INSERT INTO @Client VALUES (1,1),(2,2),(3,3),(4,4),(5,5)

INSERT INTO @JobHis VALUES (1,100),(2,100),(2,200),(3,100),(3,200),(4,100),(4,200),(4,300),(4,400),(5,100),(5,200),(5,300),(5,400),(5,500)

SELECT

t1.ClientID,

t1.Expected,

COUNT(t2.ClientID) AS Actual,

CASE WHEN t1.Expected > COUNT(t2.ClientID)...