christian 92959 (12/20/2011)

---

Hi Phil,

thank you for the imediate response, i changed my query to your advise ... but its not faster at all.

Investigating the execution plan gives me the information...

Thanks for the feedback and no problem.

Note: use

datediff(dd,0,getdate()) - 7

If you'd like to remove the time component from today - 7

christian 92959 (12/20/2011)

---

Hi there,

first of all thank you all for the tips and hints here, ive got alot of tips out here for my daily work ! Thanks !

Now my...

Paul_Harvey (12/20/2011)

---

Hello all,

I have a question, which hopefully won't require too much time from the person that knows the answer!

I have a very simple SSIS package, which performs a few...

Please post the error message, if there is one.

Add a derived column in your dataflow and set it to the value of the variable containing the file name.

Then map the new column to your database column as usual.

Wow.

Even the requirement of knowing whether or not the moon is gibbous is catered for 🙂

No problem, thanks for posting back.

I see. OK - I put an ASCII 30 character into a Word document, then copied that to the clipboard, then pasted it into BIDS.

Did you try?

I just set up a source connection and it *seemed* to work.

apatel 80451 (12/16/2011)

---

I want my YTD to be summed up by Zone column YTD:

Zone 2011 YTD

Tango ...

apatel 80451 (12/16/2011)

---

Hi,

I am trying to calculate YTD totals for the following data, at the moment I'm getting a varchar field for my date e.g. '201101'. I will therefore be...

Roughly how many integers are going to be held in the variable?

If you persist with this approach, then one way or another you're going to find yourself looping. But maybe...

The wording in your question demonstrates that you know the answer, as far as I can see.

Have you considered Cozyroc software? It includes a dynamic data source component, from what...