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...

nialldunne (3/3/2016)

---

HI There,

i am attempting to get a definitive answer on whether or not DB mirroring is supported in SQL Server 2014. I know MS have stated that it will...

Your query looks fine to me.

I would move the s.lvl > t.lvl part into a WHERE clause, but it won't have any effect on the results.

There's also no harm...

Sounds like the structure of the spreadsheet is different from how it was when the package was designed.

Luis Cazares (3/2/2016)

---

Phil Parkin (3/2/2016)

---

Luis Cazares (3/2/2016)

---

Hugo Kornelis (3/2/2016)

---

The alternative, since this appears to be some type of ETL process to feed a DW table, would be to create an...

Luis Cazares (3/2/2016)

---

Hugo Kornelis (3/2/2016)

---

The alternative, since this appears to be some type of ETL process to feed a DW table, would be to create an SSIS package.

That tool is...

SQLTougherGuy (3/2/2016)

---

Hi Phil,

If there is a way that I can separate the tags, maybe I can wrap this in dynamic SQL. I am thinking something like...

@var = 'Create Job'+<NAME TAG>,...

SQLTougherGuy (3/2/2016)

---

Hello SQL friends,

Does anyone know if it is possible to create multiple SQL agent jobs using an XML file? We are moving away from Control-M and I have an...

Precisely.

Takes more setting up initially, but...

Phil Parkin (3/2/2016)

---

Best practice is to break up the code into small chunks, each of which does essentially one thing, and...