You can find some useful date routines here: http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/.

You may want to look at the code behind the procedure and see if you can use it to capture the information you need to a set of tables.

Unfortunately, that only captures the first result set. Not sure how to capture the rest of them.

here:

SELECT IDENTITY(INT,1,1) AS RowNum, *

INTO #MyFiles

FROM OPENROWSET('SQLOLEDB','Server=yourserver;Trusted_Connection=Yes;Database=YourDatabase',

...

There is a way, using OPENQUERY. I just...

Lynn Pettis (5/16/2012)

---

halifaxdal (5/16/2012)

---

I know this is weird, just couldn't think of a possible reason, please help. Thanks.

I have a sp, which will create a temp table and the temp...

If you know the data in the TEXT column is not longer than 2000 characters, sure. You change it to varchar(max) instead.

marclas (5/16/2012)

---

hi,

i have this sql proc

CREATE PROCEDURE dbo.ListeLettreFichier

-- Add the parameters for the stored procedure here

@DateDebut datetime,

@DateFin datetime

AS

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering with...

halifaxdal (5/16/2012)

---

I know this is weird, just couldn't think of a possible reason, please help. Thanks.

I have a sp, which will create a temp table and the temp table's columns...

CELKO (5/16/2012)

---

>> .. not really trying to understand what the OP's problem is and try to actually help solve the problem. <<

Unh? I am the guy who tries...

If you don't have the media, you aren't going to be able to install another instance. There is no "clone this instance" command to create another instance of MS...

capn.hector (5/16/2012)

---

mtassin (5/16/2012)

---

Brandie Tarvin (5/16/2012)

---

Okay, now you've peaked my interest. How do you do the help entry? Does it just do a PRINT? Or a SELECT? Or is there some...

The same way you installed the default instance only this time you give it a name.

Yes, you can.

Antagonist