Yep asking...

there's a an project on codeproject.com that has a decent example of how to bind a report to a dynamic dataset; by coincidence it's also in C# as well;

basically, it...

allin1 (9/17/2010)

---

As a part of PCI compliance lets say we encrypted all the 16 digit a/c numbers and socials. ANd with in the employee team if we are trying to...

whetehr you beleive it or not, it's returning more than one value:

if i put RMP.PeriodID =8 instead of PeriodID=8 Then it says an error that sub query returned more than...

SQL chooses the fastest way to access the data, and if no ORDER BY is used, returns it in that order;

So if there are no joins to other tables, then...

Richard it's fairly straightforward, but involves a combination of techniques.

if it's a file, you need to use bcp or bulk insert to get the text.

you need to use a split...

upgrading an installation form SQL 2000 to SQL 2008 is as simple as running the msi and clicking next 5 or 6 times;

there is no reason to upgrade to an...

nash this should help you get started then;

this example is finding every tables which have a column named "createdate" and also "changedate"

it then bcp's out the data from each of...

Google Translation of Lowell's Response (9/16/2010)

---

se ve como un controlador OLE nombre específica VFPOLEDB.1 necesita ser instalado en su servidor.

el conductor probablemente ya existe ont que otro servidor, por lo...

yes that's the default trace, which tracks DDL changes made to all databases; it's low impact trace that can be most easily accessed from teh GUI, where it is...

BETWEEN requires a pair of values;

BETWEEN X AND Y

your query:

select StartDate as 'RP Start Date' from [IAG].[Report].[refMonPeriod] where RMP.periodid = 8

returns more than one row...if you cahnge it to select...

ok correct me if i am wrong, but you have a table with ApplicationUsers, so users 'Bob' and 'Tom' are in a table, but the application connects witha single...

it looks to me like the report is designed to be bigger than the paper , isn't it? so it cannot fit untill you tweak it to a smaller width?

or...

my snippets have an open query example slightly different;

i know i've used this to insert into a local temp table

SELECT *

INTO #tmp

FROM OPENROWSET('SQLOLEDB','Server=yourservernamehere;Trusted_Connection=Yes;Database=Master',

...

J i poked around, and did nto find a way to get the output of the columns/structure of a stored procedure (if it returns result set) so far;

if we can...