I’m getting an error I don’t completely understand while trying to do some homework for an Intro to Database Management class. Just to give some reference, here is what the question asks: "Create a view called CustOrder which contains the customer number, name, balance, order number, and order...more >>

I have a system that execute queries across two databases. Up until now, these 2 database have been situated on the same server, however the system was built so these two databases could exist across multiple servers. To do this, four part naming was employed, even if the database was on the s...more >>

I am building a template to use for stored procedures. If anyone has any comments, suggestions or advice, please let me know. Also, if anyone has a template that they use, it will be helpful to see it. Thanks, Craig CREATE PROCEDURE StoredProcedureTemplate @Parameter1 char(1), @Pa...more >>

I have two tables Table1 and Table2. Table 1 has columns A1,A2 and A3. A1 is an identity column that has numbers stored in ascending orders corresponding to the number of records in the table. A2 is a varchar column that has the values in it, but not stored in any order. Now I want t...more >>

Hi Had to transfer all apps etc from a HD of a fried computer to a LapTop using PC Relocator. Most things transfered good except MS Developer Edition SQL 2000 Did an unistall of SQL 2K when I found it wasnt working, When I try to Install from the CD a message comes saying "A previous progr...more >>

Here is some drastically stripped down DDL for a Help Desk system I wrote. I only left the relevant columns, and didn't script any of the relationships, etc. CREATE TABLE [HelpDesk_Issue] ([Id] [int]) GO INSERT INTO HelpDesk_Issue ([Id]) VALUES (1) GO CREATE TABLE [HelpDesk_IssueHistory...more >>

I have two tables Table1 and Table2. Table 1 has columns A1,A2 and A3. A1 is an identity column that has numbers stored in ascending orders corresponding to the number of records in the table. A2 is a varchar column that has the values in it, but not stored in any order. Now I want t...more >>

hi all, I am trying to take all the values from a single varchar column and to inset them into a variable so that they are seperated with the '-' sign. I am trying to avoid cursors. by the way- all the rows have a column with the same value in the table for example: create table test (col1 i...more >>

Can anyone see why I would get different GrossSales values by adding the JOIN on LaborJobCosts? ********************************************** This gives the correct GrossSales values: DECLARE @BeginSaleDate datetime DECLARE @EndSaleDate datetime SET @BeginSaleDate = '6/1/2004' SET @EndS...more >>

First, I've data like it field1 field2 ---------------------------- a1 3 a1 3 a1 4 a1 23 b1 35 b1 35 b1 30 b1 ...more >>

I've created a DTS package. Then I want to copy it to another computer (not networking/stand alone). My imagine, it can be copied to disc. So I can rebuild it form its disc. Is My imagine right? or Can I do it? ...more >>

How to passing global variable (type:date) on DTS Package? Because i run dts package, table destination always be empty. exec master..xp_cmdshell 'dtsrun /s . /u sa /p adiw /n Import1 /a Tgl1:7="1/1/2004" /a Tgl2:7="12/31/2004"' Is this syntax corect? Oh yeach....... How to set global var...more >>