Given a file name with the path i wan to find the date created or date modified and the version associated with the file using SQL. Is there any way we can do this. Please help. Thanks in advance, ...more >>

Hello, I wasn't 100% sure if this is the best group for this but it's the closest one I could find. I have an SQL syntax question, this code will run against SQL Server 2000 & 2005 database servers. I need to know if there is some way in a select where clause to conditionally convert dat...more >>

Hey, I wondered if somebody could help me, I've got a view, that groups and returns a count of each record i.e CUSTOMER1 3 CUSTOMER2 1 CUSTOMER3 1 CUSTOMER4 2 This works fine What is the best way that would return the following, where (n) is the number of occurances. #Customers ...more >>

New to SQL Server 2000 In my program (vb.net) I want to display the number of records returned by a stored procedure that is using a view in it's select statement. I know I have to define an output parameter. How do I determine the number of rows returned from a standard select statement??...more >>

Hi NG. I'm creating a windows installer project to deploy an application. With this instalation process I wish to create a database and users as well. However I'm having a little trouble finding the right way to script this for SQL server. I've browsed around MSDN for quite a while now ...more >>

HI all, I am looking for a simple way to find all the rows that do not match; If I have a simple join SELECT ExcelImportLookup.MeasureName, ExcelImportLookup.TargetId, ExcelImportView.MeasureName AS ImportMeasureName, ExcelImportView.TargetId AS ImportTargetID, ExcelImportView.ActualValue AS...more >>

Hi, My application gives this error when No of users Increases :Total users are 50 : pls help Error : Server Error in '/webpdms' Application. -------------------------------------------------------------------------------- Runtime Error Description: An application error occurred on the...more >>

Here are my two tables: Accounts: Account_Number Name Address City State Zip Exemptions: Account_Number Exemption_Code Exemption_Description The Accounts table has, of course, only one record for each account number. Exemptions has none to many records for each ...more >>

Hello, I've got 2 tables I'm trying to run a pretty complex stored procedure against, and I'm running into an error. These are my tables: dealers soldTo decimal shipTo decimal preferred bit groups varchar name varchar address varchar city varchar...more >>

Hi, Are LEFT and RIGHT joins different? I can get the same result by using any of them (by re-ordering tables). Thanks, Leila ...more >>

Hello, I would like to build a query within a string variable to execute within a SQL Stored Procedure. I want it to operate something like this below but also check for an empty string in UserDefinedField1 but I cannot figure out how to check for this since checking for '' would kill the @sq...more >>

We can create it from SQL server management studio. But we are looking for a way to script it, and run/create it when needed. Please provide me some help or any links. Thanks, Mike ...more >>

The 'custom_carts' table has these fields: id file_name description thumb_name name position When I do an insert into this table, I want the position field to automatically be the next number higher than the highest position number. Example: position 2 4 1 3 I want the next...more >>

Hi all, Have a problem bu cant seem to find the solution... I am writing a .net web application using SQL server as the db. My problem is this. On the client/web a users makes a number of selections that ultimately are used for the parameters I need for a stored procedure. I have a very...more >>

I am using SQL Server 2000 and am completlely new to SQL Server.. I have a simple stored procedure that has 3 parameters. In the stored procedure I am using a 'like' clause for each of these parms as shown in the actual stored procedure below... ----------------------------------------------...more >>

Hi, is there any predefined format of date like this? 2007-Dec-01 I know that I can do it, but I need to know if there is any predefined. Thank you. ...more >>

I'm a programmer writing my first database application. We have a sql server 2005 database that we need to deploy with our application on CD. We want most of the tables emptying and autoincremental fields resetting, but some of the tables are lookup tables and the data in these needs to rema...more >>

I need to remove triplets from a table. The table can contain triplets but not always. A triplet is duplicates within a 15 second span. Tips on achieving this very much appreciated. Script: Create table: CREATE TABLE dbo.Statistics2 ( UserId integer NOT NULL, EventDate datetime NO...more >>

Hi, I have a col ManualID i.e. abc.xyz, d.dog, df.ghi etc in a col. I want to find the length of the each string before the DOT (.). i.e abc.xyz should return 3, d.dog return 1 I know I can find total length LEN (ManualID).. But how can I find the length before DOT (.)? Thanks, h ...more >>

Hi!, I need to get a set of dates for an specify range of dates in sql server 2000 For example: BETWEEN 2006/12/01 and 2006/12/06 2006/12/01 2006/12/02 2006/12/03 2006/12/04 2006/12/05 2006/12/06 the information is not in a database, I need only a sequence. Thank you. ...more >>

Hello, I am trying to create a simple FAQ system which supports multiple categories and is multi language. I am having some trouble in creating my database structure. Could someone help me out with this or point me to some articles in internet? Basically I have 2 tables: FAQ and FAQLoc...more >>

Figured I'd ask the experts on this one. I was asked to create an automated inventory process, thought it was easy till I looked at the tables involved. Short stort short: Table 1 qty bagqty model part date ( more junk.......) 1 10 710 A 20070122 5 ...more >>

Hi, I am using SQL 2000. Could you please correct the following codes? I could find where I am wrong. Thanks! create table one ( [a] [int], [b] [varchar](9) ); exec sp_help one ; insert into one values (1, 'a'), (2, 'b'); Thanks, Mike ...more >>

Hi, I have data in temp table (#tmpSRNAM) and want to update SRBNAM table if customer number exists there otherwise insert it. I tried to do in following way and it works but i think update query is not organized. Please give suggestion to wtite update query in better way. IF EXISTS(SELECT ...more >>

With MS Server Management Studio, when I right click on the database to back up, I can then see the backup settings. When I click on OK, I then get this error: "Backup failed for server 'our-server' Cannot open up backup device. Operating system error 5(Access Denied)." I thought I had al...more >>

Hi, I have tried finding an answer for what I wish to do but i cannot find anything so sorry if this is already covered somewhere. I have a call to osql and I need to check whether it drops out due to either a general error, or due to a specific situation. I have the following in the batc...more >>

Here's the million dollar question. It's a SQL expression question, having to do with "anything", or "any". I fill up a drop down list with these categories Cars Boats Balls Shoes Then, I manually ad another category.--- the "All" category Now, I ...more >>

Hi guys, sorry if this seems stupid :( I've been assign to build an application that receives some text message via (MAIL or SMS), once I got the text I need, a search through a SQL Server database would be done to obtain a text that will be sent to a mobile phone via SMS, I've read some ...more >>