Double-hop security issue, I think. Not sure how to work around that for SSIS though. Either that or are you...

I'm not sure I get the new concept of 'swarm'. Nope, not at all. Most of my experience with swarming is me trying to fix some issue with...

TJonsek,

It's not a lack of interest, but time, that's probably got a lot of people delaying on getting involved in this thread. There's a lot of information in your...

These are estimates, not actuals, but it still gives us some idea of what's going on. The actuals are more useful, however.

In the massive statement (SELECT DISTINCT, 5th statement,...

VGish,

Help me out here. I didn't dig through your code, sorry, but from the first entry you're looking for your data to be gap filled? How do you...

I know I do, and it occassionally screws up for me too. They're related, I take it?

Which means nothing out of context, other than it's not...

Figured it out again (I think):

DECLARE @beginYear DATETIME

SET @beginYear = DATEADD (yy, YEAR(getdate()) - 1900 , 0)

PRINT dateadd( dd, (DATEPART( wk, getdate()) - 1) * 7 - datepart(dw, @beginYear)...

Numerous.

Stored Cache in engine.

Security allowed execute only on proc and no direct data access.

Multiple call reusability.

(Depending on tasks) Can do multi-step processes that a view cannot.

Helps to protect against SQL...

Well, there's

DATEPART( mm, @date) which will give you the month.

DATEPART( ww, @date) which will give you the week # in the year.

You'll use those for sorting.

For display, you can then:

DATENAME(...

Must have been one wild ride. Glad...

Nope. I have only used the return value, or selected the results of the exec into a temp table and then used whatever I needed from the #tmp.

Gift Peddie (11/2/2010)

---

The net is the great equalizer it is the reason very few code sets impress me because most are modified Microsoft or now Oracle code. I have...

Figured out the problem. It's because the 'tabs' are converted to spaces when I copy/paste the code in. Seeing if it works from plain encoding. Yes, plain...

naidu4u (11/2/2010)

---

I am unable to structure the code, I mean its becoming really difficult to insert the row column in this tmp table...(by using views since I can really insert...