Viewing 15 posts - 24,421 through 24,435 (of 26,486 total)
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
Actually, the problem was that you can't upgrade SQL Server 2000 EE to SQL Server 2005 DE. We got it done though, just took a little extra work.
😎
July 24, 2008 at 10:29 am
After some research (didn't find anything), the only explanation I can come up with for this is that we thought we told setup to install the database engine, but must...
July 24, 2008 at 9:43 am
A) That is why I am trying to come up with a subset that is large enough to satisfy my testing. If after a few million rows of test...
July 24, 2008 at 12:01 am
Four years ago, my predecessors predecessor wrote 2 scaler UDF's, one to encrypt and one to decrypt a string using the same algorithm that the SIS system uses on-line. ...
July 23, 2008 at 7:21 pm
Viewing 15 posts - 24,421 through 24,435 (of 26,486 total)