smknox (5/26/2008)

---

I would like to use the value of GetDate() within a dynamic SQL statement.

THe following line:

', DateUpdated = '+ GetDate()+ CHAR(13)+

produces a syntax error "error converting datetime...

Do you need the codes as separte columns? If yes then as suggested by Mr.Mahesh and use PIVOT to accomplish the functionality. If you are looking at fetching the codes...

ALTER Table to add an additional column with IDENTITY Enabled. Drive your logic based on the new column and once the duplicate records or deleted, drop the column.

CREATE...

How many instances of SQL Server are running on your machine? There is a probability in somecases where a conflict could lead to this problem. I am not sure though...

Robinwilliams6 (5/16/2008)

---

I am trying to connect to http://www.localhost/reports and http://www.localhost and not being able to connect to any of them. Can any body guide me please.I do have IIS installed...

Do you mean to say that you want to mark your IPAddress of your SERVERB to 192.168.120.1 and SERVERA to 192.168.120.2?

How are the applications connecting to your database. Are they...

I am not sure if resource is a system database. From the article in the question it does not cement the answer that resource is a system database.

I am glad it worked.

Basically what you are executing in the dynamic sql does not

Simon_L (4/30/2008)

---

thanks prasad.. I think that was more the cut and paste error (my fault) in putting a simplified version...

Simon_Lo (4/29/2008)

---

Ok so thanks to some help in a thread down below I can pass a use statement with a cursor to step through all client db's on a server...

Is it related to

configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0" ?

Just you need to verify if your web.config file under Report Server and Report Manager have any xmlns links inside the Configuration tag and remove them.

configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0" then change it...

giontech (4/25/2008)

---

How can something like this be done in reporting services? I'm having trouble to get the totals, because if I do Sum(Fields!Yes.Value) + Sum(Fields!No.Value) it will just give...

Do you have a primary key on your table. If you do have a primary key, then the solution should be easy.