Search results for query: *

It worked... after playing around, I realized that I could go into Local Packages and edit the DTS, removing the DESTINATION column that was causing the problem. Since the destination column was the identity column, I simply removed it from being included/called. Now it works great! Thanks...

I have a flat file that I need to set up a DTS to extract the data and add to my SQL Server database table a few times a week. I'm running into a problem: insert error, column 1 ('id', DBTYPE_I4), status 10: Integrity violations; attempt to insert NULL data or data which violates contraints...

TR, Thanks for the info. I realize why its happening, I'm just not sure how to do write the query to do what it is I want it to do. In this case, there are categories for hobbies, like: CATEGORYID CATEGORY 1 Swimming 2 Cooking 3 Hiking 4 Movies 5...

Thanks, Guys - I appreciate the info!!! [bugeyed] rexolio@yahoo.com "I'm not dumb. I just have a command of thoroughly useless information." - Calvin, of Calvin and Hobbes

I have 3 tables that go like this (more or less): TABLE 1 ID NAME CITY ST 1 J. Doe Boise ID 2 W. Smith Tampa FL 3 B. Jones Atlanta GA TABLE 2 ID SPOUSE INCOME DATE 1 Mary 55000 1/1/2004 2 Bob 74000 1/14/2004 3 Tina...

Hmmm, okay. Thanks for the info. So, in the event that there is a table the collects info from a form on a web site, and the user leaves one of the fields blank, would it be best to convert it to a NULL or just leave it "blank"? [bugeyed] rexolio@yahoo.com "I'm not dumb. I just have a command...

I was told my someone recently that if there is no value to insert into a sql field, you should NOT let it be NULL, rather just insert a "" (blank) because SQL processes for NULL values last. Is this true, or am I not making any sense? :) [bugeyed] rexolio@yahoo.com "I'm not dumb. I just have...

When creating an index, why are you able to add more than one column for one index? I created a separate index for the following fields: LastName FirstName Address City State Email Updates Password CreateDate MatchID Just trying to understand why you're able to do that, and therefore should I...

Sorry, but one more question I have... it says that a field cannot allow nulls if you're adding it to the index, but some of these fields MUST contain nulls - for instance not everyone in my database has an email address, but yet I still need to be able to query by that. So what do I do about...

So for each field I might possibly query eventually, I should a) Make sure it doesn't allow nulls (otherwise I can't create an index on that field) b) Right click in design view and choose "Indexes/Keys" c) Under the Index Name field, choose each field/column I wish to add as an index If this...

In that table, I have the following fields: NameID CreateDate FName LName Address Apt City State Zip DayPhone EvePhone Password Email Updates (Yes or No field) MatchID (this is a combination of FName, LName, St Number & Zip to formulate a matchid so that we can avoid adding duplicates from our...

It happens from Query Analyzer, or from querying directly from the table, or via ASP. [bugeyed] rexolio@yahoo.com "I'm not dumb. I just have a command of thoroughly useless information." - Calvin, of Calvin and Hobbes

I have a table with about 350,000 records. The Index/Primary Key field is called NameID. If I perform a query without specifying order, the results pop right in. If I do a query where I ask it to list the records in any order other than the NameID (i.e. RecordDate, LastName & FirstName, City...

Oh, and sorry my subject line was so unspecific - I meant to change it before posting. [bugeyed] rexolio@yahoo.com "I'm not dumb. I just have a command of thoroughly useless information." - Calvin, of Calvin and Hobbes

Does know what the following pop up error message means from SQL Server 2000 Enterprise Manager: http://216.53.190.158/untitled-1copy.jpg I'm so lost. I'm importing a CSV database with 2 number fields separated by commas into one of my SQL database tables. There's 1,702,267 rows and it gets to...

Sorry... just consider this my "vent" forum as well... I think I have it figured out. Its amazing how easy things work when you let QueryBuilder do the work!!! Geesh! ;) [bugeyed] rexolio@yahoo.com "I'm not dumb. I just have a command of thoroughly useless information." - Calvin, of Calvin...

Or I get "Line 3: Incorrect syntax near ')'" even though DTS parses it without any problem. OR I get "Context: Error calling GetColumnInfo. Your provider does not support all of the interfaces/methods required by DTS" I'm confused - I can't find where it changes, but I get various errors. And...

I spoke too soon - I keep getting an Invalid Pointer error [bugeyed] rexolio@yahoo.com "I'm not dumb. I just have a command of thoroughly useless information." - Calvin, of Calvin and Hobbes

Thanks - I managed to start playing with DTS and exporting information using the above query you sampled. The only problem, and its not just a HUGE ordeal or anything, but a little inconvenience, is that let's say on Category1, not all records have a 1 in Category1 or a 2 in Category2, etc. So...

I have an archaic table with the following format: tblCATEGORIES NameID, Category1, Category2, Category3, Category4, so on Each record contains an ID (NameID) from another table and specifies whether that user/record has selected any of those categories. Each category is represented by a...