I guess I don't understand what you're asking.

What type of data does your "ontime" column contain? What does the sum of it look like?

sturner (11/4/2010)

---

You might want to consider database mail as a way of sending faxes. You have a lot of flexibility, even passing a query to the senddbmail method. It...

Something like this:

CREATE TABLE #T (

ID INT IDENTITY PRIMARY KEY,

RawVal VARCHAR(10),

CalcVal FLOAT);

DECLARE @String VARCHAR(10), @Cmd VARCHAR(1000);

SELECT @String = '10*5';

SELECT @Cmd = 'insert into #T select ''' + @String + ''',...

A CLR proc called by an outer proc has access to temp tables created in the calling proc, just like any other subproc does.

Or run the query in the CLR...

I guess it depends on what you want to do. Are you just looking for making the password expire after a certain amount of time, or for password complexity,...

Don't do anything that involves splitting the unit up. You're going to end up with headaches later from rounding issues. And any sort of inventory control/tracking becomes problematic....

From what I understand (could easily be wrong), OpenQuery can't do anything a linked server connection can't do. It's just a little more ad hoc than those are. ...

Enabling password policy in SQL Server, unless I'm badly mistaken, makes SQL Server use the policies from Active Directory (Windows security).

DECLARE

@SDateTime DATETIME,

@EDateTime DATETIME ;

SELECT

@SDateTime = '11/4/10',

@EDateTime = GETDATE() ;

;

WITH Numbers(Number)

...

Use Jason's (Cirque's) solution. That filters it the right way for that kind of thing.

Leo.Miller (11/4/2010)

---

Lowell (11/4/2010)

---

maybe he was doing a select * from BillionRowTable so he could see the column names, and the error threw him off.

He may not be familiar with sp_help...

Looks like it could be solved by explicitly selecting the string as part of a dynamic SQL statment.

Something like:

DECLARE @String VARCHAR(10), @Cmd VARCHAR(1000);

SELECT @String = '10*5';

SELECT @Cmd = 'select '...

Try sending it as a string, then converting it once shredded.

GilaMonster (11/4/2010)

---

The 'informal conversation' today (3rd time same issue) had the Project manager present,...

There is a Round() function. You should be able to wrap that around the Sum() function in your first query. Have you tried that?