I think you're having a problem concatenating the % wildcard and the @Query variable.

Try something like this: AND sdest.[text] LIKE ''%' + @Query + '%''

HTH

You might get better response for this question in the SQL Server 2008 forums.

It might also help to know what collation you're using.

That is sweet. I love the way it trims out the time as well because the '0' date started at midnight. So this trick will work with any...

What do you do if the month is January?

I usually do something like this:

DECLARE @now datetime

SET @now = CONVERT(datetime, CONVERT(char(8), GETDATE(), 112), 112)

SELECTDATEADD( dd, -1 * DATEPART( dd, @now), @now )

HTH

Something like this?

CREATE TABLE [dbo].[#Tickets](

[Ticket_ID] [char](8) NULL,

[StartTime] [datetime] NULL,

...

Nice work, Jeff. Particularly the discussion of the potential gotchas in the choice of the "unlikely" character. It never would have occured to me that using something like...

Thanks, Lutz.

That was careless of me. Any time you're using a CASE statement, it should explicitly deal with each possible case, and I obviuosly didn't.

It's not really any prettier:

UPDATE PURC_ORDER_LINE

SET USER_ORDER_QTY = CASE

...

I may have misunderstood what you were looking for.

This should get you the first four rows you wanted. The derived table x will include distinct copies of...

Have you asked the sa for rights to OpenRowSet?

I'd love to be able to do this too. However, I've yet to find a reliable way to do it. I've tried fn_get_sql and the dynamic management views...

From BOL:

ERRORFILE = 'file_name'

Specifies the file used to collect rows that have formatting errors and cannot be converted to an OLE DB rowset. These rows are copied into this...

You can also use BULK INSERT from within a stored procedure or query without having to use xp_cmdshell.