Hi, Below is SQL Statment: I am running on SQL Server 2000 MSDE version on Windows2k Professional. For some reason, this query doesn't return the unmatched rows in an OuterJoin query.... it always return only the matched rows... SELECT dbo.DLY_REST_CUSTCNT.mlprdcd AS rest_mealcode, dbo....more >>

Hello all... I'm stuck, I cannot figure out how I should go about flagging conflicts on a sheduling app. I currently have 8 columns (school grades) that have classes over the course of 9 periods. I am populating the ASP page fine, and making changes to the database with forms lists. I need...more >>

Hi all, I have three tables ( Students, Classes and StudentGroup ) I need a select statment that will return the following All Students (from Students) that belong to a certain group(StudentGroup) that did not register for a specific class ( in Classes ) thank you Jim ...more >>

Hello, I'm a newbie in SQL, I use Excel 2000VBA and Microsoft ADO 2.7 library I'm trying to find duplicates in a text file with values separated by tabs. I first want to show these duplicates to the user and then delete them before pasting the query results in an Excel Spreadsheet. So far...more >>

How do you turn off SQL Server 2000 logging. I have processes that run, and if any part fails the database needs to be re-created, so I don't need logging and the performance boost is always needed. Thanks ...more >>

Ranking and Grouping... I have a TABLEA with columns XXX, XPA, xCost, xCustomer, xRank I would like to UPDATE TABLEA with some interger value for xRank WHERE XXX and XPA between the xCustomers are EQUAL and the rank would be 1 to n based upon the xCost WHERE xCost lowest value xRank woul...more >>

Hey, I have a table which contains a col "FILE" of typ "image" and a col "FILE_ID" typ "int". I like to select all rows, where content of "FILE" is identical. The following select SELECT tF.FILE_ID as TOKEEP, tF2.FILE_ID as TODELETE FROM tFILE tF INNER JOIN tFILE tF2 ...more >>

Hello Suppose a database Db1 with tables tl1 and tl2 and a second database db2 with tables tl3 et tl4. Is it possible to make a join between tables of the two databases ? As for example, Select * from tl1 INNER JOIN tl3 where tl1.Field1 = tl3.Field3 How can I update tl1 from data of tl...more >>

I am using DTS to dts over the resultset of a big query on Oracle database tables to a table in sqlserver. However, as the rowsize > 8060 which is SQL server limit. I am thinking to split the query into several new queries, each new query's resultset will be stored in a new table in sql ...more >>

Ok, I run the following query: declare @Ot as VARCHAR select @Ot = 'FolderNode' select ObjectType from ObjectPermission where [ObjectType] = @OT And no results are returned Then, I run this query: select ObjectType from ObjectPermission where [ObjectType] = 'FolderNode' And 10...more >>

My VB.NET application should display current time of sql server in a text box. Presently I am calling "SELECT CONVERT(CHAR(8),GETDATE(),108)" every second from a timer event. Is there any better approach that this? Thanks in advance J Justin ...more >>

how do i use dts to add a text files contents to just one of the tables in a ms sql data base? thanks, trint *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

how can i use dts to bring a text file into just one of the tables in an sql data base? thanks, trint...more >>

Hi there, a small question: Is anybody there with knowledge about the extended stored procedures for the Microsoft Message Queue (xpqueue.dll)? I can't find informations about these procedures and the parameters but I need them. You will be a great help. Thanks Peter ...more >>

Hello! When execute the T-SQL :"backup database dbname to disk='dbname.dat'" multitimes, the dbname.dat will contain multi database backup sets. Can I delete one appointed backup set from within the dbname.dat ? ie.: deleting the backup set with file=3 (or position =3). thanks....more >>