Viewing 15 posts - 271 through 285 (of 621 total)
Thanks Seth, and you are exactly correct, I only want to insert with user and date info if the entire procedure runs error free. I can't get how to...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 22, 2009 at 12:25 pm
Jeff Moden (9/17/2009)
Another of those rules is that it must be a single table update. By that I mean, no joins... period.
That was going to be my next question....
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 17, 2009 at 10:52 pm
Ok, this might be a dumb question, but if I specify the physical order of the records on the insert, then why is the index so vital? If I...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 17, 2009 at 7:46 pm
Garadin the whole theory works off of using the clustered index to update the table. You *must* both create and specify this clustered index in the order that the...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 17, 2009 at 5:46 pm
Here's the link to the article I referenced. http://www.sqlservercentral.com/articles/Advanced+Querying/61716/. However, it seems to be under construction now, but I am fairly certain it described pretty well how the...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 17, 2009 at 3:18 pm
SQLMAIN, here is a temp table solution. It works by determining the previous ndt date for each record in the group, then keeping a running sum of the interval...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 17, 2009 at 1:44 pm
Garadin Both have advantages and disadvantages
Well I can see one, which is that mine is limited to only one year at a time. Other than that, yours is simply...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 16, 2009 at 9:54 am
Sherrina, not sure, but what happens if you replace your first sub query with this?
(SELECT a.name FROM agency a, ppcr_call_sheet pcs
WHERE a.agency_id=pcs.agency_id ) agency_name
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 16, 2009 at 8:19 am
Carla, the first thing I see is that unless your table only has one column, if you don't supply the column name into which you would like to insert the...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 16, 2009 at 8:09 am
Following up on what Seth said, you could try something like the below. However, you should note that the first week will start January 1, so if your first...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 16, 2009 at 7:56 am
shauhan13, does the letter portion of the location have any significance? If so, you could add a column to the location table to hold only the letters, which would...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 15, 2009 at 9:05 am
Then what happens when you try location >= 'A9' ?
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 14, 2009 at 12:48 pm
If you post your table structure and sample data, and your desired results based on your sample data, we will be able to help you more effectively.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 8, 2009 at 12:53 pm
Are you using Access as a front end?
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 3, 2009 at 12:11 pm
Gillian, take some time and read this...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
then try to ask your question again. Its hard to know how to help you without seeing your object/data structure, and the code...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
August 27, 2009 at 9:06 am
Viewing 15 posts - 271 through 285 (of 621 total)