Viewing 14 posts - 1 through 14 (of 14 total)
Hi Stewart,
Thanks for the reply. I'll try it out, but from the looks of it it's exactly what I need!
It's annoying when the solution is so simple, but I just...
December 5, 2011 at 2:05 am
Hi Coen,
You can try this...
DECLARE @AlertXML XML
SELECT @AlertXML = '<AlertParameters><AlertParameter1>O:</AlertParameter1><AlertParameter2>SLP-718.pggm-intra.intern</AlertParameter2><AlertParameter3>6</AlertParameter3><AlertParameter4>6084</AlertParameter4></AlertParameters><AlertParameters><AlertParameter1>T:</AlertParameter1><AlertParameter2>SLP-724.pggm-intra.intern</AlertParameter2><AlertParameter3>3</AlertParameter3><AlertParameter4>1098</AlertParameter4></AlertParameters>'
SELECT 'The disk ' + c2.value('AlertParameter1[1]', 'varchar(30)') + ' on computer '
+ c2.value('AlertParameter2[1]', 'varchar(30)') + ' is running out of disk space. The values...
August 17, 2011 at 8:14 am
Mike01,
Thanks for the update and the code looks great, however....I don't actually know what the name of starting element will be! 🙁 We have 15 or so templates, all of...
May 3, 2011 at 8:49 am
Ok, so I've made a few changes and now have the data but with a different issue. Here's my SQL at present:
DECLARE @p_FileData XML,@p_FileClassElementCount INTEGER
SET @p_FileClassElementCount = 25
SET @p_FileData = '<FileData>
...
May 3, 2011 at 8:16 am
Hi Lynn,
Thanks for the reply. I've used your code to create a SQL statement that calls my stored procedure to insert the rows. I'm using an external procedure as all...
March 31, 2011 at 3:48 am
Cheers for the reply CC.
I did a search and here's the link: http://qa.sqlservercentral.com/Forums/Topic925149-338-1.aspx#bm933664.
This function does split out the strings delimited by a comma, but how do I then handle...
March 31, 2011 at 2:21 am
Having posted my topic, I read about the PATINDEX function and so decided to try my hand using that and a WHILE loop (despite not wanting to). My results are...
March 31, 2011 at 1:46 am
Hi Lynn,
Thanks for your posts.
Your final "coalesce" example has worked a treat and meant that messages are displayed newest first (DESC) and comments newest last (ASC).
Genius!!
Thanks again,
Kev.
March 13, 2011 at 3:43 pm
Guys,
I've been playing with the code (works great btw), however I have one issue. I'd like to order the items by messages DESC, but comments ASC - if that's possible??...
March 13, 2011 at 6:16 am
Jeff Moden (3/11/2011)
You don't need that function. SQL Server already has such a function. Try the following code and see.
SELECT DATENAME(mm,GETDATE())
I was just reading about that before I...
March 11, 2011 at 9:54 am
Ok, so I'm not sure if I'm onto anything, but would it be easier if I maintained a separate MONTHS table, which basically looked like this:
CREATE table MONTHS (
monthid INT PRIMARY...
March 11, 2011 at 9:52 am
Hi Kev, here's an excellent article covering the subject:
http://qa.sqlservercentral.com/articles/T-SQL/72503/[/url]
Cheers
ChrisM
Thanks Chris.
March 11, 2011 at 5:04 am
Let it be said Ian...you're a legend!
I've just run it up and it's spot on what I need. I think the key was also in the
case when parentid...
March 11, 2011 at 4:07 am
Lowell (3/10/2011)
items that contain badwords get archived off to a separate audit table, then update the messages directly to remove the bad words; the...
March 10, 2011 at 5:18 am
Viewing 14 posts - 1 through 14 (of 14 total)