Viewing 15 posts - 4,216 through 4,230 (of 5,685 total)
drew.allen (1/31/2011)
Craig Farrell (1/31/2011)
After having done some other tests, this method seems to be the quickest, especially if you have a solid index on Item/ChangePriceDate
My tests indicate the opposite. ...
January 31, 2011 at 2:06 pm
I personally would actually approach this from SSIS, though there are varying discussions on that.
For SSIS, you'd multi-cast and do a number of twists on the datastream including conditional splits...
January 31, 2011 at 1:37 pm
Melanie Peterson (1/31/2011)
Also - I should've noted that the server where this sp resides is 2005, but REMSServer is...
January 31, 2011 at 1:31 pm
After having done some other tests, this method seems to be the quickest, especially if you have a solid index on Item/ChangePriceDate
SELECT
mt.Item,
mt.UnitPrice,
mt.ChangeDate
FROM
#myTable AS mt
JOIN
(select
Item,
MAX( ChangeDate) AS MaxDate
FROM
#mytable
group by
Item
) AS drv
ON
mt.ChangeDate...
January 31, 2011 at 1:28 pm
Date is today.
0 is 1/1/1900, it's just a baseline number. It would appear they're trying to do time/month component strips.
For example, if I want the first day of this...
January 31, 2011 at 1:22 pm
Melanie Peterson (1/31/2011)
January 31, 2011 at 1:19 pm
I believe this article is what you were looking for:
http://www.sqlservercentral.com/articles/FOR+XML+PATH/70203/
Search only articles here, and use the search string: For XML delimited string
January 31, 2011 at 1:04 pm
When an application installs Express, it usually is expecting complete control over the server itself. They're coding it for non-IT people to be able to use the product and...
January 31, 2011 at 12:24 pm
theBorch (1/31/2011)
Sadly the consultant touted his years of experience with the software, which is what in turn...
January 31, 2011 at 12:19 pm
sjimmo (1/31/2011)
I agree with everything that you said, but many times when pushed these vendors can use dbo access. They prefer SA because it is easier for them. I have...
January 31, 2011 at 12:17 pm
WayneS (1/31/2011)
Starting a new job today... I get to use whatever tools I want. I've used ERwin and PowerDesigner in the past. IMHO, ERwin...
January 31, 2011 at 12:11 pm
theBorch (1/31/2011)
This consultant was clueless when asked what permissions he needed to complete the...
January 31, 2011 at 12:01 pm
Brandie Tarvin (1/31/2011)
GilaMonster (1/31/2011)
Brandie Tarvin (1/31/2011)
If the poster said that, I don't blame you for slapping down. The question is, how diplomatic were you?
He was pretty diplomatic about it. Far...
January 31, 2011 at 11:15 am
scorpianprince (1/30/2011)
I have a job to kill all the sleeping connections to my server, now i want to give access to this job to one of my user how...
January 30, 2011 at 5:03 pm
Yes, because you have one table with two foreign keys.
Now, be careful here. If you cascade delete/update both those keys, any change in either table will affect the center...
January 30, 2011 at 1:08 am
Viewing 15 posts - 4,216 through 4,230 (of 5,685 total)