Are the underlying tables updateable (from Access)? That often becomes a problem, when the linked tables don't pick up the unique key for a given table.

Try dropping the linked...

Nice trick Jeff...but that's not a hex string being returned...... He's...

Thanks! Although if the data gets big - I'd think about going with Jeff's running totals solution instead (which incidentally could...

Tell your friend to look up full-text indexing. There's no need to reinvent the wheel. The built-in functionality of Full-text indexing will do just that: no need for...

If you plan on concatenating - you don't need multiple datasets. You just need a way to know where the sequences start and end. This will help you...

rbarryyoung (5/27/2008)

---

I have to admit, over the years I have consistently found this to be the single most frustrating aspect of SQL Server, bar none. I cannot even begin...

I think you're misunderstanding what is going on. The DECLARE CURSOR does use the variable as it's defined at the time when the DECLARE is issued. Meaning - in...

Have you tried running profiler while trying the ADO solution? In other words - double check that what is being passed really looks like you'd expect it. I've...

GilaMonster (5/7/2008)

---

Also, what edition of SQL are you running (standard, enterprise, ...), 32 bit or 64 bit? What service pack?

What memory switches are present in boot.ini

What's you min memory setting?...

The CTE was a pretty good Idea - you could try this (this is the older version of a pivot table):

;WITH Land_CTE (LandLineNumber,

...

Looks to me that the DefaultValue should have only one "value" leaf, with the list of the values to select in a comma-separated list.

As in:

<DefaultValue>

...

do you have any idea what form the queries are taking? Is he trying to offer keyword-based searching of the titles? Exact matches? Topical matches? Phrase-matching?

Knowing...

Making this a 2000-compatible solution makes this a little more complicated. This should work though:

select *, identity(int,1,1) as RN

into #A

from tableA

order by newid()

select *, identity(int,1,1) as RN

into #B

from tableB

order...

Within the report in VS2005:

- Go to Report, Report Parameters. Add a parameter. Call it something meaningful (like - DateOffset). Change the data type to integer....

Have you looked at the properties of the source and destination objects within SSIS? The source object in particular. I've seen it make some bad choices about what...