sivag (8/3/2012)

---

here i just opened job and i made a right click the i found new job i just selected that than after that...

opc.three (8/5/2012)

---

WayneS (8/3/2012)

---

First, I agree with A-D...

vk-kirov (8/3/2012)

---

I got a point for choosing the "correct" answer because I hadn't counted characters in the dynamic queries. Now I want an extra point for that reason. This is...

When you run the import export wizard, you have the option at the end to save the package. Do that.

Then follow these steps:

SQL Server Agent Jobs for Packages

Pallab Bakshi (8/1/2012)

---

I have one SSIS package. In the package I configured the config file, and it is enabled. I am calling this package from SQL Job. There I provided...

No problem. Take a look at the import and export wizard to get you started.

sivag (8/3/2012)

---

in databse 1st databes A I AM HAVING A COLUMN A

TABLE 1 SER1

...

Indeed, the correct answer is 1,0,1,error, because the last query produces a syntax error. Shame, because it was a pretty good question otherwise.

Points back please 🙂

For those who care, Aaron posted a follow-up on the splitter article:

Splitting Strings : A Follow-Up

SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = 'Table A'

INTERSECT

SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = 'Table B';

shahsn11 (8/2/2012)

---

So does that mean that Surrogate Key is only the concept. And in lay man terms(i.e. mine) can we say that PK=Surrogate Key.

If the above is true that what...

In order that anyone here on this forum can give a decent answer, it's best that you provide the table schema, the query and the execution plans before and after...

No problem, glad to help 🙂

Sure, you can get a certification. You'll need some real life experience though.

But at least it will force you to look at aspects of SQL Server you're not familiar with.

Maybe there are just too many columns to render the report efficiently?