Generate Data into a table

without using a loop

Hello all

I have been asked by a co-worker for an answer to the following question.

"How can I efficiently generate a set of around...

This is a guess, but is Outlook installed on the server? And if so, is it configured correctly?

Dave

Lynn Pettis (1/27/2009)

---

I am sure this is in response to the following:

I received a private message with a...

🙂 You'll like this

Hugo's Tally Method first, my hopeless loop second.

[font="Courier New"]

CPU Reads Writes Duration ...

Excellent. 😀

I particularly like the date formatting trick. Why didn't I think of that! :w00t:

Many thanks Hugo. I'll run the extract later today and post some stats on...

Ok, I'm trying to use the tally as a loop.

The problem. In one of our databases we use a table to store among other things a reference (DocumentId) to...

No problem 😀

Here is another handy macro that demonstrates formatting, and tells you the numbers Excel uses for colours as...

divison (11/5/2008)

---

The article was interesting, and the conversation it spawned:

...

And I can see it would be useful, for me, to be able to do this kind of Excel formatting from...

Nice Macro. 🙂

The only thing I'd add to the Sub ColorAlternateDataRows is this line at the start

Application.ScreenUpdating = False

And at the end

Application.ScreenUpdating = True

Then it runs much quicker

HTH

Dave J

john.steinbeck (11/3/2008)

---

I can never start the darn thing (lol) cause the Stored Procedure I want to debug doesn't have any parameters to pass in...

I couldn't find anything to tell...

Anoop, from BOL

Starting the Debugger

T-SQL Debugger can only be run from within SQL Query Analyzer. Once started, the debugging interface occupies a window within that application.

Starting the debugger

There are two...

Anoop

try running

GRANT EXECUTE ON [dbo].[sp_sdidebug] TO [public]

GO

in your master db.

HTH

Dave J

This is written for, and tested on SQL 2000 I'm afraid. I do not have 2005 so I can't help you there. I assume the xp_sendmail parameters have...

If you can create a function, you remove the need for a loop, or a tally substitute.

Actually, I created two, append 2 to one of them

CREATE FUNCTION fn_ReturnDiagnosisies

(@p1 varchar(8000))

RETURNS...

I agree completely. I said "Again, all of the backup files need to be elsewhere too.", meaning NOT on the DB server. 😛

Here I backup to file...