I using Windows XP SP2. Install SQL Server 2000 Developer Edition. I want to query a table which contains a column of data type datetime using ASP form, where the input of type text. Before querying I cahnge input text into date format using CDate() function. When I run the query I got th...more >>

Hey I get the following error when trying to connect to my named instance Sql Server running locally on my laptop. Does anyone know how to resolve this I get the following error : Login failed for user:acw Here is my code: SqlConnection sConn = new SqlConnection(server=ACLAPTOP\ACSQLSE...more >>

*** This is a follow-up to my recent post "Distinct For Only Some Columns In A Row". Recently, I posted a question. That question was answered, but a new question surfaced immediately afterwards. What follows is a combination of my former post and the new question... I'm trying to work w...more >>

(first off sorry if in wrong forum -- if so please let me know which is best) Its been a long time since I have done this and need some help! Basically I have two tables that I want to join using a query that works in both SQL 7 and Jet. Here is the select statement I am using: PARAMET...more >>

Hello, I want to retrieve the preferences of a user. There are two table. The first one called tab_org_conf store key-value pairs indicating the default preferences of the organisation the user belongs to. The second one called tab_user_conf store key-value pairs indicating the preferences s...more >>

I have two table one with contact information and one with account information. This is a one to many relationship since one contact can have many accounts. I'd like to merge all of this informtion into one table with the account numbers for a contact all being placed in a memo field. I...more >>

Hi! I have the following master-destails table in my database: www.virtuasoft.com.br/help.JPG Please help in the following sqls: 1. How can i create a SQL that returns all the field from both tables? (i have tried INNER JOIN, but, since Person and Company have different fields, it does...more >>

Hi all, I am creating a trigger for table A. This trigger would insert some values to table B. Problem is, the apss that uses this database is already running for months by now and table A has filled with transaction values. Question: Is there any way that I could run the trigger (thus auto...more >>

Is there a good document for learning different joins in Sqlserver? .I have seen some of them on the net but not very helpful . Thanks ...more >>

I need to write a report that displays the time each operation was started across the page like this: Ord_Num OC020 OC030 ------------ ------------------------------------------------------ -------- -----------------------------------------...more >>

I have table tipDok with primary key, which is varchar data type. The name of the index(primary key) is generated automatically and is: PK__TipDOK__1EC48A19 I select: ALL tasks- Export data in enterprice manager and copy objects option and then select this table to be copied to some other...more >>

The following query gives me some top level and some subassembly levels returned because they are at the same level in the hierarchy. How can I get it to keep selecting the subassembly levels until all returns are top level? SELECT DISTINCT TOP 100 PERCENT Parent_Pfl.PflNumber AS ParentPfl, ...more >>

Hello all! I'm writing a SP to use in my VB.net application. When I run the following query... SELECT MAX(TableID) AS returnvalue FROM TblID WHERE (Inuse = 0) AND (TableID <= 5) UPDATE TblID SET InUse =...more >>

My code in SP DECLARE @sql nvarchar(4000) SELECT @sql = 'SELECT accttype,cocode,coname INTO #tempTable from #myTable ' print @sql EXEC @sql I got the error Invalid object name '#temptable' , Does anyone know the reason ? thanks a lot ...more >>

New bie, I'm using max+1 in select query to get the maximum no of rowz in a table. Thru this i'm generating client ID. For this i used to insert atleast one row in a table while quering . Now i have to generate 1 as for first inserting row. then subsequent rows as max+1. -- Mahe~ ...more >>

Is the following SQL valid in Access? SELECT A.Building, A.AptNum, R.Name, R.AptNum, R.Status, P.Number, P.Type FROM Apartments AS A INNER JOIN Residents AS R ON R.AptNum = A.AptNum LEFT JOIN Phones AS P ON P.ResID = R.ResID AND P.Type =...more >>

Hi, can anyone explain, how to start Query Optimizations ? I think this is a common interview Question... regards Ar ...more >>

Is it possible to rewrite this delete so that a temp table isn't used? key_1 and date_key form the primary key. I want to remove any rows with the same key_1 and a date_key greater than today's date. Cheers! declare @today datetime select @today = getdate() select key_1, date_key ...more >>

Ok, In my c# app, i have a string with an invoice number: "str = 12345". Using sqlserver2k: first of all, i understand the c# requirments for putting a command string in, but don't know the sql command. this is what i need: tblPrintInvoice has one record with this column_invoice_number#. tblI...more >>

Hello, I'm stuck, and I have earnestly searched for an answer to this problem during the past few hours... I'm trying to work with this query: SELECT T1.UserID, T2.MiscID FROM Table2 T2 INNER JOIN Table1 T1 ON T2.ID = T1.ID WHERE (T2.Category IN (2, 3, 4, 5)) AND (T1.ZipCode IN (22201,2...more >>

Hi I have a sql table called Album with two columes The colums are 1)AlbumId 2)AlbumName AlbumID is the primary key I have 4 AlbumIds and 4 corresponding AlbumNames in the Album table I’m trying to remove the last AlbumId and the AlbumName using asp.net enterprice manager. Thi...more >>

http://www.surfjunky.com/?r=cps ...more >>