Mark Eytcheson (10/30/2009)

---

If you do go with Excel 2007, you'll have to remember to change the file type to xlsx during the Export process as SSRS2005 and 2008 default to...

That's a lot of dinner rolls! 😛

Robert Heynen-454800 (10/27/2009)

---

And yes, we do also do wild card searches, and in that case, full text indexing might surpass the wild card searches...but in the case of the exact...

See Jacob Sebastian's XML articles:

XML Workshop X - Working with namespaces

http://www.sqlservercentral.com/articles/XML/61333/

XML Workshop XI - Default Namespaces

http://www.sqlservercentral.com/articles/XML/61334/

In our use of XML as a data parsing mechanism from/to our .Net layer and SQL Server 2005 we are using traditional relational structures (tables) to hold the data. ...

ucbus 92278 (10/18/2009)

---

Hello:

I am new to SQl server. Here is my question and hope some one can help me.

We have a database containingg the following structure: GrandParent (GP),parent(p1,p2,p3), child tables.

My...

We've successfully been using XML as a data transport mechanism with our .Net web application. However, things are a bit cleaner in that we can pass native XML (datatype...

Another reason not to use OPENXML.

See: Stop Using OPENXML

http://www.sqlservercentral.com/blogs/michael_coles/archive/2008/01/20/stop-using-openxml-please.aspx

NTEXT has numerous limitations. I would cast the NTEXT column as NVARCHAR(MAX) and then use the REPLACE function to remove the offending (C) null.

Having been down this road before...

I'll add my...

You want to use DECIMAL with sufficient significant digits (scale) based upon the values being calculated. You did not specify the number of digits of the interest rate percentage....

If you are trying to implement tested changes from a development/QA environment to "n" databases, see my thread 474053 http://www.sqlservercentral.com/Forums/FindPost474053.aspx which is part of Topic Migrating from Dev to...

Mohit-652702 (9/4/2009)

---

On a Full-Text Search catalog I have rebuilt it using a finite set of stop list words:

a, an, and, la, le, les, and the

When I execute search on the...

This is one of the reasons to rely on checking 'equality' rather than 'inequality'.

Huh? This is just a simple compound condition test. The fact that it has an...

XML is a stream of data. It is not "records". The carriage returns and line feeds that are added are done by a presentation layer such as IE...