Thom A (10/4/2016)

---

This doesn't really sound like an SSIS task, no. Generally SSIS is used for ETL, and what you're doing here is simply checking the data and notifying someone...

Merely repeating your request, rather than answering my question, does not fill me with enthusiasm in terms of providing a useful response, sorry.

JALLY (10/3/2016)

---

Hello,

How can i return rows in a table by a value in a column of that table:

for example:

i have a row with table structure below :

!D Schedule ISCI rotationnumber

1...

JustMarie (10/3/2016)

---

Phil Parkin (9/28/2016)

---

I'm interested. Can you explain why, please, in...

..Such that there is a single table containing salaries, with appropriate effective dates.

Kn1807 (10/3/2016)

---

I need to pro-rata a monthly budget so that a greater proportion is allocated to beginning of month.

They want it to be:

working days 1-5 = 40% of total budget

6-10...

GA_SQL (10/3/2016)

---

i have table for each month which stores the employee's salary, i need SP which takes the input has empno and month with year has input, which should display...

Please have a look at this link and see whether you may be able to adapt it to your situation.

What you are probably looking for is a 'recursive CTE'.

There's a quick 'n' dirty way of doing this which resembles the technique used by Des, whose set-up script I have copied (thanks!):

IF OBJECT_ID('tempdb..#Required', 'U') IS NOT NULL

...

It's required...

There is no 32-bit version. You need a 64-bit system to install SQL Server 2016. Check the system requirements page.

pavan.msbi558 (9/30/2016)

---

Hi All,

when i trying to install sql server 2016.iso file i am getting below error . Please give me solution for this issue

sql server media is not supported on...

quinn.jay (9/30/2016)

---

John Rowan (9/30/2016)

---

All you need are the .dtsx files. If you need to open them in a solution for editing, create a new project in Visual Studios, start...

PiMané (9/30/2016)

---

Hi,

I've a table with 1.000.000 rows where active records and inactive records are kept, since the user can search on both status (only 5% or less of the time...

quinn.jay (9/29/2016)

---

John Rowan (9/29/2016)

---

The solution files are only needed for development. Once you've built the package into it's .dtsx file, the solution is really not needed. Your job...