Dev (12/20/2011)

---

GSquared (12/20/2011)

---

Dev (12/20/2011)

---

Sorry for hiccup. I Google-d something today (after a long long time, using Bing now days) and didn’t find a single sponsored links...

Are both nodes at the same Windows patch level, or is that what you're trying to resolve?

Stefan Krzywicki (12/20/2011)

---

GSquared (12/20/2011)

---

Dev (12/20/2011)

---

Sorry for hiccup. I Google-d something today (after a long long time, using Bing now days) and didn’t find a single sponsored links there....

Are you looking for something like this:

DECLARE @TestString VARCHAR(100) = 'Test String' ;

SELECT @TestString AS [Raw],

CONVERT(VARBINARY(100), @TestString) AS ToBinary,

...

Dev (12/20/2011)

---

Sorry for hiccup. I Google-d something today (after a long long time, using Bing now days) and didn’t find a single sponsored links there. No promotions from...

The easiest way I can think of to do that would be to add:

SELECT *

FROM table1 t1

INNER JOIN table2 t2

on t1.col = t2.col

OR t1.col = '0' +...

Is this an Analysis Services cube, or a pair of relational tables? The first query you posted looks like it's from a pair of relational tables, but the last...

I don't understand your question/request/post.

Are you trying to store XML in a database? If so, you just define a table with a column that has the XML datatype, define...

Bhuvnesh (12/20/2011)

---

I am keen to know why model Db has huge log file. one thing comes to my mind : that we are putting some default/standard sql objects there which...

Have you looked into using the T-SQL ranking functions, Row_Number, Rank, Dense_Rank?

You can use Select Into to dynamically create a table, and you can use dynamic SQL to query an Excel file named by an input parameter. Combine those two...

I'm assuming you're asking me, but I'm not clear on what you're asking. XML doesn't have columns, it has elements. Is that what you mean? If so,...

Have you tried setting up an XML connection in SSIS? Does that not do what you need?

(Personally, I generally import XML files by using OpenRowset's Bulk CLOB options, and...

Stefan Krzywicki (12/19/2011)

---

Brandie Tarvin (12/19/2011)

---

Hiding in the next century, awaiting the day it will be legal and ubiquitous and...

T-SQL can't, by itself, create a file. It can query data in XML format, but it can't create a file directly.

If this is a one-time operation, then you can...