First, welcome to SQL Server Central! You'll notice on the homepage that this site is "A Microsoft SQL Server community of 1,800,502 DBAs, developers and SQL Server users". Most of...

or...

declare @xmldoc as xml

select @xmldoc = REPLACE('<Text>This is firstline<Break />This is second line<Break />This is third line</Text>','<Break />',CHAR(10))

select @xmldoc.value('(/Text)[1]','varchar(max)')

Ditto what Nevyn said about the DDL. In the meantime, it's worth noting that you don't every need a subquery or CTE with SELECT * FROM <table>.

You could replace...

crowegreg (5/6/2015)

---

Thanks for the reply.

I haven't tried that yet. Since my test is with a very simple delete query, I wanted to make sure that its not a setting within...

have you tried creating a stored procedure in SQL Server that does the DELETE for you and then calling it from MS Access?

I have not worked with Access in...

In addition to what everyone else has said...

On a performance note it means that you're going to get an index scan instead of a...

A few things to consider:

I have inherited a system which has very few tables with indexes. One table has 18K rows, expected to grow to 25K by year end,...

Take a look at this thread:

http://www.sqlservercentral.com/Forums/Topic1678555-3077-2.aspx#bm1679472

For the sake of discussion we'll just say that we want to archive stuff older than three months.

The most basic approach would be to use a stored proc and...

Shawn Melton (5/5/2015)

---

Alan.B (5/5/2015)

---

I'm not trying to belittle Shawn's solution as he was just fixing your code.

It is worth noting, however, that sp_MSForEachDB is undocumented and you should...

Erland Sommarskog (5/5/2015)

---

Indeed you can. You can have multiple CROSS APPLY on nodes that relate to each other:

SELECT

testsuite.c.value('@name', 'nvarchar(20)') as testsuitename,

tescase.c.value('@internalid', 'int')...

Will read the entire OP moving forward.

rpetit1230 (5/5/2015)

---

I'm trying to run an Insert on tables using a User Login but I keep getting the error above. I ran the insert using my own credentials and it...

Luis Cazares (5/1/2015)

---

Jeff Moden (5/1/2015)

---

I had a rare and wonderful opportunity, today. Luis is in town and I finally got to meet him and have lunch with both him...

w.zia.2015 (4/30/2015)

---

Afternoon ladies and gents,

I'm trying to find an alternative, more efficient way of processing some code to select the top row of a specific order.

At the moment we use...