I have to write a SQL script to update a table named PA with a column heading of testone update the qty from 10 to 20? ...more >>

I am currently working with 3 tables. Table1 has records that have an effective time stamp according to a store number, or ALL stores. Table1(RetailID, effectiveDate, storeNum, price) Table2(RetailID, SKUID, vendorID) Table3(SKUID, Size, desc) I am currently working on a way to get the SK...more >>

I am using MSDE-SP3a on a Win2K-Pro PC. I am trying to concatenate a field (type TEXT) with another field (type TEXT) from another table. I have followed the example in the BOL but it appers as though my resulting field is not being updated. I don't know what I am doing wrong, any sugestion...more >>

Hi, I attached my DB with a new name and the datafile name remains the old name - how can i alter this name ? Thanks in advance ...more >>

I am trying to email three reports in a single email. I have written a TSQL stored procedure the mixes print statements and select statements to display a report. The stored procedure works fine in query analyzer. However, when I specify this stored procedure as the sql in xp_sendmail, ...more >>

I need a query that will do two things: 1) return the information in a table based on time 2) limit the returned information based on a criteria. (I do not want to see duplicate records and would like the query to return one record based on the max part number) I have figured out the first ...more >>

Hello I thought I was being clever when I arranged a field that could hold any note in it, to be specific and hold the text part of the entry in [ ] and the date enclosed in || (two pipes) example: [RoutingCircuit1, |12/12/2003|]-- Now we want to pull out only what is between the two pipes and us...more >>

I would like to execute a DTS on a server from a VB application, how can I do this Thank Bradley...more >>

Hi, Is there a way to retrieve a date using a t-sql query while specifying variables? e.g. I want the dates (dd/mm/yyyy) for all the Friday's in December Thanks in advance. Phil...more >>

Help, I have a query as follows:- SELECT count(*) as counter FROM tblProvision WHERE (tbl1.field1 = CONVERT(DATETIME, '2003-11-30 00:00:00', 102)) AND (tbl1.field2=N'SHL') and the result is 4 instead of 400 (actual record = 1000) but when i removed either one of the criteria as the f...more >>

Hi .. I have upgrade my Server from SQL 7 to SQL 2000. I have done a backup for the SQL 7. How do i use the backup files ( *.dat ) from the SQL 7 to restore it at the new Server 2000? I have encounter error of different file id. Is there a way to recovery back from the backup files? ...more >>

Hi All, On SQL server 7.0 Is there any way to show my current SQL Server service pack? ...more >>

Is there a way to determine the sort and collation settings that are configured on a SQL7 Server?...more >>

Will scheduled backups run if Enterprise Manager is open? ...more >>

Hi, I am in EM and SQL 2000 on w2k sp3. I shrink the log files and then shrink the database but my disk size is not decreasing. Can some please explain to me how to free up disk space when truncating the logs. Any help would be greatly appreciated as I am a newbie. Thanking You Steve...more >>

I am working in SQL 2k and trying to teach myself on the go...I have run into a query/situation that I can't get to work. I was hoping someone here mmight be able to point me in the right direction. I have a case managment DB that is tracking, among other things, contacts and their addre...more >>

Can one use Linked Servers to link back to the same server? If so, how can one perform this operation? fulvio ...more >>

Hello, I am having problems with the datatype date. I sometimes want to refer only to the time part of date to display in my Access Project form field. In fact most of my current forms separate time from date and deal with both separately, this is possible in Access. Though cases a problem...more >>

How to display the Record nUmber alongwith other fields. For example if i have table with name and address, I would like to have the o/p as Record# Name Address 1 xx yyy .... through SQl...more >>

Help.. Any possibility to find the maximum value from thousand of records using SQL Query ? Let say I want to find 10 records which have the maximum value....more >>

Dear all, I composed a query, which runs as follows: SELECT GLDOC AS Doc_Number, GLAN8 AS Address, GLDGJ AS range FROM F0911 WHERE (GLAN8 = 20102) AND (GLDGJ BETWEEN 103305 AND 103334) OR (GLAN8 = 900010) ORDER BY GLDGJ However the query always return...more >>

I have a field with 3000 characters, when I do a select the field, I can only see part of it. What is the command to allow viewing of the result set? ...more >>

Hi All, Our SQL server 2000 was installed last year. I don't think I have the latest service pack applied. Is there any way to show my current SQL Server service pack. Thanks...more >>

hi, I am a newbie with SQL 2000. In sql 7.0 I used to right click the database and truncate the log, and shrink the database. Is there anyways in SQL 2000 that I can truncate the log without using query analyzer. Thanks Steven...more >>

Hi, I would like to attach a new database to our SQL Server, how should I do? Database is "ccmdb2.mdf","ccmlg2.ldf" My instance is: sp_attach_db 'ccmdb2', filename1='f:\Win2kEsp\MSSQL7Data\ccmdb2.mdf', @filename2='f:\Win2kEsp\MSSQL7\Data\ccmlg2.ldf' And I get the following error: ...more >>

