I think I would try replacing "ZB5|" with char(7) + "ZB5|". Then utilize the delimited split function to split this, using char(7) as the delimiter. (Feel free to use any...

Set up a job to run. For the schedule, set it to be when SQL Server Agent starts. For the step, have it email you. I include ServerProperty('ComputerNetBiosName') (or something...

SSMS 2008 - Multiple Server query question.

When I open up a normal query window connected to just one server, I can drag a file onto it, and a new window...

You're welcome.

Until Microsoft decides to fully implement the...

Check out this article: Select * from XML[/url] - it seems like it would do what you're asking for.

Please read this article[/url] - just be sure to follow all the rules in using this form of the update statement - they must be followed or you can get...

With all this talk about the clustered index, and churn on the date field, don't forget that all of those numerous non-clustered indexes will be converted to carrying the clustered...

This query will produce the table name, and a comma-separated list of columns in that table.

SELECT DISTINCT

t.name,

...

This code will show you which tables are missing from each environment. Note that it will require a linked server from one server to another (or if running from your...

I'm not sure that this would fall into the "wide range" that you're looking for Steve, but here's my take on these:

Ordering for aggregates (used to allow subsequent framing options)

Framing...

How's this?

;

WITH CTE AS

(

-- First, get the Row # for each customer, and the row # for each customer/esn_num

SELECT *,

CustRowID = ROW_NUMBER()...

I'd like to suggest that you read the first (or first two) links in my signature. Then, instead of those images, please post some CREATE TABLE and INSERT statements to...

Doctork11 (9/28/2010)

---

Thank you again Lowell for the help. If you don't mind, I would like to tap into your brain one more time on this statement.

Let me lay...

I think that this says it all for me:

Most professionals will stay late, pull the all-nighter, really help out when it's needed in a crisis. Just don't ask them...

How's this?

DECLARE @test-2 TABLE (

RowID INT IDENTITY PRIMARY KEY CLUSTERED,

MyXML XML);

INSERT INTO @test-2

VALUES ('<Root>

<Data>

<Test attr = "http://">

<Node1>testname</Node1>

<Node2>retrieve this</Node2>

</Test>

</Data>

<Data>

<Test attr = "http://">

<Node1>testname</Node1>

</Test>

</Data>

<Data>

<Test attr = "http://">

<Node1>testname2</Node1>

<Node2>also retrieve this</Node2>

</Test>

</Data>

</Root>');

/*

--...