Viewing 15 posts - 10,096 through 10,110 (of 10,144 total)
Yeah me too!
I saw a use for ...
UPDATE #MyHead
SET
@Grp = Grp = CASE WHEN
July 4, 2007 at 3:30 am
Someone far more clever than me will explain why you're having problems using a collation directive (?) in a remote query, in the meantime here's a workaround - change the...
July 3, 2007 at 7:24 am
Hi Nitin
If you're going to update some risky data then you would be well advised to check beforehand that everything will work - if you make...
July 3, 2007 at 4:36 am
Hi Goodguy
Just a thought: If I'm working on an order-processing system, I make sure that the order number (or whatever you want to call it) which is printed on the...
July 3, 2007 at 4:21 am
Interesting...I've been meaning to ask this for some time.
When querying a database for reporting purposes, I'll almost always use the NOLOCK clause (read uncommitted) because it's generally quicker, sometimes...
July 3, 2007 at 4:06 am
Hi David
That sounds practical to me. I haven't worked with XML transport files but SQL Server is equipped to deal with them - check out BOL, you may be able...
July 2, 2007 at 10:34 am
Hi David
I'd made a start on this before you posted up your sample data. Rather than start again I thought I'd post up what I've got. Essentially the only difference...
July 2, 2007 at 9:40 am
You're welcome. Zanzibar? Blimey! "I was in the middle of writing this really nasty sp when a warthog waddled past my window..."
Beats Surbiton, we only get parakeets.
July 2, 2007 at 7:19 am
Good luck finding your next contract, EM. You've put up with the bs for three months too long. Your next contract will be a breeze in comparison.
June 30, 2007 at 1:11 am
Hi goodguy
You need to check your arrival / departure dates in your sample data set to make sure that they don't cause double-bookings, also it looks like checkindate / checkout...
June 29, 2007 at 8:52 am
Hi goodguy, please can you set up your data as a series of INSERTs into a temp table (as in my first reply) so that I can exactly match your...
June 29, 2007 at 7:21 am
Blimey Cath, that's a real gem! Good find!
June 29, 2007 at 2:25 am
No worries mate, it was worth a try. I've also had this error if the file doesn't exist (someone sends it over with a typo in the name).
FYI here's...
June 28, 2007 at 7:23 am
Hi Cath
You're absolutely right on every point. It does however happen, and not only on this thread, where I would hope that a casual browser would see it as an...
June 28, 2007 at 5:46 am
Hi goodguy
Here's another way with some handy sample data.
--create some sample data SET DATEFORMAT DMY
DROP TABLE #ViewResult CREATE TABLE #ViewResult (roomname CHAR(4), Pax tinyint, GuestName VARCHAR(20), checkoutdate DATETIME, checkindate DATETIME, CLIENT VARCHAR(20)...
June 28, 2007 at 4:47 am
Viewing 15 posts - 10,096 through 10,110 (of 10,144 total)