Martin Schoombee (2/24/2012)

---

Divine Flame (2/24/2012)

---

I am thinking of something like this:

IF OBJECT_ID('tempdb..#MyTestTable24Feb2012') IS NOT NULL

BEGIN

DROP TABLE #MyTestTable24Feb2012

END

CREATE TABLE #MyTestTable24Feb2012

(

ID INT IDENTITY(1,1),

Value VARCHAR(20)

)

GO

INSERT INTO #MyTestTable24Feb2012 VALUES ('Param1')

INSERT INTO #MyTestTable24Feb2012 VALUES ('Param2')

INSERT...

Martin Schoombee (2/24/2012)

---

stephen99999 (2/24/2012)

---

Would the SSIS for-each loop be faster (theoretically) ?

as for the 2nd sproc (xsp_run_sproc2), it accepts the parameter @value, gathers data from various tables based...

Martin Schoombee (2/24/2012)

---

It's a little difficult to say, because we don't know exactly what that second proc is doing...but my somewhat generic advice would be the following:

I would re-write the...

fahey.jonathan (2/24/2012)

---

It seems to me that what you are doing is an itterative, sequential process, and a CURSOR is an appropriate way to solve the problem.

I don't know...

That is exactly what I thought. Thanks...

MarkusB (1/31/2012)

---

In your BIDS project choose a existing report and select the original rdl file. After...

As a jr. SQL dev, I had never gotten the chance to use some of the redgate tools. Earlier this month I checked out SQL Search (http://bit.ly/e6JRtf), and wow, just...

No, Steve you hit the nail on the head. I left out any details only to get a overall perspective from you guys on the topic.

I am Jr SQL...

Thanks Steve. Would you happen to have any links (you suggest) on managing/developing a DB that has calls from 2 or more applications?

1 app is for administrative (reporting, oversight, management), while the other is for end users (data entry, update, etc).

For the purpose of the question though, lets just say we...

Well we have 2 different .net applications due to the difference between users and business requirements. However, the data is the same for both.

My immediate thoughts on this would be...

Looks like it might be. I watched the intro video and read the description, and they say it shows all objects. Does this include stored procedures and functions?

Also, I saw...

@TravisDBA

You are such a downer dude... lol

PERCENTILE_CONT / PERCENTILE_DISC

Lets recall from statistics that continuous variables (PERCENTILE_CONT) are those that "cannot not be exactly counted," while discrete variables (PERCENTILE_DISC) "have an exact amount."

PERCENTILE_CONT would be better...

Dave Ballantyne (1/18/2012)

---

The one-to-many is a more normalized view of the data and would be more 'correct'. But , you could argue that the CSV route could be right...