Viewing 15 posts - 1,846 through 1,860 (of 2,894 total)
slowder (3/20/2012)
try this:[font="System"]SELECT
employeeID, dateHired, employeeName, max([2010Salary]), max([2011Salary])
FROM (
SELECT
employeeID, dateHired, employeeName, salary as [2010Salary], 0 as [2011Salary]
FROM [2010Table]
UNION
SELECT
employeeID, dateHired, employeeName, 0 as [2010Salary], salary as [2011Salary]
FROM [2011Table]
)x
GROUP BY
employeeID, dateHired, employeeName[/font]
?????...
March 20, 2012 at 7:53 am
What do you use to ZIP your csv file? Is it installed on the SQLServer 2008 machine?
March 20, 2012 at 7:47 am
SKYBVI (3/20/2012)
i have mdb files used by ActiveExperts Network monitor manager.
I want to migrate those access files to sql server databases.
How can i do it.
P.S. i...
March 20, 2012 at 7:45 am
Ah, that's nightmare then, SQLServer still not allows to specify filegroup in SELECT..INTO. May be it gets fixed in SQL2012?
Have you tried to use SSIS for comparison? It may be...
March 20, 2012 at 7:42 am
Actually, you may not need to use it if you have dedicated Employee table (which most likely you do have). Then your query can use just left joins, something like:
SELECT...
March 20, 2012 at 7:20 am
As Jeff suggested, SELECT ... INTO, will outperform BCP in this case, looks like nothing should stop you from using it. You will not need to create you target table...
March 20, 2012 at 7:12 am
Then you don't need any of the left joins! They make no sense in the query as nothing is taken from them, and select is not restricted by them in...
March 20, 2012 at 7:04 am
Have you reboot after install and changing network configuration file?
March 20, 2012 at 6:20 am
But joining all temps into one is not simplification of the query! It is quite opposite!
Also, as I've said in my previous post, your select statement only gets columns from...
March 20, 2012 at 6:15 am
Please note: extended support for SQL Server 2005 is up until sometime in 2016...
So, if you work for a large company, you are quite likely still have it 😉
March 20, 2012 at 5:18 am
Once I've used the following guide and it did work for me:
http://www.ideaexcursion.com/2009/01/05/connecting-to-oracle-from-sql-server/
March 20, 2012 at 5:15 am
In a query you've posted, all three columns you select are from the same (first) table left joined to all other sub-queries. Therefore it can be simply written as:
SELECT DISTINCT...
March 20, 2012 at 4:59 am
...
Can I have any other better approach for this.
...
O' Yes, You can! Please read this one:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Actually, you are not a newbie here...;-)
March 20, 2012 at 4:25 am
If you need help and want to get relevant one and quick, you will need to follow forum etiquette as described here: http://www.sqlservercentral.com/articles/Best+Practices/61537/
Otherwise, people here left to guess what exactly...
March 20, 2012 at 3:59 am
Viewing 15 posts - 1,846 through 1,860 (of 2,894 total)