Hi Amit,

I'm a bit confused.

If 1 doesn't have a parent, why does it have a parent in the XML you've written? Did you...

Well, okay, I've done it now (I couldn't resist! ). You can pay me next time

Scott,

Your problem is very difficult to get to grips with - not because it's that tricky, but because of the way you've expressed it.

I'm guessing you're using the LIKE clause and need to use ESCAPE...

DECLARE @t TABLE (v VARCHAR(100))

INSERT INTO @t

      SELECT 'abc'

UNION SELECT 'a[c'

Good point Kevin - I missed that was a requirement.

Thanks

I guess I can just add it...

Read up on 'Full-Text Search' in books online

Once it's set up, you can do things like...

WHERE CONTAINS(LastName, '...

Well, anyway, here's an alternative to Kevin's solution...

It seems to run marginally faster, but nothing too significant, on my tests, so I guess you'll...

Hi all,

I love problems like this - please keep them coming!

bug, can I just clarify something? You said consecutive days, but then...

Good work noeld! Where were you for the other thread?

noeld has come up with a solution in this similar thread...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=264524

Did you read the whole thread?

The upshot was that it's not possible...

I remember this one from before

See this thread:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=250528

Thanks for the update, and thanks for using the work "shlog". Made me smile

Hi James,

Is something like this what you're looking for?

--This SQL script is safe to run

DECLARE @Itinerary TABLE (BookingNo INT, TicketID INT, FromId...

Hi Ryan,

Firstly, good name

Secondly, isn't this in the wrong forum? Unless I'm mistaken SSIS is new for SQL Server 2005, and this forum...