Rex - yes, that way will work. However, please see this article[/url] for performance differences between the two methods. String manipulation has never been a strong area for MS, and...

Scott Arendt (1/12/2011)

---

That was a good question and I learned a couple of things from it.

I thought that 4 VLFs would be created and almost answered that way until the...

All of these solutions would require you to write dynamic sql to create that third table, and it doesn't help with the data types.

This isn't the type of thing that...

glock 71629 (1/12/2011)

---

This is exactly the situation where I use PowerShell frequently. I am able to export data from whatever complex query. Idea is something like this:

Invoke-Sqlcmd -ServerInstance myServer -Database...

You've got good timing. An article[/url] was just published today that covers this for you.

SELECT ServerName = @@servername,

InstanceName = CASE WHEN CharIndex('\', @@ServerName) = 0 THEN NULL

...

Does anyone know how to directly read an XML file from an internet address in T-SQL? Please respond here... and think about writing a SQL Spackle article on it!

Hello Nick,

What timing! An article[/url] was just published today that shows how to do this very thing. Check it out!

reto.eggenberger (1/12/2011)

---

Thank you for this tip with the STUFF function.

Is the order by in the subquery really needed? I think the for xml does it anyways. If you don't use...

This BOL entry should answer your questions.

Does this work for you?

DECLARE @Tbl TABLE (

id INT,

StartTime DATETIME,

NoOfHours VARCHAR(5),

FinishingTime DATETIME

)

INSERT INTO @Tbl

SELECT 19,'01/11/2011 12:30:00 ','02:30',''

UNION ALL

SELECT 18,'01/11/2011 16:40:00...

Now you tell us......

Well, run this little test:

declare @xml1 XML, @xml2 XML;

set @xml1 =...

Ahh, I see. You loading the file in as I showed in...

Jorge,

Might I suggest two things:

1. First, do not add things to master. Instead, create a database (named something like "Common"), and put all your special stuff there. Yes, you can't...