Viewing 15 posts - 24,421 through 24,435 (of 26,490 total)
Jeff Moden (8/5/2008)
Lynn Pettis (6/13/2008)
I'd simply call it a strong difference of opinion.Heh... isn't that the way religious wars get started. 😛
Could be. It depends on the people. ...
August 5, 2008 at 6:15 am
Steve Jones - Editor (8/4/2008)
Lynn,We'll let you work from home in the winter. Less to distract you down there 😉
LOL. I live in the banana belt. The north...
August 5, 2008 at 6:09 am
query sys.columns or INFORMATION_SCHEMA.COLUMNS. You will probably need to link in a few other tables or views as well to know what you are looking at.
😎
August 4, 2008 at 2:33 pm
There may be a better way (ie without the subquery, set based) but here is something that at least works. If I get any more brilliant ideas, I'll post...
August 4, 2008 at 1:24 pm
Yes, in QA you can drag the columns to the query window. Drag and drop the columns folder from the object explorer in QA to the query window.
😎
August 4, 2008 at 12:50 pm
sharon.bender (8/4/2008)
However, I also have permission to spend...
August 4, 2008 at 8:25 am
How you handle this is also dependent on processing requirements. To you have to process the files as they are created or as a batch over time (ie you...
July 31, 2008 at 2:18 pm
Yes. The installation program will load (or should) anything you need prior to installing the work station components. That is all you need to select when it gets...
July 31, 2008 at 2:15 pm
I think this would be easier if we had the DDL for the table (CREATE statement), sample data (in the form of INSERT statements so we can cut, paste, and...
July 30, 2008 at 1:12 pm
It would be easier to help you if you would provide the DDL (create statements) for the tables involved, sample data for the tables (in the form of insert statements...
July 30, 2008 at 11:13 am
I think it would help to know more about the the table structure (at least the fields involved in the join/where clauses), some sample data to test against, and an...
July 30, 2008 at 11:01 am
hengert (7/25/2008)
The problem is that some of the tables contain more than one primary key, and some tables have more than one primary key and foreign keys.
Not to be nitpicky...
July 28, 2008 at 1:15 pm
From BOL regarding the db_datareader database role:
Members of the db_datareader fixed database role can run a SELECT statement against any table or view in the database.
😎
July 28, 2008 at 8:38 am
What are you trying to do in the stored proc? Depending on what you are doing, this may not be the best way to go about it. When...
July 24, 2008 at 11:45 am
Jeff Moden (7/24/2008)
So, do you have a grip on generating the test data or do you still need a bit o' help on that?
With thanks to Michael Earl, yes I...
July 24, 2008 at 11:19 am
Viewing 15 posts - 24,421 through 24,435 (of 26,490 total)