ChrisM@Work

Forum Replies Created

Viewing 15 posts - 10,096 through 10,110 (of 10,143 total)

RE: Update query

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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

July 3, 2007 at 4:36 am

#716819
RE: Autoincrement Field for Multi-company database

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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

July 3, 2007 at 4:21 am

#716816
RE: Dead Lock

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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

July 3, 2007 at 4:06 am

#716812
RE: Query Where the "WHERE" clause is in multiple rows

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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

July 2, 2007 at 10:34 am

#716592
RE: Query Where the "WHERE" clause is in multiple rows

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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

July 2, 2007 at 9:40 am

#716568
RE: Combining two rows into one

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.
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

July 2, 2007 at 7:19 am

#716523
RE: Workplace Sabatoge or Incompetance. . .

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.
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 30, 2007 at 1:11 am

#716354
RE: Combining two rows into one

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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 29, 2007 at 8:52 am

#716218
RE: Combining two rows into one

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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 29, 2007 at 7:21 am

#716165
RE: Round to Even (aka Banker''''s Rounding) - The final function

Blimey Cath, that's a real gem! Good find!
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 29, 2007 at 2:25 am

#716093
RE: Inconsistancy with Importing from Excel using OpenRowSet

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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 28, 2007 at 7:23 am

#715840
RE: Round to Even (aka Banker''''s Rounding) - The final function

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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 28, 2007 at 5:46 am

#715811
RE: Combining two rows into one
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)...
```
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
June 28, 2007 at 4:47 am

#715799
RE: Inconsistancy with Importing from Excel using OpenRowSet

Hi Scott
I'm working with SQL2K and importing from Excel files using server linking, however I get a similar error message...
Server: Msg 7399, Level 16, State 1, Line 3
OLE DB provider...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 28, 2007 at 3:50 am

#715788
RE: empty DB columns are not ''''NOT NULL'''' so search for not null fails

You give me way too much credit Mr Moden, and on a wednesday too, when I get to work from home
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 27, 2007 at 7:58 am

#715542

Viewing 15 posts - 10,096 through 10,110 (of 10,143 total)