:ermm: XML PATH helps create a delimited list as a single column. The example in the OP has a separate column for each transaction.

@krish2266, did you get your issue...

SQL_Developer (8/3/2011)

---

Hello All,

I am working on dynamically generated web form with bunch of controls in an ASP.NET project. When I save the data, I am passing all the controls (FieldName,...

Denise McMillan (8/4/2011)

---

I'm sorry, I forgot to put that in! Error is:

OLE DB provider "OraOLEDB.Oracle" for linked server "LAWSONPROD" returned message "ORA-01858: a non-numeric character was found where a...

Errr...Jeff Moden strikes again? Try a Crosstab instead of PIVOT. You'll be happy you did.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns[/url]

Denise McMillan (8/4/2011)

---

I have a querythat works in SQL Server 2005, but has an error using it in SQL Server 2008.

SELECT *

FROM OPENQUERY(LAWSONPROD, 'SELECT

...

+1...

I gave up drinking a while back but agree with Grant. Stone is an excellent example of a U.S. microbrew far superior to any of the Mega Breweries. Oskar Blues...

Suit yourself.

I don't know the layout of your database but if you're using procs, views, functions, etc. to access your tables just be aware that DENY is not evaluated...

Why DENY? Unless you have very granular or complex security requirements using DENY is not preferred.

It's much more intuitive from a management standpoint to have Users added to Roles that...

James Tech (8/3/2011)

---

My concerns are:

1.) I want to know if each of the property specified in this connection string sample below is well suited for a clustered environment. e.g. The...

Sorry, I guess I confused on your request. A connection string to a clustered instance will look very similar to one connecting to a stand-alone instance...that's the point of clustering,...

This should help clear things up:

All SQL Server SqlConnection properties

What else is the package doing? Many times when I see this type of issue it's related to an interactive prompt showing up when the SSIS package is run unattended...

Steve.Cornelius (8/3/2011)

---

I see very little of value in this article. The readers are ever so slightly better informed after reading it, but have acquired no useful information. In fact...

opc.three (6/8/2011)

---

Thanks for the great article David!

From the article:

Therefore, each row in a database, at any given point in time, can be identified by three numbers; file number - page...