Viewing 15 posts - 2,551 through 2,565 (of 14,953 total)
Dev (12/20/2011)
GSquared (12/20/2011)
Dev (12/20/2011)
December 20, 2011 at 9:50 am
Are both nodes at the same Windows patch level, or is that what you're trying to resolve?
December 20, 2011 at 9:48 am
Stefan Krzywicki (12/20/2011)
GSquared (12/20/2011)
Dev (12/20/2011)
December 20, 2011 at 9:46 am
Are you looking for something like this:
DECLARE @TestString VARCHAR(100) = 'Test String' ;
SELECT @TestString AS [Raw],
CONVERT(VARBINARY(100), @TestString) AS ToBinary,
...
December 20, 2011 at 9:44 am
Dev (12/20/2011)
December 20, 2011 at 9:35 am
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' +...
December 20, 2011 at 8:02 am
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...
December 20, 2011 at 6:45 am
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...
December 20, 2011 at 6:35 am
Bhuvnesh (12/20/2011)
December 20, 2011 at 6:31 am
Have you looked into using the T-SQL ranking functions, Row_Number, Rank, Dense_Rank?
December 20, 2011 at 6:30 am
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...
December 20, 2011 at 6:29 am
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,...
December 20, 2011 at 6:23 am
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...
December 19, 2011 at 12:15 pm
Stefan Krzywicki (12/19/2011)
Brandie Tarvin (12/19/2011)
Greg Edwards-268690 (12/19/2011)
DBBC Timewarp - where are you when I need you?
Hiding in the next century, awaiting the day it will be legal and ubiquitous and...
December 19, 2011 at 12:13 pm
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...
December 19, 2011 at 11:12 am
Viewing 15 posts - 2,551 through 2,565 (of 14,953 total)