SQL* (7/9/2012)

---

Hi All,

which is the best option, whether to load data from csv or from the sql server table.

I have export the data from sql to any staging like csv/sql...

It certainly looks that way:

"A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance...

Where did you get the idea that a subquery is faster than a join?

A correlated subquery certainly isn't. If you query is slow, it's probably because you don't have the...

How to: Run a Package Using a SQL Server Agent Job

At the end of the page in the yellow box is an example.

Any reason why you want to eliminate joins?

A subquery won't perform faster.

If I were you, I would rather get rid of the subquery that's already in the query and join...

Jeff Moden (7/9/2012)

---

Koen Verbeeck (7/9/2012)

---

Jeff Moden (7/7/2012)

---

Phil Parkin (7/7/2012)

---

I think you might mean a script...

It sure is a good start for the workweek, fixing that impossible bug 🙂

These are the types of bugs that can drive you really mad 🙂

In TSQL it's fairly easy:

WITH CTE_Tally AS

(

SELECT TOP 100 number FROM MASTER.dbo.spt_values

WHEREtype= 'P'

AND number> 0

)

SELECT

number

,week_day = CASE WHEN (number % 7) = 0

THEN 7

ELSE (number % 7)

...

You can use the FLOOR function to get rid of the decimals.

hamsa_apj (7/6/2012)

---

Yes its correct. Job triggerrs the SSIS package and it is scheduled to run every 5 min. For loop task is used in the package to iterate the .dat...

Jeff Moden (7/7/2012)

---

Phil Parkin (7/7/2012)

---

I think you might mean a script task, and I agree.

The...

I don't know a thing about IBM MQ, but a quick Google search resulted in this:

http://stackoverflow.com/questions/2501743/ssis-and-ibm-mq-series-integration

Normally the adminstrators of the server itself (adminstrators part of the BUILTIN\Administrators group) have admin privileges in SSRS.

I assume your interview didn't went well?