Viewing 15 posts - 52,471 through 52,485 (of 59,064 total)
ebuss_2004 (2/17/2008)
DECLARE
...
February 17, 2008 at 10:25 am
Oh yeah... for those in the know... yes, I used a triangular join in a correlated sub-query... performance will be terrible compared to the "UPDATE" method I wrote about, but...
February 17, 2008 at 10:22 am
Ta-da! See how much easier that is for folks to work with. Thanks for taking the time to help us help you...
Here's the solution including the test setup...
February 17, 2008 at 10:17 am
Now, we're cookin'... I'll be right back... 😉
February 17, 2008 at 9:54 am
Ok... here's some extraordinary proof that supports what Itzek said...
First, I made a table in a nice safe place... TempDB... couldn't use a actual temp table because I wanted...
February 17, 2008 at 9:49 am
Marios Philippopoulos (2/17/2008)
Another aspect of the IDENTITY property that can be considered a limitation...
February 17, 2008 at 9:13 am
Yeaah... I'm going to spend my time reformatting your data...
This is what your text file looks like...
SalesDate StockCode costPrice SalesPrice SalesAmount Total ----------------------- -------------------------------------------------- ----------- ----------- ----------- ----------- 2008-01-01 00:00:00...
February 17, 2008 at 9:03 am
How does one determine if a page split has occured during an update?
February 17, 2008 at 8:43 am
erdem (2/17/2008)
Thank you very much for your replies...At least, you replied this question 🙂My final data report should include just six columns:
StockCode
SalesPrice1
SalesPrice2
.
.
SalesPrice5
That's all..
But, you didn't read my previous reply... you've...
February 17, 2008 at 8:40 am
Hassie (2/17/2008)
Thanks alot - this did the job
You bet... Thanks for the feedback.
Just remember...if the count of rows for each group starts to grow, the performance will suffer greatly very...
February 17, 2008 at 8:32 am
Peso (2/17/2008)
Msg 208, Level 16, State 1, Line 1Invalid object name 'New.AddAnnex'.
Doh!... Thanks for the correction, Peter... that's what I get for late night posting. I'll correct that post...
February 17, 2008 at 8:24 am
Yes, I absolutely agree... any type of formatting should be done only in the GUI... if there is one...
But the keyword in the title of the thread is "Show"......
February 17, 2008 at 8:21 am
C'mon... I know you're in a pinch but stop and think about it... we don't know what your SalesDetails detail table looks like, we know nothing about the data in...
February 17, 2008 at 7:59 am
Oh... be careful, now... IsNumeric cannot be equated to IsAllDigits. IsNumeric will allow currency symbols, $, comma, decimal point, spaces, tabs, and a host of other individual characters. ...
February 16, 2008 at 11:10 pm
This was a pretty interesting question with no responses and I have no idea of what the answer might be... anyone got any idea on this, at all?
February 16, 2008 at 10:34 pm
Viewing 15 posts - 52,471 through 52,485 (of 59,064 total)