Hiya, What can i do when my import fails because some of the fields in my my comma-delimited text file have quotation marks? scample = "howdy doody", 43334443, " Mary's "handy man " Thanks! ...more >>

Our schedule management system for the university runs as one database for each campus. We want to consolidate the databases to one single database for alot of reasons, but we have for the moment no possibility to modify the app to fit the requirements for "intercampus work". Until the app is m...more >>

I have a question about how to implement a sortindex on my rows and I'm not sure I'm doing sort the right way. I want to allow a user to sort the entries manually, I am using a separate field (SortIndex) in an existing table. So every record has a # in its SortIndex field, and when I display ...more >>

Can SQL2000 and Yukon be installed side by side? ...more >>

Well you must know we won't release our user list. But we envite all those that aren't using RAC (and why:) to post here. I'm sure it will be a very lite thread:) "David Portas" <REMOVE_BEFORE_REPLYING_dportas@acm.org> wrote in message news:Q_6dnYhVaeWHr2zdRVn-jA@giganews.com... > I'm sure ...more >>

Well you must know we won't release our user list. But we envite all those that aren't using RAC to post here. I'm sure it will be a very lite thread:) "David Portas" <REMOVE_BEFORE_REPLYING_dportas@acm.org> wrote in message news:Q_6dnYhVaeWHr2zdRVn-jA@giganews.com... > I'm sure your sugges...more >>

If I have 4 dates returned from a view, how do I determine the maximum of the 4 dates? Test Table data = date1 = 1/1/2004 date2 = 1/2/2004 date3 = 1/3/2004 date4 = 1/4/2004 MyView = select date1, date2, date3, date4, MaxDate from TestTable Desired results = 1/1/2004, 1/2/2004, 1/3...more >>

Hi, I am trying to do something like SELECT @Result = MyRemoteSQLServer.MyRemoteDatabase.dbo.MyFunction() And it doesn't work... i can sucessfully do: execute MyRemoteSQLSever.MyRemoteDatabase.dbo.MyRemoteProcedure. I was wondering if there is an equivalent sintax for using remote functi...more >>

I have a little obstacle that I need to get over. I have a SQL Server database with the following tables, tblPosition tblEmployee Now I need to get some data into the Position table, so I DTSed some data into a new table now called DrewData. The problem is that I need to join the Employ...more >>

Dear SQL buffs, Has anyone seen a problem where LIKE does not find data, yet = does. On SQL 7 we have ended up using: (VW.Data LIKE O.MatchData) or (VW.Data = O.MatchData) because the Like did not return the required rows. I'm afraid I didn't see it myself, so I can't supply the dat...more >>

Thought this might be worth posting. This is fairly easy to reproduce. First, create this procedure in Enterprise Manager CREATE PROCEDURE [dbo].[Test1] AS IF NULL = NULL PRINT 'NULLS EQUAL!!!!' ELSE PRINT 'NULLS NOT EQUAL' and this in Query Analyser (only difference is it's called Test2) ...more >>

background: sql2k on nt5 i don't know if anyone noticed this, if you schedule a job thru EM, set a recurring 'daily' job for every 5 (any number other than 1) days, at 6pm. In the job properties/schedules tab, it displays 'occurs every 5 day(s), at 6:00:00 pm. does anyone know how that sche...more >>

Hi guys, Have you guys use remote desktop connection to login sql server 's machine before? Since I'm not in the server room, I used remote desktop connection to login both Source server and target server from my desk. When I transferred a file from source server to target server using ...more >>

I noticed that when debugging a stored procedure that inserts a record into a table that the table is not actually updated when the procedure has finished, but it does update if you call the procedure. Is it supposed to work that way? Just curious so I don't keep trying to figure out whats wro...more >>

I'm using DMO through VB.NET 2003 on an XP Pro machine and trying to run oDb.ExecuteWithResultsAndMessages2(msSchemaFileName, sMessage, obj) where oDb is an existing (empty, only system tables) sql2k database and msSchemaFileName (created using ScriptTransfer) is a file containing all the t...more >>

Does anyone have any idea how to syncronise two SQL identical tables across a network, between servers? We want to run our website from a SQL tables on the same server, but set up so that if the main SQL tables across the network change, or the tables on the web server change, the two seperate...more >>

Is there a Query to find the licesnse scheme that SQl is using? Per procesor or per seat and does it give a quantity? If not I have an NT SQL server7 that says per seat and doesnt give a count. Trying to find the count of all SQL licenses in my enviorment. Thanks...more >>

I have the task of updating a database where no normalization was considered. I have managed to fix many issues, but i would like to be able to select only data that is not distinct. Is this possible? for example, if i have a table that contains 1,2,2,3,6,6,5 can i select only the 2,2,6,6? Tha...more >>

I was trying to create an index on a view and realized that some of the underlying tables where creates with ANSI_NULLS set to OFF. Is there a programatic(t-sql) way to turn ansi_nulls on on a table? Steven Yampolsky ...more >>

Hi All I know an SQL Server timestamp seems to be as useful as rocking horse for show jumping, but I'm hoping you know a 'fudge' to get me round a problem or at least confirm that it isn't possible. I have 2 tables, one called ACCOUNTS and one called STOCK. These tables have the usual int...more >>

Can anyone provide me with links, where i can get assignments to practice SQL. panks ...more >>

background: sql2k on nt5 server in the msdb.dbo.sysjobschedules table, when the freq_type = 8 (weekly), there are many possible combinations for the freq_interval, such as 1 = weekly sunday 2 = weekly monday 4 = weekly tuesday 8 = weekly wednesday 16 = weekly tursday 32 = weekly friday 64...more >>

hi all. When i login to SQL using an account different from my NT account the value in master..sysprocesses column NT_username is NULL. If i logged in to my machine and SQL with the same account, the NT_username reflects it correctly. I need to retrieve my nt account information in Scen...more >>

I have a query that the where clause concatenates a total of 5 key fields and checks to see that it is > an input parameter of the same data from the last record pulled from the same query. Essentially a paging mechanism. I did not design this, so I'm not sure why this method is being used...more >>

Hi, I wanted to know if its possible to update a view. I keep getting an error saying 'invalid column' when I do the following: IF (@userMigrated = 1) BEGIN UPDATE vw_MigrationUserAccount SET userMigrated = 1 WHERE (vw_MigrationUserAccount = @oldUserID) END Thanks for your hel...more >>

in my data table I have a DateTime field formated like this 2004-04-08 11:05:30.780 and I want to filter the table BETWEEN one day interval ex.(select * form TABLE where Data BETWEEN '04/07/2004' and '04/07/2007') ) and it doesn't whow anything Eddy ...more >>

