Viewing 15 posts - 1 through 15 (of 23 total)
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]...
September 19, 2013 at 12:41 pm
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...
September 16, 2013 at 12:35 pm
I have the same problem. Did you ever get a solution to it?
September 13, 2013 at 9:47 am
Those are very good links. Do you have similar information for for 70-462 and 70-463?
December 31, 2012 at 8:05 am
GSquared...I figure it out. It was all in your solution. THANK YOU A MILLION TIMES!!!
November 26, 2012 at 12:34 pm
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...
November 26, 2012 at 12:26 pm
Just discovered a new problem, and I cant get round it. The data is now getting XML encoded < to < and > to > etc
Any ideas?
October 5, 2012 at 2:46 pm
Eugene et al...It worked! I appreciate your help.
October 2, 2012 at 9:37 am
Eugene Elutin (10/2/2012)
oscarooko (10/2/2012)
Eugene Elutin (10/2/2012)
declare @Table1 table (EmailAddress varchar(20), Msg varchar(20))
insert @Table1...
October 2, 2012 at 9:23 am
Eugene Elutin (10/2/2012)
declare @Table1 table (EmailAddress varchar(20), Msg varchar(20))
insert @Table1
...
October 2, 2012 at 7:10 am
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...
September 13, 2012 at 12:03 pm
Lynn,
Just got done running the query. I deleted 47,360 records in 1hr 27 mins using your method. Wow, still too long!
September 11, 2012 at 1:32 pm
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...
September 11, 2012 at 1:25 pm
/*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...
September 11, 2012 at 1:06 pm
Viewing 15 posts - 1 through 15 (of 23 total)