Programming SQL

Cannot read data from server easily?
Hi I use ASP, SQL server with a EdgaCam database (that is a CNC tool) when I read data, I need to read out the fields in the right order, otherwise they are empty, such as: rsJob.open="select job.[description],job.[comment],job.[sequence], job.[nc file], job.[revision],ListJobStatus.[job status],ListJobSt... 7 Jul 2010 10:10

Using COM DLLs from SQL
Hello, I am out of ideas! I just keep getting:- Error Source Description ODSOLE Extended Procedure Invalid class string When I run the code below DECLARE @comHandle INT DECLARE @errorSource VARCHAR(8000) DECLARE @errorDescription VARCHAR(8000) DECLARE @retString VARCHAR(100) -- Ini... 7 Jul 2010 07:58

Need Help for a Join Query
Hello friends I need help for the below query. My table structure is as such ------------------------------------------------------------------------------- CatCode | GradeCode | ItemCode | HeatCode | SizeLot ------------------------------------------------------------------------------- 01 | A105 ... 9 Jul 2010 04:00

Table relationship
Hello, I have a table, USERS, where I hold the Username, Password and Email of all users. Each user can be a student or a professor. For a student I need 3 more fields: NAME, BIRTHDAY and CITY For professor I need 4 more fields: NAME, CV, CITY, PHONE. Should I add all these fields to USERS table and lea... 13 Jul 2010 09:48

query question
Can I create a query that will replace @abcwest.com with @abcbest.com in the table Customer column email and cc ? Thank you ... 6 Jul 2010 16:42

Query question with 3 FKs
Novice Query question: I have a table with 3 foreign keys, for example: Notes ID as int CreatedBy int ;FK User_table.ID AssignedTo int ;FK User_table.ID ClosedBy int ;FK User_table.ID Note nvarchar(max) and a talbe of users, for example Users ID as int Name as nvarchar(50) Initial... 6 Jul 2010 21:09

SSRS2008 connecting to Oracle
Hello, [SQL2008] & [Oracle 10g] Iam trying to connect to an Oracle database from SQL2008 Reporting Services but Iam facing an error. This is what I have done: - Installed Oracle Client 10g software in the same machine as SSRS2008 - Configured and successfully tested Oracle service name. This is the snippe... 6 Jul 2010 12:17

Invalid Class String
Hi there, Did you every get an answer to this problem? If so, can you tell me whatyou did as I have the same problem. Thanks Mark Tallam wrote: Invalid Class String 14-Mar-07 Hi Guys, I have been breaking my head to solve the simple problem.I am not able to open the DTS Package this is giving... 6 Jul 2010 11:11

How to retrieve all data of a table(with only 3 rows and 3Columns) in only one row in a view?
Hi i have a table table1 in sql server database with 3 columns and 3 Rows like Column1 Column2 Column3 Data 11 Data 12 Data 13 Data 21 Data 22 Data 23 Data 31 Data31 Data 33 i would li... 4 Jul 2010 17:45

Need help with this query
I need to pull data from the table below for anyone who has donated $1000 or more in at least 3 years between 2005 and 2010 with a lapse year in between. In other words they skipped a year somewhere. Here is the table layout CREATE TABLE [dbo].[Donations]( [ID] [varchar](10) NOT NULL, [FiscalYear] [int] ... 4 Jul 2010 00:26