i have a sql6.5 database needs to be moved to a sql2k environment. can i use the backup (dump) file in 6.5, restore it to sql7, then backup it in a sql7 dump file, then restore on a sql2k server? Or, dts to move tables from 6.5 to 2k server is the only option? pls advise. thank you all!! ...more >>

Hi, I have the foll tables [CUSTOMER] FIELDS: ID,name,bill [PRODUCT] FIELDS: number,supplier,name (NOTE: supplier = PUBL.code , they are same data) [PUBL] FIELDS: name,code (NOTE: code = PRODUCT.supplier , they are same data) [ARCHIVE] FIELDS: ID,number,quantity,short,da...more >>

Hi, How do I get or what ms name of the componets do I find the following: vbalTBAR6. cREBar cReBar1 cToolbar of tbrMenu and cToolbar1 cToolbarHost of tbhMenu Trying to run a toolbar in vb6... I get these errors but I don't know how to get them. Thanks...more >>

Hi Isn't Microsoft continuing English Query? I have been using it and now find it difficult to continue without much support from Microsoft ...more >>

My mind refuses to work hard today...I'm puzzled when expecting formating result from the following code: select left(name, len(rtrim(name))) as 'object_name' from sysobjects where type = 'P' I'm hoping to minimize the trailing blanks in the returned object name fields. It seems the left fu...more >>

Hi, I have a tool bar in vb6 I want to have at the top of the screen to execute other vb programs. How do I stop other apps (word,access ... ) from covering it up when they open. Only go to the bottom of the tool bar running from vb. Like ms office example. Thanks...more >>

Hello :) I need to migrate completely my SQL Server 2000 from one machine to another. The Source machine is a Dual Processor Server, the Target machine is a Dual Processor Server in Cluster (Two Machines) with a Shared Storage. So, What is the best way for migration? Do you know some articl...more >>

I got the final query, but I get a syntax error near the last line. Can you see whats wrong ? SELECT (SELECT COUNT(*) AS TOTALI94s FROM users inner join attscont b ON b.userid = users.userid WHERE users.FirmId = 1 AND archivedcont = 0 AND I94DateD...more >>

Probably being stupid but here goes... I have a database let's call it MyDb, it is owned/created by dbo/sa however, it's tables and sprocs etc are owned by MyUser. MyUser has datareader/datawriter access and is of the role ddladmin. I am creating a temp table let's call it #myimport and usin...more >>

Do you test this tool? Do you recommend? Pros? Cons? Thanks a lot ...more >>

Hey all, I am running SQL 2k on Win 2k Server. Here's an easy one. What are the benefits of running Integrity Checks on the database? I was reading that this is sort of not necessary anymore since the data model has been changed. For instance what are the ADVANTAGES and DISADVANTAGE...more >>

I have a field that I want use INSERT INTO statements to enter strings with 10000+ characters. Can anybody tell me how to do this? Any help would be really appreciated. Thanks, Mike *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get ...more >>

Hi All, I have a file that has fixed row size of 148 and fixed column size, but the file has no end of line character. I know it is wierd but a client has made the file and refuses to change the format. So I am stuck with reading it the way it is. In Enterprise Manager, I used the Import/Ex...more >>

Hi all, If i have a table UserID LN FN 1 vvv eeeee 2 aaa bbbbb 4 aaa ppppp and a table: myTable EncounterID Note Nurse Operator 98 hahaha 4 1 92 blabab 2 4 I want to select all from encounter with Lastname and First NAme: EncounterID Note Nurse LN FN Operator L...more >>

I am developing a pocket PC application. Here i need to check the existance of a record and raiseerror if does not exists. (sample type of query attached) If Not Exists(Select 1 From Master_Authentication Where User_Id ="Login_User" And User_Password = 'User_Pa...more >>

I have two tables, both have a column named score: testone.score, final.score Is there a way to find the total avg of scores in both tables. I only know how to find avgs for one table at a time....more >>