Depending on your exact requirements (I haven't looked at your Word document, I don't trust them - sorry) you might consider having one table for each option and just change...

Do you have any "Addins" installed either in Visual Studio or SSMS? (Not naming specific ones, just wondering if it is something we can eliminate by disabling them)

I have had...

tacy.highland (1/14/2014)

---

I have a dataset that is [highlight="#ffff11"]returning a date in the correct format[/highlight] that I want: M/d/yyyy. However, when I preview the report with the data in a...

Luis Cazares (1/10/2014)

---

That's...

or this, which I personally find more "readable", but that's probably just me...

, (select max(moddate) from (values(P.ModifiedDate),(PD.ModifiedDate),(PA.ModifiedDate)) a(moddate)) AS ModifiedDate

, (select max(credate) from (values(P.CreatedDate),(PD.CreatedDate),(PA.CreatedDate)) a(credate)) AS CreatedDate

Did you notice any difference in the connection settings (e.g. SET ANSI_NULLS etc.?) when you traced the problem?

Are there any triggers coming into play, maybe auditing the user?

Tara-1044200 (1/8/2014)

---

I have more than 100 views in a database and i would like to change the from clause for all of them in one attempt, is there a way...

I'm also failing to see the point of this trigger.

If I insert a row you copy it to your audit.

If I update the row you copy the new row to...

Yes, but you are going to keep finding these little annoyances working with XML data types in SQL.

I would highly recommend doing this sort of processing in .Net or...

http://technet.microsoft.com/en-us/library/ms177607.aspx

It is just a declaration of the namespace. Nothing to do with tables, loops or ctes.

When the namespace in the xml is the default namespace as in yours (there is no :prefix in the declaration), then all elements are part of that default namespace and...

Have a read of this http://technet.microsoft.com/en-us/library/ms188285(v=sql.105).aspx

and this http://www.sqlservercentral.com/Forums/Topic1012487-361-1.aspx

I would personally go with just storing the raw xml in the logging table.

I'm not sure exactly what your question is, but will take a shot in the dark.

When you log in to an FTP server, it has the concept of a "home"...

defyant_2004 (1/6/2014)

---

I have been given SysAdmin rights for the all machines with SQL Server installed. I have been able to figure out the SQLExpress instances. I was also...