Viewing 15 posts - 61 through 75 (of 621 total)
alex, I think e4d4's suggestion is probably your best (and maybe only) option. Once you set up the linked servers, you can query against them like this...
SELECT a.<column_list>, b.<column_list>
...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 4, 2013 at 1:20 pm
dwain.c (1/3/2013) Given the power of SAS, if you can ever make it work it sounds like the makings of a great article!
Indeed, I believe it would be. I...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 4, 2013 at 3:59 am
dwain.c (1/3/2013) I believe that was intended to be the "royal" we.
Oh my goodness, Dwain. We laughed hard when we read that one.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 4, 2013 at 3:50 am
cs_source (1/3/2013)
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 3, 2013 at 6:47 pm
I'm not really sure what you are trying to do, but how can 'Nothing' be a result of doing calculations on columns with not null constraints?
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 3, 2013 at 12:46 pm
cs_source (1/3/2013) If you like i can post the SAS code? 🙂
Not the code for percentile, but if you can figure out a way to use OPENROWSET with the SAS...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 3, 2013 at 12:28 pm
CELKO The rest of your posting is totally wrong; not a little wrong, but fundamentally, totally wrong.
The rest *attitude*, of your postings Joe, is totally wrong; not a little wrong,...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 3, 2013 at 11:19 am
CELKO ACCESS is a disaster and you need to get rid of it. I saw its premiere at a COMDEX; it did not work then and it does not work...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 3, 2013 at 11:12 am
Smash125, this is untested as I don't have AdventureWorks, but I think you will be able to gleen something from it. Also, you did not mention anything about year,...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 2, 2013 at 12:32 pm
mksunel (12/31/2012)
I want to do sentiment analysis, I need to know how I can achieve this using SQL Server?
How about this... Go find a random person, show him or her...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
December 31, 2012 at 12:23 pm
wendy elizabeth (12/24/2012)
I need to load data from excel 2010 spreadsheets...I am thinking of loading the data into temp tables in a way that the data will not be duplicated.
Wendy,...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
December 26, 2012 at 12:47 pm
sqlrd22 (12/19/2012)
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
December 20, 2012 at 6:10 am
Jeff Moden (12/16/2012)
CELKO (12/15/2012)
Code should be in Standard SQL as much as possible and not local dialect.
[font="Arial Black"]That's an absolute load of hooie! This is an SQL Server...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
December 19, 2012 at 3:39 pm
Nicholas, is this for a school project? It kind of seems that way, but it is such a terrible design that I would hate to think an instructor is...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
December 19, 2012 at 2:39 pm
lokesha.b, I did not see it anywhere, though I may have missed it in the interim banter, but why do you need to do what you are asking? Is...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
December 14, 2012 at 1:54 pm
Viewing 15 posts - 61 through 75 (of 621 total)