ChrisM@Work

Forum Replies Created

Viewing 15 posts - 10,051 through 10,065 (of 10,143 total)

RE: Complicated view

Hi Good guy, I understand the nature of the problem - please bear with me - we should be able to knock this one on the head very shortly. To...
^{“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 31, 2007 at 3:32 am

#723510
RE: Complicated view

Hi Goodguy, apologies for the delay, I'm on UK time - for reference this is posted at 09:35.
The previous post gave you the invoice side of things, now we need...
^{“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 31, 2007 at 2:33 am

#723494
RE: Complicated view

Hi Goodguy
Can you post the query you already have, to show the joins?
I'm sure this is do-able. You will almost certainly find it easier by packaging your tables into two...
^{“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 30, 2007 at 7:59 am

#723316
RE: How to find the childrens path of a given parent

Launch a missile? Good lord no...here's some pizza launched to say thanks for fixing holes in my dodgy code! Good luck with your new gaff.
Cheers
ChrisM
^{“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 29, 2007 at 11:24 am

#723194
RE: what is the wrong with this update

Almost, Amit, but not quite. Your query will generate 2 errors:
Server: Msg 107, Level 16, State 3, Line 1
The column prefix 'studentmaster' does not match with a table name or alias...
^{“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 27, 2007 at 4:45 am

#722813
RE: The Work Perks You wish to have

Steve - yes it is, thanks...sorry Brandie, day got busy.
My driving instructor has a really large cushion in his boot for Heather, who is I guess around 4 feet...
^{“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 26, 2007 at 2:39 pm

#722709
RE: Identifying gaps in numbering sequence of a table

Hi Dan
Instructions for creating a numbers table exist on the forum, e.g. see posts by Jeff Moden.
Left-join your vendors table against a numbers table and use a WHERE clause, like this:
SELECT 'v9' +...
^{“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 26, 2007 at 5:40 am

#722527
RE: The Work Perks You wish to have

Ouch! Self-inflicted, no sympathy. Anyway, hitting my knee with your fist probably hurt you more than it hurt me!
Seriously though, it matters a lot, and I'm appalled you didn't get...
^{“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 26, 2007 at 5:24 am

#722524
RE: The Work Perks You wish to have

<<lower the desk for me>> <<feet dangling off the floor>> heh heh you're kidding right Brandie? Can't you use a cushion? Have you tried sitting on the desk 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 26, 2007 at 5:03 am

#722521
RE: Order Database Design

<<What if I order the same item twice, but manage to have each item listed seperately on the order (if possible)? >>
I've had to code for this in the past, in...
^{“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 24, 2007 at 9:35 am

#721969
RE: Order Database Design

Reckon most of the important points are covered here, but it's also worth pointing out that it's easy to get confused between business entities and database structure entities, and if...
^{“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 20, 2007 at 3:47 am

#721035
RE: loading of .csv files into sql server

Spot on, Jeff, and apologies to you, Surya.
^{“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 20, 2007 at 1:11 am

#721017
RE: loading of .csv files into sql server

Ok, fourth and last try, after this I'm giving up. Surya, please, open the file in a text editor and post the first three or so lines. This will show...
^{“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 19, 2007 at 1:41 pm

#720900
RE: A Cool Perk

Katie, something which may help is a fixed-leg chair i.e. one with four legs and no castors. It's very different sitting on one of these as opposed to the 5-leg...
^{“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 19, 2007 at 6:10 am

#720703
RE: loading of .csv files into sql server

Hi Surya
It would sure help us all if you could post the first few lines of your file 'surya.csv', opened with Notepad...

Cheers
ChrisM
^{“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 18, 2007 at 5:27 am

#720325

Viewing 15 posts - 10,051 through 10,065 (of 10,143 total)