You can run the query in an Execute SQL Task and store the result in a variable.

You can only see the actual value of the variable though when debugging the...

Yes, you can right click on the report and go to its properties. There you can define a fixed credential which will be used everytime the report is run.

Nice one thanks.

Easy one, thanks!

Thanks for the question.

SQLRNNR (11/1/2013)

---

The Dixie Flatline (11/1/2013)

---

Stefan Krzywicki (11/1/2013)

---

SQLRNNR (11/1/2013)

---

The Dixie Flatline (11/1/2013)

---

SQLRNNR (11/1/2013)

---

The Dixie Flatline (11/1/2013)

---

SQLRNNR (11/1/2013)

---

[font="Wingdings"]How sure are...

Nice question, thanks.

Very nice question, thanks.

Koen Verbeeck (10/31/2013)

---

db808 (10/30/2013)

---

I'm reading the Training Kit Book and there are sections with a "key" icon. What are the relevance of these verses the sections labled "exam hints"

Also...

For those who didn't read my last blog post (tsk tsk tsk): I'm changing jobs.

Today is the last day on my current job and Monday I start at a small...

Cognos handles parameters way better than SSRS.

In Cognos you have prompt pages, while in SSRS you have almost no control over how parameters are prompted to the end users.

SSRS is...

Can you share the update statement?

You need to escape the single quotes.

Try this:

Exec StoreProc1 'John','19-08-2013','(''CHINA'',''MALAYSIA'',''INDIA'',''JAPAN'',''USA'')','Krin'

Never seen someone so excited about CLR...

If you have 300,000 rows, the UDF will be called 300,000 times if you defined a scalar UDF.

More info:

User Defined Functions and Performance

Using a table valued function could improve performance.