Viewing 15 posts - 49,936 through 49,950 (of 59,078 total)
Matt Miller (6/17/2008)
Take a look at this article - will help describe the technique....
Man... you're right... you have been recommending this and the Tally table articles a lot! I'm...
June 17, 2008 at 7:55 pm
Dupe post... please continue at the following so all the answers stay in the same place...
http://www.sqlservercentral.com/Forums/Topic518657-149-1.aspx
June 17, 2008 at 7:52 pm
real_cals (6/17/2008)
Paraphrasing Neal Stephenson - "A well built machine-gun will not help you change a flat tyre".
No... but I'll bet you can coax someone into doing for you with it....
June 17, 2008 at 7:47 pm
bitbucket (6/15/2008)
Knowing Jeff Moden's skill I strongly recommend you follow his suggestion on the use of a Tally Table.
Sorry... I almost missed this entirely... thanks for the great compliment! 🙂
June 17, 2008 at 7:43 pm
ahmeterispaha (6/17/2008)
I guess I'm looking for feedback on how people manage this kind of customization in a tightly controlled ERP environment.Thanks again.
Ahmet
As some others have already pointed out, including yourself,...
June 17, 2008 at 7:40 pm
ahmeterispaha (6/17/2008)
Can someone post a code sample that shows a query working with two databases simultaneously?
Sure...
SELECT t1.*, t2.*
FROM DatabaseOne.dbo.SomeTable1 t1
INNER JOIN DatabaseTwo.dbo.SomeTable2 t2
...
June 17, 2008 at 7:30 pm
Just in case anyone is having a doubt...
SELECT d.Amount, ROUND(d.Amount/5, 2)*5 AS Rounded
FROM (SELECT N/100.0 AS Amount FROM TALLY)d
Nicely done, Sergiy. Ya just gotta love...
June 17, 2008 at 7:22 pm
Heh... c'mon folks... if you know one of the images is correct, who cares about the other one? It takes longer to see if they're the same or not...
June 17, 2008 at 7:08 pm
david (6/17/2008)
Anyone have an easy solution?
Yes I do... please see the following... tells you not only how to do it, but how to do it right... 😀
June 17, 2008 at 7:01 pm
Sergiy (6/17/2008)
Matt Miller (6/17/2008)
Corollary to rule #1: Try not to be that operator....:D
Quality of some programs makes you wish to be the one.
Kinda funny you should say that... I'm going...
June 17, 2008 at 6:58 pm
I made my own career path and I wear many hats including DBA, Developer, ETL monster, performance monger, developer mentor, reality checker, etc, etc. If your new job will...
June 17, 2008 at 6:34 pm
p.s. When you do find out, be sure to post the answer... inputs are welcome 😉
June 17, 2008 at 6:14 pm
karthikeyan (6/16/2008)
what is the limitation of AND's and OR's in Sqlserver,sybase,mysql and oracle ?
How to know the maximum level ?
Is there any option to change the level to user...
June 17, 2008 at 6:13 pm
How strange... I did it with a million rows...
Scenario 1 = 36 seconds.
Scenario 2 = 8 seconds.
Here's the million rows of data...
--===== Create and populate a 1,000,000 row test...
June 17, 2008 at 6:01 pm
It is NOT an Oracle question... it is a general question concerning backups. A hot backup occurs on something that is currently being used by users. A cold...
June 17, 2008 at 1:10 pm
Viewing 15 posts - 49,936 through 49,950 (of 59,078 total)