Remove the parenthesis from the group by.

See Books On Line for more info on group by clause

/Kenneth

Restore your latest known good backup?

There is a backup, right..?

/Kenneth

It depends.

Filgroups is a three-edged sword (as the Vorlon say)

They may have some effect on performance, but mostly they have an effect on...

I may be missing something here entirely, but AFAIK SQL Server has no clue about the time - it's the o/s that runs the clock. (meaning that it's Windows that...

On that department, unfortunately I have no clue.

(XML studying is still on the 'to do' list)

=;o)

/Kenneth

How do you know it's only 256 chars that gets into the table?

Have you tried a 'SELECT DATALENGTH(filecontent) from #tempf' ?

Remember that many tools used for viewing data has a...

To conclude...the code for selecting the records I am more than happy with...the problem I have is that the output is in many 'recordsets' and I only want one returned...

This...

Which one is correct way and faster, and what is the internal datetime format for sqlserver “yyyy-mm-dd”

Or “dd-mm-yyyy”

Actually, it's none of these - the internal format is not readable...

Could it be this?

http://support.microsoft.com/default.aspx?scid=kb;en-us;315005&Product=sql

/Kenneth

This will depend on the columns datatypes within the case.

Be aware that a CASE can only return one datatype - which one (if no casting is done) is decided upon...

True on both counts

I guess it's like post-it's - they tend to get lost in the overall-mess that's my desk. (the links that...

At the end of the day, the important thing is that the stuff works like intended. (and that's why you need to define how it's supposed to work before implementing...

I knew you had Erland's link (and I didn't) so I didn't mention it.

/Kenneth

Well, as you've probably noticed, it's very hard to model if all details are not crystal clear about the things you try to model.

I see some discrepancies here, though.

So, if...

Just be aware that using dynamic SQL will not reuse cached queryplans, the user needs permissions on the basetable itslef, and as written opens you up for injection attacks.

Dynamic SQL...