CREATE TABLE [dbo].[BldgA](

[CX] [nvarchar](255) NULL,

[Point] [nvarchar](255) NULL,

[Link] [nvarchar](255) NULL

)

sample data:

BldgA G1.EngCoolTemp G1.EngCoolTemp.C1.GenLoCoolT

I want to change it to look like this:

BldgA G1.EngCoolTemp C1.GenLoCoolT

Script for...

I am doing database backup already. But I need to do server backup (image the drives)?

I want to back the whole system. Similar to imaging the Hard disk. I know I can use Norton ghost, as an example, to image workstations. But what software to...

Yes. You are right.

Thanks for the feedback. I have adapted your solution, and it works great. This the query I am using now.

use Datbase1

go

DECLARE @Table NVARCHAR(200),@Column NVARCHAR(200),@Sql NVARCHAR(2000)

DECLARE Table_Cursor CURSOR FOR

SELECT so.Name AS...

if not exists

(select date_stamp from myTable Where date_stamp = '1-4-2011')

Begin

print 'myTable'

End

Now I need to figure...

I used your suggestion which is an implementation to "CELKO's" idea.

I created a table called cal with a "date_stamp" colum. This is going to be the calendar table that I...

Just the date . Like '12-31-2010'.

Compare few months (full year) worth of data (one row for each day).

Yes. That worked. Thanks a lot!

I solved it.

Right click on Server Server Agent. Select "properties". Go to connection. Under "Alias local host server" I deleted whatever was there (I had server name there, which is...

Date,Source,Severity,Message

12/22/2010 09:19:24,,Information,[098] SQLServerAgent terminated (normally)

12/22/2010 09:19:24,,Error,[382] Logon to server 'EnergyData1' failed (DisableAgentXPs)

12/22/2010 09:19:24,,Error,[298] SQLServer Error: 5<c/> A network-related or instance-specific error has occurred while establishing a connection to SQL Server....

Removed isnull(Pk_Dmnd_On,0).

Good point..

Thanks

Thanks for the feedback..

1. I did not know about COALESCE. I looked it up, and it looks like it's a powerfull command that I can utilize.

2. Yes, I could use...

Sean, I agree, The code was repeating itself.. not good.

The variables are being passed from an "ASP" page. The stored procedure is under the database in SQL server.

Here is...

Yes this procedure already exists.

Thanks