Programming SQL

Question about getting the day of the week based on single integer 1 - 7
Hi, I have a column, "day," that is an integer. It will hold a single value, 1-7. If it is a one it is Sunday and so on. Is there a way that SQL Server can turn that integer, 1, into the word "Sunday"? Can it read a single integer and turn it into a day of the week? I know DataPart can do it if I have a datet... 25 Jun 2008 12:57

Running a SQL query using a CSV file
Im looking to help automate a manual process right.. We have our payroll department that still running on foxpro db.. they are able to export data out in cvs format.. and that has helped in the past populate our other system by using the bulk insert with those files... Is there a way to accept a CSV file as p... 25 Jun 2008 18:07

Migrating to SQL Server 2005
Hello SQL Gurus, We are migrating legacy application to SQL Server 2005. Can anyone point me to documentation regarding minimum requirements for an application to connect? For example: do we need at lease MDAC version 2.8. ... 25 Jun 2008 12:57

SQL Server 2005 CE and Delphi 5
Is some posiilities to connect SQL Server CE from Delphi 5 ? I'm trying ADOConnection (OLE DB), but without result. One what I done is a message box with "Unknown error" text. Waiting for any sugestions. Best regard. Pawel ... 5 Jul 2008 12:31

truncate table question
hey all, i'm getting ready to import all my tables from test to prod. the first part of my script is to clear that target tables of all the test records by using truncate. is there a way to truncate all the tables at once for a database? or will i even have to worry about that if i'm going to use something lik... 30 Jun 2008 14:48

Display xml elements as multiple rows in a view
Is it possible to display elements from xml stored in a table as multiple rows in a view? For example given the following xml <IsbnResults> <Result> <Isbn14>09780671024239</Isbn14> </Result> <Result> <Isbn14>09780671024246</Isbn14> </Result> <Result> <Isbn14>09780684856476</Isbn14... 25 Jun 2008 11:55

Finding Duplicate Tests - Please Help
Using SQL 2000 - Columns are AssociateID, Associate, [DateTime], [Assessment Test], Score Application provides the students to take assessment tests. They are instructed to only take a specific assessment test once and receive a score. Unfortunately the application will let the student take the same assessment t... 26 Jun 2008 17:44

swapping non-PK data for 2 PK rows
Hi Using SQL Server 2000 SP4. I have a table like so CREATE TABLE [ProgFilm] ( [ProgFilmID] [int] NOT NULL , [PASCode] [int] NOT NULL , [Desc] [char] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [GenreID] [smallint] NOT NULL , [LanguageID] [tinyint] NOT NULL , ... 25 Jun 2008 17:05

update table from excel and validate datatype
Hello, I'm assigned a task to write a stored procedure in sql 2005 to read the data from excel spreadsheet and update table with the data, during updating, the procedure needs to validate the datatype. If not valid datatype, record this row into a log file. This is first time for me to do this, I would appreci... 25 Jun 2008 17:05

Can MSQUERY update data?
Can MS Query be used to update data within a database? I have tried replacing SELECT with UPDATE but no luck... Thanks Richard ... 26 Jun 2008 18:45