Hate to disappoint you, but the ethical standards of people...

Are you asking if the database admins should have access to the folders with the SQL executables? Or are you asking about Windows/domain admins?

By definition, if you don't supply an Order By clause in a query, SQL isn't obligated to return it in any particular order at all. It will often be...

I'll second the motion for a calendar table. Makes all of these things much easier to solve.

Beyond that, why not just add 1 to the day before you run...

Is it simple enough XML that you could have a computed column that stored it? Or an indexed view?

You can't change settings in a UDF. Will need to be a proc.

Take a look at the execution plan. SQL will usually turn a single-value In into an equality test. The only time it doesn't, that I know of, is...

You're welcome.

Not sure what you mean by "white space" in this context.

If you want to compare the data, RedGate has a tool for that. So does ApexSQL. They both...

See the thing at the top right corner of this website that says, "a community service from redgate"? Click on that. They're the ones who make SQL Prompt....

Declare a varchar variable for the recipient e-mail addresses, assign the values to it, use it when calling sp_send_dbmail.

declare @To varchar(max);

select @To = @EmployeeEmail + ';' + @ManagerEmail;

exec msdb..sp_send_dbmail @recipients...

The logic the old fashioned way is how you're currently doing it, with an ID and a ParentID. It's slower and requires more I/O proportionate to the number of...

Do you have a Numbers table? (Or Tally table, or whatever else you want to call it.)

If so, then you can use a string parsing query in a cross...

zeitiadaisy (11/2/2009)

---

How accurately can you read the buret? The calibration marks are probably 0.10 mL or 0.05 mL and you estimate the reading to the nearest 0.01 mL. You had...

First, how frequently does this data change? Multiple times per second? Every day? Every week? Every few months? Once a year or less?

If the answer...