One possible way of doing this is to have a user defined function for "distance". In case of two numeric columns a difference/ratio (careful with nulls). And then have a...

This is a common problem with CLR assemblies.

Instead of dropping the assembly, you could try to alter it. (also have a look at the UNCHECKED DATA option for the alter...

Grant Fritchey (10/30/2007)

---

Nah, neither method is "wrong". If you're opening the XML from a file, definiately do what Andras suggested. If you're receiving the XML from an application through a...

Hi Karthik,

nulls are handled differently in foreign keys. A quote from books online:

"if any column of a composite FOREIGN KEY constraint contains null values, verification of all values that make...

Using an Execute SQL Task, set the Connection, Resultset to none, SQL Statement to the statement in my previous post, works. But you may have other requirements for this package.

Andras

Do you have permission to delete this report? The exception claims that it is not a report created by you, and you are not in the sysadmin role. Is this...

declare @variable int -- or whatever data type

Select @variable = ID from table1 where value = 1

Update table1

Set value = 0

Where ID = @variable

Regards,

Andras

Sandy Millon. (10/30/2007)

---

Thanks Andras, I did not know about the XML PATH way. It seems to be working a lot better.

I tested it on a small set of data to...

under 2005 you could use a join, and use a trick with xml path to concatenate the column values.

Under 2000, where xml path is not supported you could create a...

Crosspost, answers on http://www.sqlservercentral.com/Forums/Topic416397-9-1.aspx

Andras

Crosspost, answers on http://www.sqlservercentral.com/Forums/Topic416397-9-1.aspx

Andras

This is something that was missed out from .Net, but you can use the IWshRuntimeLibrary to convert local path to UNC. You can see details on http://www.fuschi.com/wordpress/?p=17

Regards,

Andras

On 2000 you can use a case in a sum like:

SELECT

SUM(CASE t.column1 WHEN 'A' THEN t.column2 ELSE 0 END) AS [A],

SUM(CASE t.column1 WHEN 'B' THEN t.column2 ELSE 0 END)...

You can read in the xml document into an xml variable like:

declare @xml xml

SELECT @xml = CAST(BulkColumn AS XML)

FROM OPENROWSET(BULK 'g:\alma.xml', SINGLE_BLOB) AS x

select @xml

and then...

Gail is right about the installer for SQL Server 2005 not attaching the sample database. This information is also on the download page I included :

"These installers require you to...