I need syntax for a Microsoft Access database query. I have a table with 40,000 records. One field has directory paths with backslashes for each subfolder. Let's call that field 'backslashes'. Some records go 9 (nine) levels deep. I have another field, let's call it 'qtybackslashes'. I need a query ...more >>

Good day We recently change our PC's to Windows XP. I reinstalled all of my application programs including Centura. This is a quite an old version (95/NT), but is the only one we are going to work with for now. Every time I try to run the program, the Windows Installer popup window comes up. I h...more >>

I have a table where the columns are products and the rows are customers. It stores sales info by customer and product. I would like to add a row at the bottom af my customer list that would be used for totaling each column. Does anyone know how I can do this?...more >>

Any ideas how to make NOT IN more efficient? I need to use it for a subquery on a table with 15 million rows and it's taking much too long. Thanks for any ideas!...more >>

All I need to count dates in a column but how can i cut of the time hour minutes and seconds I need to rport how many records hav been added on one date... con someone help me getting on the richt track regards ...more >>

I get this message again when I run this script: BACKUP LOG wslogdb62 WITH TRUNCATE_ONLY DBCC SHRINKFILE(wslogdb62_log, 1) This is the error message Server: Msg 8985, Level 16, State 1, Line 2 Could not locate file 'wslogdb62_log' in sysfiles. DBCC execution completed. If DBCC printed er...more >>

Hi thanks for reading I have 2 tables. The first has employee information and the second has payroll information. I need to find out people who are not in the payroll but in the employee table. Since the payroll has multiple instances i have to filter it and find out for each payroll. I...more >>

Hi I am trying to write SQL automation that runs SQL scripts against the daily drop of the database. Each day, a new DB is created using the format (Testdb + xxxxx )where xxxxx= computed build number. Thus today's db name might be TEST12345 and tomorrow would be Test12346. I have a script that ...more >>

I have written several stored procedures on my local SQL server database. Through my coding i will occasionally change the case of a variable. For example I will declare a variable @SQL varchar(20) but later call it @sql (lower case). My sql server isn't case sensitive, but other databases I h...more >>

I need a SELECT query that can compare/match a string value, example, tableX.number = '12345' from tableX, to tableY.URL = 'http://www.domain.com/folder/name-12345' so the WHERE clause can match the two by the full value of tableX.number to the partial value at the end of tableY.URL An...more >>

Hi I have a column in an SQL table. the column is all numeric data from 100 to more than 400. I would like to convert the data in this column to something else. e.g. micro = <200 mini = between 200 and 300 midi = between 300 and 400 full > 400 can anyone advise me how to write a que...more >>

i have a table which gives me a list of months as records.. ie..columnname : mont row1: ja row2: fe row 3: ma and so on. i want to make a column..where these months appear as column nam ie...column1: ja column2: fe column3: ma also...what i want is if in the first table...any m...more >>

I HAVE DECIMAL NUMBER IN MY TEST TABLE COLUMN CARD_NUMBER AS FOLLOWS 2571549730.0 2571549826.0 2571550034.0 2571550210.0 2571550306.0 2571551378.0 2571551586.0 2571551682.0 2571551762.0 2571551874.0 I WANT TO CREATE A TEMP TABLE AND MOVE THIS COLUMN BUT BEFORE MOVING IT SHOULD CONVE...more >>

Dear Friend I want to know that particular colunm is exist in table or not. if not exist then i want to create it regards ashish...more >>

This is regarding a SQL Select statement I have a table with 3 columns First Name, Last Name , CompanyName I want a result of companyName, using a select statement with the condition that if CompanyName is Null then result should have LastName + FirstName something like if CompanyName ...more >>

This is regarding a SQL Select statement I have a table with 3 columns First Name, Last Name , CompanyName I want a result of companyName, using a select statement with the condition that if CompanyName is Null then result should have LastName + FirstName something like if CompanyName ...more >>

Dear Sir I want to retrive data that will return 3rd largest salary paid employee from employee table using sql query. thanks...more >>

i have a table where daywise i have details of units sold..i want to have a query which takes today (getdate()) and then calculates the no.ofunits sold in 7 preceeding days as week1, 8-14 preceeding days as week2, and so on for 3 preceding months (approx 12 preceeding weeks). can anyone plz sugges...more >>

I am running SQL server 7 on an NT 4 server here in the UK which has a table containing French and Italian wine names. Most of the characters with accents are recognised fine but not the letter c with an acute (/) accent on it (the database records are populated by typing it out in Word an...more >>

Hello, I have a table with 200,000,000 records and need only 20,000 or 6 months of historical data. Ive created a temp_tbl and I'm inserting the 6 months worth of data that I need. Can I use the truncate command???. Can I use it to bring the temp_table data back to the original table w...more >>

Hello Unfortunately I am attempting to do something a bit weird, in an endeavour to retreive a unique numbe from a table that I've just stuck onto my SupplierOrders table as a kind of join between my database an the company non-normalised database. These are the instruction of my manager, very s...more >>

Hi! I have a table with name "Bestand". The table has 280 columns. I thought to do an index for some columns, because i heard that you are going to get faster results if you do some indexes. But i get this error: 'BESTAND' table - Unable to create index 'IX_BESTAND'. ODBC error: [Mi...more >>

I want to do a select on a field and get the data lengths in the field but sql tells me I can't because it is ntext. -- thanks marty...more >>

Cannot insert explicit value for identity column in table 'INCOMING_TEMP' when IDENTITY_INSERT is set to OFf...more >>