sushila,

the message looks OK to me... the extra SELECT has no FROM, so it only allows for a single value/row (like SELECT 1), not entire rowset as selected from the query....

Our database is around 200 GB at the moment, and ever since the time when it is over 100 GB we use to reindex at least once a month, quite often...

I'm a bit confused... there seem to be two different things discussed here:

- passing a table as parameter into function - that is where you have problems

- output table as a result of...

As far as I know, there is no such function in SQLS 2000. Maybe this post should be in the 2005(Yukon) forum... and anyway,...

Neither one of the two values is precise, but actually a year is closer to 365.25 days than to 365. It is just that we are used to have years with...

"I need to create a simple idiot proof query that I can hand to someone without any SQL experience and have them run to change this value.  Any ideas would...

Well, I suppose the intention was to put some check before the create (IF NOT EXISTS... CREATE TABLE), so that the number of new tables wouldn't be as high and...

I would say that both previous answers are correct IN is easier to maintain than OR and performs well with not-too-high number of values,...

Looks nice, Ryan... that's about what I hoped to get together, but it is a lot easier than I thought it would be when written in a direct statement (without UDF). I...

SUBSTRING will work, but it will be more complicated, and will need CHARINDEX to calculate length. For the first 2 columns (C and D) it could be like that:

CREATE TABLE...

I hate the so-called daylight-saving time... It does not save anything, just forces you to reset your internal clock twice a year. IMHO it would be only to advantage of everybody...

bwild,

if Sergiy's solution does not work for you, it is probably because you didn't explain precisely what is the situation and what you need to do. What you described so...

You can create a date with zero time portion by using DATEADD(d, DATEDIFF(d, 0, @date), 0)  - instead of @date, enter your date that you need to modify... or directly...

Erwin,

is there any reason why 4 functions would be more useful than one? Or, when we are at that, more useful than no function?

If you're thinking about re-using the separate...

Hi,

IMHO if you're doing such reports on regular basis, you should have auxiliary tables (like table Dates containing all dates 20 years back and 30 years forward). In such table,...