Viewing 15 posts - 181 through 195 (of 628 total)
why did it error out using the full path? I have several packages that run using a full UNC name. That I beleive is your best bet....
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 12, 2011 at 12:16 pm
Here is one way to do it
select t.CarReg,t.orderNo,t.orderDate
from
(
select CarReg,orderNo,orderDate,row_number() OVER(PARTITION BY CarReg ORDER BY orderDate desc) as rowID
from #carRentals
)t
where t.rowID=1
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 12, 2011 at 10:34 am
Here is another thread that might shed some light.
http://www.sqlservercentral.com/Forums/Topic342925-149-1.aspx#bm343219
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 12, 2011 at 9:42 am
crookj (4/12/2011)
Daniel Bowlin (4/12/2011)
Ray K (4/12/2011)
GilaMonster (4/11/2011)
Darkness (as in, 'the city is in ... ')Hello, darkness, my old friend . . .
I've come to talk with you again
And the "vision"...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 12, 2011 at 9:22 am
I beleive they are refferring to two different things.
The Unified Programming Model of course should be easy enough to find information on whether you can get any two programmers to...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 12, 2011 at 8:05 am
Microsoft has a free lab you can donwload at the following link that you may find helpful.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 12, 2011 at 7:23 am
To quote a movie The wonderful thing about creation is it is such a distructive force. We will never fully be able to weigh the damage or gain that...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 11, 2011 at 2:49 pm
will every sale be unique based on Client ID?
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 11, 2011 at 1:33 pm
do you have a transaction ID that is a common link between the cancel and the sale. If so than this is rather easy. IF not then it...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 11, 2011 at 12:57 pm
What I have done in this type of case is use the Row_number function. group by you ID and sort the function by the cutoff date in desc order....
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 11, 2011 at 8:46 am
can you post the whole SP?
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 11, 2011 at 7:58 am
I was already with an answer when I got towards the end and you said "It's not stored in the table"
Are you saying the previous cutoff date is not stored...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 11, 2011 at 7:33 am
Use the ROW_NUMBER function for this. HEre is a link to the BOL page.
http://msdn.microsoft.com/en-us/library/ms186734.aspx
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 11, 2011 at 7:27 am
Not sure if this is what you are encountering but I ran into a problem similiar to yours and this was the cause.
The package we where dealing with...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 8, 2011 at 3:07 pm
I don't know how recommended this would be in large but I have even used the follwoing to mass update every job to have the owner set to sa.
update sysjobs...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 8, 2011 at 2:57 pm
Viewing 15 posts - 181 through 195 (of 628 total)