hi, i have used apt-get upgrade from a debian sarge and a paquet add "expire_logs_days=10" line in my.cnf, i have uncomment this line and now mysql works well.. i'm surprising not all linux users have this trouble... ...more >>

Our web application requires that when a new Organization is created,a separate Database is to be created for the corresponding organization, so that each organization remains a separate entity with their corresponding employees(This is our clients requirement, so that they can later provide the...more >>

Hi there! I need to write a trigger that will check referential integrity of my data. I have few FOREIGN KEY constraints but, as You probably konow, the cannot be deferred (in the meaning of SQL 92 standard). So I decided to add NOCHECK CONSTRAINT ALL to the modified table and then run a trig...more >>

Hey folks, I'm looking at making the following query more efficient potentially using the ranking functions and I'd like some advice from the gurus. The purpose of the following is to have a status for a person, and also have a historical background as to what they've done, status wise. This w...more >>

I'm trying to get a UNION of UserIDs from multiple subselects. The original query--which puts all the found UserIDs into separate columns, looks like this: -------------------------------------------------------------------------------- SELECT tmp_MY_TABLE_2_3_4.LAST_UPDATED_USER_ID AS User...more >>

Hi, I have a query which works for one day: SELECT SOME_COL AS something, SOME_COL2 AS something2 FROM myTable WHERE DATE = '2007-05-11' AND SOME_STAT > 1 Returns something something 2 1 2 3 4 How do I get this to work for a date range (e.g. DATE > '2007-...more >>

hi..i'm new in sql progaming, i try to make make a query that in table field "match" return to "1" if no member record in another table and return to "0" if there is any record member : ex table member: member id A 12 B 14 Table Incoming. membe...more >>

hi..i need help for my exam, I retrived data from my sms inbok and insert to table.The record just like this: ID1,12x100,56x12,90x90..,how to pars the table in to: ID First Second ID1 12 100 ID1 56 12 ID1 90 90 Thank for your help... =================...more >>

(Pardon me for asking a very basic question. I have come back to SQL Server after five years of Oracle, and my memory is a tad rusty). I have a bit of SHOW_PLAN output that I believe that I understand, but I would appreciate your comments if I am wrong. I have a requirement to produce a list...more >>

Could someone tell where I can find out if it's true that during UPDFATE SQL Serve deletes data from table, and then inserts new one. Thanks -A ...more >>

What is the best way to essentially use the charindex(find) function if the value is could be more than one variable (A or B or C) I can't seem to get an "or", "if" or "select if" to work Below is the code that works, I need 'GOV' to be either 'GOV' or 'FWD' or 'LIB' sqlstring = "...more >>

Hi, I have a requirement to design a query that identifies items sold between two dates. There is a 'SoldDate' datetime field used to register what date the item was sold. The query needs to identify all sales between the last day of the previous month and going back one year. What I...more >>

Hello, I'm trying to import a Xml file in a table. It's working find, but when the data are inserted, my trigger on this table doesn't work ? I put my code below. Best regards Thank's David Xml file : <?xml version="1.0" encoding="ISO-8859-1" standalone="yes"?> <RTAVIS> <FIL...more >>

Hi All, I'm trying to write a query that gets more granular as criteria is available. for example: select name where A is true, B MIGHT be true and C MIGHT be true. Is that possible? The idea is that the more information available the smaller the size of the dataset. Thanks for any inp...more >>

Ok a newbie here... i have a sql server db I got from a book to learn. I am having problems with the 'Authentication' mode. I need a valid id to be authenticated with... i have a web config file but I am not sure what goes where? name of server MKLAPTOP\VAIO_VEDB connection MKLAPT...more >>

Hi, I need to output result of my query to txt file. So I'm using -o parameter, for example: osql.exe -s (local) -d database1 -U sa -P sa -i 'c:\\queryFile.sql' -o 'c:\\output.txt' But it clears existing output.txt file first and then outputs the result, while I need to append the result o...more >>

Experiencing a little weirdness with SQL Server Management Studio... Have created a login, that has fixed server role "securityadmin". The login can create/drop logins, add/remove them as users in databases, etc. The login can change another login's password, using SQL from a query window (...more >>

hi All : I have an insert statement which reads INSERT Into TableA (Col1) SELECT CASE WHEN Col1 LIKE '%[a-z]%' THEN 999999 ELSE Col1 END AS Col1, FROM TableB ********************** TableA. Col1 has a datatype of Int. TableB. Col1 has a datatype of varchar. My insert is failing as ...more >>

Hi, I have a problem which I don't entirely know how to tackle: Essentially, is it possible to query a web service (via http), using sql server 2000, and then import that data in to the database? I have seen many posts on openxml and sql servers bulk load facilities but nobody seems to me...more >>