here's a lame example of both to help you visualize.

element centric:

<ROOT>

 <BOOK>

  <TITLE>The Best of SQLServerCentral.com - Vol. 3</TITLE>

  <AUTHOR>Brian Knight</AUTHOR>

  <NUMBEROFPAGES>250</NUMBEROFPAGES>

 </BOOK>

</ROOT>

Attribute centric:

<ROOT>

 <BOOK TITLE="The Best of SQLServerCentral.com - Vol. 3" AUTHOR="Brian Knight" NUMBEROFPAGES="250" />

</ROOT>

i think you might be getting hung up on formatting...

remember the date is actually stored as a double,where the integer portion is days and the decimal portion it part of a...

create an index on the column and see how that affects the speed:

CREATE INDEX IX_ActivityDate  on C_Tracked_Item_Hist(ActivityDate);

also throw away all your converts...

Select * from table where activitydate > DATEADD(day,...

i think you are confusing the versions a little bit.

if you have a non server operating system, your SQL 2000 instance IS a MSDE instance...if you had either the SQL2000...

copy and paste it from a raw text editor...word might reformat it to a microsoft format.

copying that as text, naming it test.xls and then opening it in excel and you'll...

if you create an html document and give it the .xls extension, then when excel opens it, it will maintain the format...so if you make a <TD BGCOLOR="#EEEEEE"><B>COLUMN NAME</B></TD>

the cell...

it's godawful easy; download the source fromt eh web link i posted.

copy the dll from the release folder to your c:\program files\microsoft sql server\$instancename\Binn directory.

run the .SQL script that is...

as Vladan identified, malformed HTML will result in an unwanted result from regular expressions.

here i used the extended stored proc i mentioned before:

declare @string varchar(8000),@regExpr varchar(500)

set @string='<OL>

<LI>

<DIV align=center>Store...

this is kind of hard to do; i use an extended stored procedure in order to strip RTF or HTML tags;

see this post for the details, other examples, etc:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=242853#bm243180

you can't truncate a table that has a foreign key reference.

also, if you delete from the tables out of order, you'll end up with errors as well.

another thing to consider...

i think the only way to do this is to use a function, and have the function return ONE column with all the values in a comma delimited format:

CREATE FUNCTION...

without using e3nterprise manager, here is a copy and paste solution:

declare

 @isql varchar(2000),

 @procname varchar(64)

        create table #procResults(procid int identity(1,1) primary key,ProcText varchar(4000) )

 declare c1 cursor for select name from...

dumb question from someone less experienced....if you have a small database, say 300 meg...your server most likely has multiple gigs of ram...couldn't you pin every table and achieve a performance...

http://groups.google.com/groups?sourceid=navclient&ie=UTF-8&rls=GGLG,GGLG:2005-36,GGLG:en&q=%22The%20description%20for%20Event%20ID%20(%200%20)%20in%20Source%20(%20SQL%20Server%20ODBC%20driver%20support%20error%20)%20cannot%20be%20found.%22&sa=N&tab=wg

folowing some of the links there that have answers says that your MDAC is out of date and that you may be missing a .rll file.

HTH

\

did you just post real client data credit cards on a forum? i hope the data you pasted is fake developer data.

edit the post and remove the data right away.