Hi,

I typed the error code into google and got this information from support.microsoft.com

"DESCRIPTION: Error: 7105, Severity: 22, State: 6 Page (1:3507395), slot 5 for text, ntext, or image node does...

Hi,

If you take 50 million rows out of the table then I would suspect that the stats will need updating. The execution plan may even tell you that the stats...

Hi,

suggest you use a searched CASE statement

See BOL or

http://msdn2.microsoft.com/en-us/library/ms181765.aspx

Each column can be a separate case statement

SELECT

CASE WHEN <condition1> THEN <value> ELSE NULL END,

CASE WHEN <condition2> THEN <value> ELSE NULL END

......

I think a bracket has been misplaced somehow, you had four arguments in DateAdd(). I also added a space at the front of the ' 07:00:00'

...

 convert(datetime,convert(varchar(10),dateadd(dd,-1,getdate()),101)+ ' 07:00:00')

David

Ok,

My logic was that if there was a gap in employment, then the end date of the previous employment period must be less than the start of the next employment period....

Hi

If you search for parameter query in the Microsoft Excel Help you should be able to find the information you need. Here is the information I found in Excel 2003...

An interesting error message nonetheless, because in SS2K you can't use really useful system functions like getdate() from within a UDF.

...even more annoying, you can't even pass getdate() into a...

I remember a long time ago, sitting next to a DBA 'guru', flown in specially from Frankfurt, who was setting up a view for a enterprise systems management system I was...

There are schemas in a limited form in SQL Server 2000. Seem to be a way to create objects and grant permissions in a single logical transaction...

BOL says

"CREATE SCHEMA provides a...

Knowing nothing about how schemas in SQL 2K, I guessed you would get a syntax error, wrongly as it turned out. But when I tried the script, it turned out...

Hi,

you could use a searched case function to check whether there was a space in the contact1.contact field. If there was no space you could either set contact2.uexfield1 to the entire contact1.contact field...

Well I learned something...

I tried comparing the results of the following in QA:

SELECT LEN('      ')  returns 0 (all blanks are trimmed from the expression)

SELECT DATALENGTH('      ') returns 6   (6 blanks)

SELECT...

Hi,

do you have a MAPI client (e.g. outlook)installed on the server. Try logging in as the account which runs the SQL Server Agent and opening the MAPI client to see...

Hi,

If my understanding is correct, Table 3 is effectively a CROSS JOIN or cartesian between Table 4 and selected rows from Table 1. You could do this with a VIEW, without...

Steve,

be sure your SINs will find you out.

Or are you just being obtuse?

David