Hi,
I am trying to match all databases to their backup dates. Since there will be cases when a existnig database has no backups made then these columns should show up as null.
( I have also use...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23091563.html
Hi,
We have a remote web server that has a SQL 2000 database. Due to various technical and political reasons, we take a single full database backup every night and copy the .bak file to our loca...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2310...
Hi folks,
I have a database table named tblOrganization. I have created the data hierarch by using parent and weight columns in this table.
Is it possible to list the resultset as
column1,colum...
http://www.experts-exchange.com/Microsoft/Development/Q_23700712.html
How do I import and export table in SQL 2000 and 2005
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2309...
Hi Experts,
I've got a SQL Server 2000 and 2005 installed on my PC, I just want to know
1) how do I know what datetime format my sql server is using? e.g. American or Australia?
2) At what ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23252740.html
Hi folks,
I have a crosstab query as below:
SELECT distinct(SaticiRumuzu),
SUM(CASE netmiktar WHEN 1 THEN netmiktar ELSE 0 END) x1,
SUM(CASE netmikta...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2339...
Hi Experts,
I need your help in writing one query. I hv a table with customer name and invoice amount in it.
Example:
Name Amount
SAM 10000
John ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23773965.html
Dear experts,
I have to migrate SQL server 2000 database to another server 2005, and collation has to be changed to.
How should I change the collation and what are the potential problems? Can...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2380...
I have a simple table that has data I need to export to an XML formatted file. I can get the data formatted correctly when it is one record but when there is 2 or more the Select..for XML explicit...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23288419.html
Hi folks,
I have a database table named TSALES7_V2.How can I remove duplicate rows of this table? Is it possible reduce the repetiton number to one? I need just one of these duplicated rows..
Ple...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2331...
