Viewing 15 posts - 226 through 240 (of 851 total)
[font="Verdana"]I guess the issue is with not wanting to round the decimal places. Sadly, even using the various formatting options in SQL Server Reporting Services will round (I think.)
So...
May 20, 2009 at 2:03 pm
jcrawf02 (5/20/2009)
Fire the 1st guy and find max(salary) . . . 😛
[font="Verdana"]Pay everyone the same. :-P[/font]
May 20, 2009 at 1:57 pm
Tara (5/19/2009)
I am trying to do something like thisINSERT into OBBR.Emp.dbo.Revcounts
(col1,col2,dbname)
SELECT
col1,col2,server-db
FROM #temp
In the column dbname i would like to have server.dbname and i am doing this way...
(@@servername+db_name())
[font="Verdana"]Something like (@@servername+','+db_name())...
May 19, 2009 at 8:56 pm
[font="Verdana"]For servername, use @@servername, and for database name, use db_name(). For example:
select@@servername,
db_name();
[/font]
May 19, 2009 at 8:23 pm
[font="Verdana"]Excel can treat a range of cells like it is a table. SQL Server has (inherently) tables. So you don't have to pretend that a range is a...
May 19, 2009 at 2:34 pm
[font="Verdana"]Start with the Kimball methodologies (as recommended above.) He has an excellent web site and another book that are well worth reading.
When you come to tool sets, if you...
May 19, 2009 at 2:15 pm
[font="Verdana"]I can't see how it can implement any kind of ranking without a sort.
My issue with the ranking functions is in how they are defined. I mean, if you...
May 18, 2009 at 4:34 pm
Bob Hovious (5/18/2009)
Mr. Wilbur said RANK()rank() over (partition by s.objtype order by (s.usecounts) desc) as UCRank
[font="Verdana"]Erk. He did too!
Okay, key difference is this:
SQL Server Books Online
May 18, 2009 at 4:17 pm
Bob Hovious (5/15/2009)
Also, I don't believe that CROSS APPLY will always do a subquery per row. The optimizer may surprise...
May 18, 2009 at 3:19 pm
[font="Verdana"]One system reaching in and injecting data into the tables of another system is the data equivalent to code in one system reaching into the middle of the code in...
May 17, 2009 at 10:11 pm
GilaMonster (5/17/2009)
Steve Jones - Editor (5/17/2009)
Good to hear you play baseball down under.
South Africa is not Down Under. That term refers to the rather large continent somewhere to the east...
May 17, 2009 at 9:56 pm
TomYum (5/14/2009)
select
sum(case when loan.amount < 15000 then...
May 14, 2009 at 11:24 pm
Lynn Pettis (5/14/2009)
Must remain in the desert, must remain in the desert...
[font="Verdana"]Now there's your problem right there. You need another S in that desert.[/font]
May 14, 2009 at 11:06 pm
Bob Hovious (5/14/2009)
Or maybe...
[font="Verdana"]I thought of that approach too (I have introduced my team to the joys of CROSS APPLY, thank you Bob!) But I suspect the straight ranking...
May 14, 2009 at 11:05 pm
Bob Hovious (5/14/2009)
Hey Bruce and Paul... how is life in New Zealand? Where do you each live again?Bruce, you're on the North Island (Auckland?) right?
[font="Verdana"]I'm...
May 14, 2009 at 11:04 pm
Viewing 15 posts - 226 through 240 (of 851 total)