One way is to create a SQL Agent job which runs the package.

Then allow the user to run a proc (possibly using EXECUTE AS to escalate the rights of the...

The error message mentions SEQ_NUM. Put something in that.

Different question, but similar...

etl2016 (3/4/2016)

---

thank you, I think in my case there is no RBAR

My query extracts from DW and manufactures a summarised aggregate table, which has 1 day information per record, so,...

No, you cannot force NULLs into a column that has been defined...

ripas (3/4/2016)

---

Hello,

I want to transfer advisors from student_div_master to advisor_stud_table but because of null values I get an error.

advisor_stud_table has primary key. Is there any other way to copy some...

Yes.

Select Col3...

below86 (3/3/2016)

---

Phil Parkin (3/3/2016)

---

below86 (3/3/2016)

---

Jeff Moden (3/2/2016)

---

So why not use the single...

Thanks, guys.

TheSQLGuru (3/3/2016)

---

Yes to all of what you said. And it is available on Standard Edition, as opposed to "Always On", although I think a dumbed-down version of that is being...

below86 (3/3/2016)

---

Jeff Moden (3/2/2016)

---

So why not use the single proc with the...

Try

WHERE DXCD1 IN ('7140') OR DXCD1 IS NULL

You could try extracting a Dacpac and then deploying that.

shamshad.ali (3/3/2016)

---

I have to add data in tables for a fresh empty database, Don't know the structure but found Foreign Keys implemented in tables.

So I need some kind of script...

Mike Wiz (3/2/2016)

---

I have a table that has a list of category codes and keywords.

For example code=1234, keywords=bakery,baking,pastry

I want to search against another table that has titles, looking at all...