Lowell (8/4/2011)

---

what's wrong with a single datatable with 200 columns, maybe with just the one row the client would be fiddling with?

then the GUI can present you 100 or...

Although I have been called crazy many a time, and a lot lately coincidentally, SSCrazy is just my designation on the site based on the number of points I have...

: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...