great job providing the same DDL and Data!

maybe i'm missing the hard part of the question and overlooking the obvious,it, but does this do what you want? a simple union,...

this looks right to me:

Imports Excel = Microsoft.Office.Interop.Excel

Private Sub ImportExcel(ByVal PR01filename As String)

Try

xlApp = New Excel.Application

xlApp.Visible = True

...

Ben I'm hoping some of my peers may have a better suggestion;

I'm familiar with the free Community verison of DotNetNuke[/url] which is a Content Management Solution featureing suites of web...

some links i have saved:

adding a sysadmin back toa server:

http://beyondrelational.com/modules/2/blogs/115/posts/11143/how-to-access-a-newly-installed-sql-server-2008-r2-instance-if-you-do-not-know-the-login-and-passwor.aspx

http://sev17.com/2011/10/22/gaining-sql-server-sysadmin-access/

you really HAVE to compare differnet queries by their execution plans, and not by their perceived speed.

digging into those details are what gives you an understanding of why there are...

and the details:

first, you gotta have the ACE drivers installed, look at this post FIRST:

http://www.sqlservercentral.com/Forums/FindPost1407497.aspx

then here's a mockup of the code: there's a couple of issues...I'm ASSUMING every sheet is...

the devil is in the details, but if xp_cmdShell is available, you can use THAT via tsql to :

1. get the list of files,

2. create a cursor/loop for each of...

have the desktop application e use some web services you will need to create whichreturn available tickets and another to book tickets.

maybe an additional web service so you can see...

this blog has a good explanation and the scripts to track down the offending schema:

http://blog.sqlauthority.com/2011/12/26/sql-server-fix-error-15138-the-database-principal-owns-a-schema-in-the-database-and-cannot-be-dropped/

Manie My setup for gMail is working fine and sounds to be near-identical to yours, i just tested it again; the only difference seems to be the smtp server i'm...

and virtually, because we have a sub-select, we can just filter the results right there in the SQL statement:

SELECT

IndivdualId,

City,

...

how about changing the drop down into an optional text field...that way if the user KNOWS the ID, they can just type it in;

i'm no SSRS expert, but...

one way is to create a view that has one record per Id, then you get jsut the "current" people in TX in your example:

CREATE VIEW CurrentAddresses

AS

SELECT

...

i would swear there was a similar post a few months back, and i seem to remember that if a query uses parallelism, you can see this behavior?

fish that table is for an Oracle definition, and not SQL server.

just creating the table is not enough, don't you need to insert some data into the table before querying...