Hi, I have to import a database in SQL 7.0 Service Pack 4 from which I have the *.mdf and *.ldf files in a new server. The problem I get when I do "sp_attach_db" is: "Server: mesagge 1816, level 16, state 1, line 1 Cannot attach db due to the difference in Character Set, Sort Order or Un...more >>

Hi.. I got a problem for SQL 2000 Advanced Server. Error No.9004 and Description is "An error occurred while processing the log for Database ...... .mdf" I lost one day data transation.Please help me to how to recover my dbase. ...more >>

Thanks, Pedro Rodrigues pedro@markdata.pt ...more >>

I would like to run a SQL Query that pulls data from one SQL Server and then executes some commands on another SQL Server. Is this possible Thank Bradley...more >>

I have a table that has a list of SQL Commands. Each command is in a seperate row. What is the best way to run these, so that I can schedule them with a DTS? Thanks Bradley...more >>

I ran the installation instructions for MSDE, using my student Microsoft Office Professional diskette. I cannot start MSDE, however, because the SQL Server Service Manager has a note at the bottom COMPUTER - Not conntected. The "Server" line is greyed out. I had a problem with my instal...more >>

I'm working on a developing a database and I am the only user attached to the SQL server. I am using Access 2002 to interface with SQL 7.0 and I can create a record but when I try to delete it I get the following error. The Microsoft Jet database engine stopped the process because you ...more >>

we're trying to do a case sensitive sql query with php over odbc. can somebody help... we tryed to convert the data into binarys before comparison but without result... any help would be great, thanx in advance!...more >>

Why i cant get the exact total sum figures for the following queries, select sum(cast(tblProvision.sp_open_balance as float)+cast (tblProvision.sp_charged as float) -cast(tblProvision.sp_written_back_amount as float)-cast (tblProvision.sp_written_off_amount as float) -cast(tblProvision.sp_l...more >>

I'm starting to learn vb.net after purchasing Visual Studio.Net Academic. I was wondering is there a built in SQL Server to work with or do I have to buy SQL Server? Because when I try to use the pubs or northwind database I get a message that the SQL Server does not exists or access deni...more >>

Hello, The following query works correctly. Although I would like to collect all orders after 10:30am however when I replace > 10 with 10.3 or 10.5 neither works. SELECT OrderReceived.OrderDateReceived, OrderReceived.Supplier, OrderCodes.OrderCode, OrderReceived.OrderTimeReceived, DATEP...more >>

help ..pls, how to use sum statement in SQL. If msaccess used, select sum(field1) as totalfield1 from tableA .... how about sql query analyzer? I tried to use sum(cast (field1 .... with 2 decimal points but the sum result is not accurate. ...more >>

What would be the command to UnCluster and ReCluster a Primary Key via a command statement I tried the following, but the drop command did not work for a Primary Key Drop Index Release_SubPart.PK_Release_SubPar create clustered index PK_Release_SubPart on Release_SubPart (Project_ID ASC,LineItem...more >>

This sort of relates to a prvious post with subject monet format. I have multiple fields with type "money". I have converted them using: convert(varchar(25), field1,1) AS field1 I have five fields that will be for mileage in an expense report. I want the mileage to be entered by the...more >>

Help me, pls.. How to DELETE record for tableA.field1 which matched to tableB.field2 using sql query analyzer ...more >>

hi, I'm having trouble fetching all data from a varchar field in php, and I'm told changing the datatype from varchar to text will solve this. My concern is that since my table is already filled with data, something will go wrong if I alter the datatype now. Will I get into trouble or ca...more >>

I have a query that select a column of text data type. SOME of the returned records are with a carriage return at the end. It becomes a problem when I have the query result saved as a text file. How do I get rid of the carriage returns?...more >>

I want to display the next date of the specified day name Like in Oracle NEXT_DAY function. I'm migrating Oracle Query to SQL server. Query is having NEXT_DAY() function in oracle. How do I convert it to SQL SERVER. Please send me the example query in SQL SERVER. for example Today is w...more >>

I have a databse with numerous columns in it. I am outputting the dtat to an ASP page using the Frontpage wizzard. I am using a custom query. It looks like this: SELECT break_mon, break_tue, break_wed, break_thu, break_fri, break_sat, break_sun, break_mon+break_tue+break_wed+break_t...more >>

Hello, On trying to reinstate some lost joins between tables I receive the error msg: "Unable to create relationship FK_Delivery Discrepancy _Suppliers' ODBC error: [MS][ODBC SQL] ALTER TABLE statement conflicted with COLUMN FK constraint FK_Delivery Discrepancy_Suppliers'" ...more >>