CASE WHEN is not required. You can use Lowell's last script. Also you have a where condition. So all the data will be with NULL.

As per Lowell's query you can create the temp table.

Actually, I tried to ask you to write a script as below.

EXEC sp_executesql @inputQuery -- N'SELECT CustId AS label1, Name...

Try this. I didnt test the code as I do not have sql installed in my system.

DECLARE @startdate as datetime

DECLARE @enddate as datetime

DECLARE @T TABLE (startdate DATETIME, enddate...

Is there any prob with using a temp table? If not, create a temp table with IDENITITY field and insert data from customer table. Then you can loop through each...

UMG is UMG Developer. User name of the previous post. DDL is Data Definition Language. HowardW corrected my mistake in the trigger type. Thanks HowardW.

Ok Craig, Thank you.

UMG might be saying about Logon "DDL" Trigger.

In Express edition you can not restore a backup which is having more than 4gb. You may required to reduce the size of the database by removing unwanted data and...

2-3 years back I faced the same issue like Doctor and his available consultation slots. Table structure was same. What I did, joined both table and brought 2 columns DoctorName,...

This is the comment in the following MS Link: http://msdn.microsoft.com/en-us/library/ms189107.aspx

Use the Lock:Timeout event class to monitor when time-out conditions occur. This information is useful to determine if time-outs...

Subrat,

Hope your data as below

EmpId | EmpSal

---------------

120000

210000

315000

What would be your expected result?

Ok. Got it, Thanks.

Gail/Ali, Is there any way to restore the data from Mirror to Primary if something happened to primary data?

You may required to run the setup to repair master db.

Also please check the below links.

http://www.articlesnatch.com/Article/How-To-Fix-Master-Database-Corruption-In-Ms-Sql-Server/972983

http://www.articlesbase.com/data-recovery-articles/repairing-sql-server-master-database-error-3417-2299870.html

Ans 1

True. We can not compress db in Std edition

Ans 2

I have gone the below link and read the following

"Backup compression was introduced in SQL Server 2008 Enterprise. Beginning in...