NineIron (2/12/2013)

---

Here's an example list. I need to exclude this MRN from my query because it contains the value 250.

MRN ...

davidsalazar01 (2/12/2013)

---

Lowell,

It's only one occurence (e.g.<DID>) in the XML and your right I only want the data between the tags. Would the samples you posted do the trick? ...

could the script be overwriting the same backup file with differnet databases?

ie the db "Dictionary" gets backed up to C:\Data\Backup.bak, and then the database "SandBox" overwrites teh exact same file...

david the select statement you posted will find where the END tag begins...wouldn't you want the value between the <did> </did> tags?

could the opening <did tag have attributes?

is there more...

You probably have all the links you needed now Jeff, I'm late to the party on this one, but here's one more:

Project Gutenberg has a large number of ftp mirrors...

supplying the missing DDL and DML setup that is preventing analysis:

drop table container_attribute_type

CREATE TABLE container_attribute_type(container_attribute_type_id int,priority_sequence int,branch_id int,updated datetime,updatedby varchar(30))

INSERT INTO container_attribute_type(container_attribute_type_id,priority_sequence,branch_id)

SELECT 4,1,3 UNION ALL

SELECT 11,2,3 UNION...

another way is to backup and restore the database, then delete everything in foreign key hierarchy order in the new copy.

also, i know you said no data, but from experience...

a coded example of what Seans' first thought: clearly item 2 you wanted, at 40,000, does not give the desired results.

you'll need to clarify either the biz logic or the...

saxena200 (2/11/2013)

---

Created a view with schemabinding, and then created index on it...

Question - before data loading is it necessary to drop the view or if i drop the index...

99% of the time, you do this kind of image inserts/updates in a programming language.

TSQL does not have a native, built in way to do image to disk operations....

but it's...

what if they have 2008R2 or 2012 installed? 2005 is already eight years old...wow. keep in mind that official support from MS (end of life?) for that product is probably...

Mike Seattle (2/8/2013)

---

OMG! I've worked with SQL Server for over 10 years and I've never heard of assertions. Really. This is the first time I hear there is something like...

Richard Warr (2/8/2013)

---

Create a table with the same structure as the output from sp_help (e.g. tblHelp) and modify your code to insert to it, e.g.

Select @sql = @sql +...

you created teh case in the CTE, but you never use it in your final query, i think.

see my reformatted post of your code, with this comment:

e.TermWeek,--<<--don't you want...

Like Anthony mentioned, the default trace has the information you are looking for, if not to much time has passed.

SSMS has a handy report which queries the trace for you:

Additionally,...