Viewing 15 posts - 76 through 90 (of 621 total)
memymasta (11/30/2012)
Ive almost got it to work... but i fail on the joining step where i join my CTE with a derived column...
When you say you fail, what exactly does...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
December 3, 2012 at 3:29 pm
Why don't you use google to see what's new in SQL:2011, then try some of it in SQL Server 2012 to see if it works or not?
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
November 30, 2012 at 10:50 am
Maybe this will help. I was able to use the sas.LocalProvider with the data import wizard by supplying only 'c:imports' as the data source, and 'pilotdata' as the location...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
November 9, 2012 at 12:07 pm
kwoznica (11/9/2012)
How do I get that extra step of aggregating for the average? I am confused.
I think I know what you are looking for, but just so I don't get...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
November 9, 2012 at 10:15 am
try this...
select 'AvgCasesByWeekDay' AS CasesByWeekDay
, [1] AS Monday
, [2] AS Tuesday
, [3] AS Wednesday
, [4] AS Thursday
, [5] AS Friday
, [6] AS Saturday
, [7] AS Sunday
From
(Select DATEPART(DW,CaseDate) AS [Day]...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
November 9, 2012 at 7:45 am
Jeff Moden (11/2/2012)
What do you get if it's followed by a semi-colon instead of a space?
Jeff, this is the darndest thing. I was off Monday and Tuesday, so was...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
November 7, 2012 at 8:26 am
Okay, now this is really wierd. I found a solution at http://www.excel-sql-server.com/excel-import-to-sql-server-using-distributed-queries.htm#Grant rigths to TEMP directory. I ran...
EXEC sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'AllowInProcess', 1
GO
EXEC sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'DynamicParameters', 1
GO
and I...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
November 2, 2012 at 12:55 pm
kwoznica (10/13/2012)
is there another option for taking a date and looking up the specific week day
This will do it...
DECLARE @date DATE
SELECT @date = GETDATE()
SELECT DATENAME(dw,@date)
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 15, 2012 at 3:09 pm
phamm (10/15/2012)
Thanks. I forgot to mention that these columns are string not integer.
Is there a reason they are not integer? You could try something like this...
DECLARE @col1 VARCHAR(20),...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 15, 2012 at 2:50 pm
a4apple (10/12/2012)
I totally understand you have great command and knowledge over sql server. People who need help here need suggestions, not answers like yours. I have seen all your...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 12, 2012 at 3:01 pm
Perry, that is precisely what I did. Local account fixed it. I uninstalled SQL Server, then tried to set it to local account upon re-install, as you could...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 12, 2012 at 11:16 am
I think I've got it. SQl Server is configured to start under NT Service. So if I change it to start under the local account, is that my...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 10, 2012 at 2:24 pm
raghavender.2369 (10/4/2012)
Sorry... should not use convert to retrive data from date column,the date should be appear in the table in 01-02-1988 only, not in 1988-02-01.
'01-02-1988' does not appear as '1988-02-01'...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 4, 2012 at 3:09 pm
mrwillcostello (10/1/2012)
...atleast start practicing with some tutorials. Again thanks for the response.
Will, it may not be kosher to point you to another site, but since you are looking for VBA...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 1, 2012 at 6:28 pm
Welsh Corgi (10/1/2012)
It is quite common in the Access world but I do not see any benefit in doing this.
My guess is that quite often the people creating the objects...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 1, 2012 at 4:44 pm
Viewing 15 posts - 76 through 90 (of 621 total)