darkhelmutis (5/2/2013)

---

I figured out that it is possible to use cascading filters (i.e. dependant filters) in SSRS 2005:

This is how I did it:

- Updated the SP that retrieved the Transaction...

a_ud (4/19/2013)

---

Hi,

My question is about calculating a computed column in SSIS. Unfortunately, the column is based on another column in the same query which, at its turn, is a subquery....

sotn (5/2/2013)

---

I want to build a DW and I need to identify records that have changed, and luckily each table in our ERP system has a timestamp/rowversion column, but I...

L' Eomot Inversé (5/2/2013)

---

Take care not to forget...

ChrisM@Work (5/3/2013)

---

a_ud (5/3/2013)

---

Thanks, I'm still getting my head around it, I'm going to try it right now.

I've never used a CROSS APPLY, but I guess this could be translated (done)...

ChrisM@Work (5/3/2013)

---

wolfkillj (5/2/2013)

---

Sean Lange (5/1/2013)

---

ChrisM@Work (5/1/2013)

---

Sean Lange (5/1/2013)

---

So what exactly is the issue here?

I would suggest you use the newer join constructs. With this query you don't even need a...

Eric M Russell (5/2/2013)

---

Ryan007 (4/30/2013)

---

Hi,

We are running one job which runs SELECT query from a view from another linked server. We are getting blocking in the linked server where SELECT...

a_ud (5/2/2013)

---

<snipped>

The weeks table stores values 1..5. The PAscores table stores the scores for different volunteers. I'd like to have the missing entries in tblPAscores; if volunteer John is missing...

Sounds like you may be thinking...

qgudex (5/1/2013)

---

I figured out what had happened here. It turns out someone had cloned the SQL sever without my knowledege and that new server was the one sending the...

Sean Lange (5/1/2013)

---

ChrisM@Work (5/1/2013)

---

Sean Lange (5/1/2013)

---

So what exactly is the issue here?

I would suggest you use the newer join constructs. With this query you don't even need a where clause.

Here...

arnipetursson (5/1/2013)

---

It looks like all of the data was read from cache, since you had 203 logical rads and 0 physical reads.

If you do not run CHECKPOINT before running DBCC...

MaxNevermind (4/29/2013)

---

1) As I understood from here

[/url]

"elapsed time" is the total time of statement's execution, but how than it can be less then CPU time, it should includes it?

DBCC execution...

ft55 (4/29/2013)

---

Recently we have started seeing some deadlocks reported on a database instance. I have enabled the trace -T1222 and am trying to interpret what has been returned in...

jbalbo (4/30/2013)

---

Hi,

I',m new to XML and here is what I need to do...

I want to create a SQL query to pull data and update a field on a table with...