Lynn Pettis (4/29/2009)

---

Roy Ernest (4/29/2009)

---

I am reaching that magic figure of 1000. But that does not mean I know anything. But I try to learn from reading the solutions to...

Gail - can you give a good answer to this? I kinda thought along these line also.

http://www.sqlservercentral.com/Forums/Topic707743-338-1.aspx

You can always put your code up here as an attachment to a post.

There's an article coming out soon (ask Steve, not me, when that will be) that will tell you everything that you need to know in comparing table variables to temporary...

FYI, I just did a small test. I took one of the procedures that I mentioned in another post, you know, the one that has 3 selects, each with 32...

This ended up being more complex that I thought when I first jumped into it. Lot's of conditions to check for. It can probably be improved upon, but... it's working.

How's this?

-- first build a small numbers table

declare @Numbers TABLE (Number int PRIMARY KEY CLUSTERED)

;with CTE AS

(

select ROW_NUMBER() OVER (ORDER BY c1.OBJECT_ID) RowNumber

from sys.columns c1, sys.columns c2

)

insert...

swathi.g (4/30/2009)

---

Please observe thelast record inserted in temployee_leave_application.

The From_DT value is 04/30/2009

and TO_DT Value in 02/05/2009

It means that Total Number of leaves in April will be 2

and for may it...

Well, I don't know what to tell you. This is the method that I use, and the log files from the jobs do contain the output from the procedure. From...

Hmmm. In...

Anil Kumar Kurra (4/29/2009)

---

Hi All,

I am having a Stored Procedure Or SQL Script to be attached to Job Scheduler. When this Stored procedure executes it generates some...

John Deupree (4/29/2009)

---

What I need to know is how many days each consumer was active between 2 dates. Note that you can go from inactive back to active and...

We'd...

Hey Roy! Great article.

What happens if a stored procedure is called with the schema qualifier, BUT inside the stored procedure calls to tables aren't schema qualified?

ie.

CREATE PROC dbo.TEST1 As

select *...

Nothing about the databases or the servers the database is on was changed.