Wow thats some CTE :w00t:

I can't see anything obvious, and without the table structures and sample data, its difficult to help.

In ASP.NET I use the built-in sorting and paging facillities...

OK I've found the application I was thinking of and my solution was to remove the noise words before they got to SQL

In my case the VB front-end read...

Sorry I can't help you immediately but I've come across this before (using english) - a couple of years ago - I'll look at my archive stuff tonight and let...

I've been using this script for years - never had any problems with it. Run in the database you just restored - its very similar to the other solutions...

Found this on sqlDumbAss - http://sqldumbass.com/2008/01/09/turbo-button.aspx#Comment

/* Recruit a DBA */

-- Create the post

DECLARE @DBAPost TABLE (

[Name] varchar(50) Default 'Dave',

Qualifications INT NOT NULL,

HeadSize BigInt,

SocialSkills TinyInt )

-- and get the best...

If I run these statements I get zero and zero, etiher separately or as a batch.

If I add in the GO immediatly after the DECLARE, I still get zero and...

Jeff

Tried to PM you - but your PM mailbox is full.

I'm ready with my CLR - in fact I've...

I did use the + operator in the end

CREATE FUNCTION dbo.fn_ConcatBin(@pKey AS INT)

RETURNS VARBINARY(MAX)

AS

BEGIN

DECLARE @VAR varbinary(MAX);

SET @VAR = 0x;

SELECT @VAR = @VAR + convert(varbinary(max), fValue)

FROM pcvBlock AS B

WHERE B.fk_BlockRef =...

I randomly chose an answer, just to get at the answers to see which was right - but now I'm even more confused. :unsure:

Thanks GilaMonster, I've found out how to check a poster's timezone.

And I see you're in South Africa too - So its early summer there? which just reinforces how...

Stewart Bailey-Smith (11/28/2008)

---

I'm one of those wallfowers who just reads on this site (in fact this is my first post) but I've had the nagging feeling I should contribute to...

Yes, but you will still need the .NET command line compiler to create an assembly dll from your source.

But of course ChrisM's is more elegant 😉

You can't treat the Route column as both an int and a varchar

To get the sort right you can try this, it won't work for all situations but it...

I find a lot wrong with IE Beta 8 - my iGoogle is all wrong for a start.

I've tried to find a way to uninstall it - but can't

I now...