I assume that the result set returned by the stored proc is the same as far as number of columns/data types, etc?

If so, you may want to create a temporary...

John Rowan (11/3/2009)

---

Each task in the control flow waits for the previous task to complete. If you have 2 precedence constraints leading into a task, it will wait for...

Actually, not quite enough information. How is the data actually stored in the table, is the column defined as a datetime data type?

If you are looking at table partitions I have to ask, are you running SQL Server 2005 Enterprise Edition or Standard Edition?

Partitioned tables and indexes are only supported in the...

No, no, no. GSquared said to multiply by 1.0 not by 1 as you did. There is a difference.

Example: select 1 / 2 returns 0 where as...

I would want to keep the SQL Server backups to local disk and have the Network Admin backup those files to tape. Plus, if you keep tow or three...

No clue. I haven't run into this problem and neither have any of my coworkers so far either.

I'm interested if you should learn more about this problem.

Not sure as the following works just as I would expect:

select 'A' + ' & ' + 'B'

Not having had to do this, it does look like you may need to build the transfer package dynamically. I'd be interested in seeing how you accomplish this task.

I don't remember the details as I haven't been there for over 4 years. We are looking at setting email alerts here to go to our cell phones. ...

sextonk (11/3/2009)

---

(I am not on SQL 2005)

Here is the real query.....I got it to work but I guess the requirement is that I need the

First Blood Pressure/Response value taken...

PiMané (11/3/2009)

---

@Lynn Pettis

The data files, along with the system databases (data and log), are on a RAID10.

The log files are on a RAID1 and tempdb has a RAID1 of it's...

Run the following:

select * from msdb.dbo.restorehistory

People still have pagers??

If you already have the pager(s) check with the company and see if you can send email alerts via them. Many years ago at another company...

Totally forgot about those posts. Sad thing, they weren't that long ago. 😉