Okay, it is a decimal value, how is it stored? Please provide a sample of the data.

I'm not sure what you are asking. Can you explain better what you are trying to accomplish.

True, which is why I would actually try the other way first.

Of course, the right way to do it is to rewrite the process as a set-based query.

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...