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 ...

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 ...

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

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!

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

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.

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

I HAVE DECIMAL NUMBER IN MY TEST TABLE COLUMN CARD_NUMBER
AS FOLLOWS
2571549730.0
2571549826.0

i have a table which gives me a list of months as records..
ie..columnname : mont
row1: ja
row2: fe

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

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

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).

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 ...

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

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