I'd have to go with encryption at a level higher than the DB in most cases, hopefully all the way from the presentation layer back. That way, you're not...

select CONVERT(VARCHAR(10),METER_DATA_TIMESTAMP,112) as Date,

AVG(meter_data_value) as KWAVG,

Max(METER_DATA_VALUE) AS KWMAX,

Min(METER_DATA_VALUE) AS...

There are plenty of tools that can be useful to a database administrator, even if you're not also a T-SQL dev, or whatever else. Redgate has an ad at...

Having columns from the second table in the Where clause effectively turns an outer join into an inner. Move that part to the Join, instead of the Where, and...

You'll have to set up the regular user account to access the server. If I'm understanding your post correctly.

So will most numbers. If you have to protect against...

As an addendum, zip-codes.com and usps.com have all kinds of data and tools for Zip code lookup, rules on Zip codes, etc.

Jeff Moden (1/22/2009)

---

ALZDBA (1/22/2009)

---

Jeff Moden (1/21/2009)

---

... simple question... "Using a SELECT statement, how do you return the current system date and time as part of the return in either?" ...

Get rid of the conversion inside the IsDate. That'll give you errors.

Zip-code prefixes are state-specific. Can't span states. Lots of them span counties, but they don't span states. Even cities that span state-lines, have different Zip codes the...

In that (semi-valid) test, the sub-query definitely won.

I'd still go with a single job. Add a step in between that checks the end-time of step 3 (currently job 3), and continues to step 4 depending on...

On the subject of risk coming from not knowing what you're doing, I'll have to go with "it depends" on that one.

Yes, not knowing what you're doing definitely increases risk....

I have to disagree with the comment about not involving users in usability design. I've seen both ends of that spectrum, and the one that involved users a lot...

The way I usually do that is to put the steps for the dependent jobs into the first job and set the "On Success" and "On Failure" characteristics to get...