Anyone with an idea on how to format a part of a string in a table to bold.

Consider this...

CREATE TABLE [dbo].[Test_XML](

[XMLID] [int] IDENTITY(1,1) NOT NULL,

[FName] [nchar](30) NULL,

[LName] [nchar](30) NULL,

[TextBody] [xml]...

1)Click to open up the parameter folder in your report solution

2)Right click on the appropriate parameter that you want to pass a null value on

3)Under the "General" tab, make sure...

I have the same problem. Did you ever get a solution to it?

Thanks Emil. I like your blog. Keep updating it.

Those are very good links. Do you have similar information for for 70-462 and 70-463?

GSquared...I figure it out. It was all in your solution. THANK YOU A MILLION TIMES!!!

Mr. GSquared,

Thanks for the prompt response. However, I expected 2 rows in the result set. I dont understand where the other row disappeared to. Just to make...

Just discovered a new problem, and I cant get round it. The data is now getting XML encoded < to &lt and > to &gt etc

Any ideas?

Eugene et al...It worked! I appreciate your help.

Eugene Elutin (10/2/2012)

---

oscarooko (10/2/2012)

---

Eugene Elutin (10/2/2012)

---

Use XML FOR PATH method (it most likely will give you the best performance for T-SQL implementation):

declare @Table1 table (EmailAddress varchar(20), Msg varchar(20))

insert @Table1...

Eugene Elutin (10/2/2012)

---

Use XML FOR PATH method (it most likely will give you the best performance for T-SQL implementation):

declare @Table1 table (EmailAddress varchar(20), Msg varchar(20))

insert @Table1

...

ChrisM@Work (9/12/2012)

---

ChrisM@home (9/11/2012)

---

...

If there's no index on it, then that's your problem. Each delete in SPTLog will cause a table scan of the column in SPTLogArchive to ensure that the...

Lynn,

Just got done running the query. I deleted 47,360 records in 1hr 27 mins using your method. Wow, still too long!

So you saying even though I have a the criteria LogTime < @dCutOffDate and an index is defined on LogTime, it still will NOT be used?

Any ideas on what to...

/*Indexes for SPTlogArchive*/

/****** Object: Index [IX_SPTLogArchive_LogTime] Script Date: 09/11/2012 14:46:56 ******/

CREATE NONCLUSTERED INDEX [IX_SPTLogArchive_LogTime] ON [dbo].[SPTLogArchive]

(

[LogTime] ASC

)

INCLUDE ( [LogID]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE...