itsjustme (1/11/2011)

---

Hi Wayne,

here is the code that I am trying to write..

declare @db_name nvarchar(255), @db_location_name nvarchar(255), @db_log_name nvarchar(255)

, @db_name_time nvarchar(255);

set @db_name = 'test';

set @db_log_name ='test_log';

set @db_location_name='c:\temp\test.bak';

set @db_name_time = 'test01' ;

Restore...

keymoo (1/11/2011)

---

I have some data in SQL Server I'd like to join with an XML document on the internet. The document is here http://rates.fxcm.com/RatesXML

I will be calling the stored procedure...

itsjustme (1/11/2011)

---

Hi,

Thank you very much for quick reply. when I try to put the quotes then I get the error as

Incorrect syntax near +

any ideas of what...

I see two issues:

1. You can re-write this procedure to not need any temp tables or cursors - just a single, set-based query.

2. You are referencing sysobjects, sysindexes, etc. You...

Jeff Moden (1/10/2011)

---

WayneS (1/10/2011)

---

Craig Farrell (1/10/2011)

---

I...

Craig Farrell (1/10/2011)

---

I haven't had the...

What parts are working?

In the restoring section, the variables being populated are not in quotes. (Probably a typo in the post here, since you would also get a compile error.)

You...

Lutz,

Thanks for covering this!

With both HTML and XML looking somewhat similar, it's easy to see why one would get confused over it.

How does this work out for you?

SELECT @var1 = max(CASE WHEN id = 1 THEN varvalue ELSE NULL END),

@var2 = max(CASE WHEN id...

Sichy (1/9/2011)

---

Sichy,

I'm really curious about this line of code:

SELECT TOP 158533281 --158,533,281

What does that number represent? It's a really odd number to use - why not 200 million?

cengland0 (1/7/2011)

---

So are you saying that if the log file was created properly, I would only have to backup the transaction log and not shrink it? Not sure how...

cengland0 (1/7/2011)

---

I have databases that get tables updated daily and is around 115 Gigs. I have to backup the database and shrink the logs several times a day or...

GSquared (1/7/2011)

---

I just have a bit of a Mayan obsession. It was a cool civilization in a lot of ways, regardless of what Mel Gibson thinks of it....

Interesting... I didn't know this. I was immediately thinking triggers myself.

toddasd (1/6/2011)

---

Is it considered cheating that I went to the BOL before answering the question and read "If two or more rows tie for a rank, each tied rows receives...