What do others do if you need to import excel files into SQL Server? My main problems are 1) zipcode formatting issues. If the column is a mix of...

scoots987

01-11-2008 11:36 AM
Jack Vamvas

I have a package which truncates files, fills them with data and should send a mail with the files as attachment when it finishes running. In...

harp

01-11-2008 11:33 AM
Jack Vamvas

Hi We use Sql 2000. When defining a database maintenance plan one of the options is to optimize the database, reorganize data and index pages, remove...

David Greenberg

01-11-2008 11:31 AM
Jack Vamvas

Dear comp.databases.ms-sqlserver, DataDirect XML Converters are Microsoft .NET and components that provide bi-directional, programmatic access to...

Stylus Studio

01-10-2008 11:36 PM
Stylus Studio

Hi, I have copied a MS SQL database to my local machine and am testing it with ASP pages, locally, on IIS. I have a db connect page that keeps the...

ll

01-10-2008 05:26 PM
Erland Sommarskog

I had to use use ssis 2005 in a short project recently & had little time to work it out. I was importing a whole bunch of flat files into SQL Server...

stephen

01-10-2008 03:18 PM
jgeissman@socal.rr.com

Hi All, I'm having a problem writing an SQL statement that I can't quite wrap my head around. First, the background: I have a journal subscription...

KingofGing

01-10-2008 12:47 PM
--CELKO--

I have a price field that when I query it, it returns the price as "5.0000". What function can I use to return the price as "5.00"? THANKS

Erich93063

01-09-2008 03:16 PM
Knowledgy

Hi, my query is: SELECT a.symbol_art,b.node_key FROM artykuly a, art_podz b WHERE a.symbol_art=b.symbol_art

info

01-09-2008 03:11 PM
Knowledgy

i want raed and write a sql server

pnwramt80@gmail.com

01-09-2008 03:09 PM
Knowledgy

Hey Guys, Total Number of Records (Based on 5 fields): 1000 Total Unique Records (Based on 5 Fields): 990 Total number of fields: 5 I have question...

apatel85@gmail.com

01-09-2008 03:07 PM
Knowledgy

Hello all, I'm trying to generate some XML directly from MS SQL with the following code SELECT 1 AS tag , NULL AS parent , NULL AS , NULL AS ,...

Pacific Fox

01-08-2008 08:39 PM
Pacific Fox

db2 wrote: considered spam.... -- Serge Rielau DB2 Solutions Development IBM Toronto Lab

Serge Rielau

01-08-2008 07:45 AM
Serge Rielau

I am trying to select the max for each Schedule_Number when Process Description = 'Exit Cold Rinse'. In the following table, 2:00 and 4:00 should be...

mcolson

01-07-2008 10:40 PM
Plamen Ratchev

How do I setup a user to access the my sql server database. I do not want to give him the admin account login.

Brian

01-07-2008 05:19 PM
Erland Sommarskog

Subject says it all, really. I want to start using Token Replacement, but do I break anything by enabling it? Do jobs that don't use tokens require...

M Bourgon

01-07-2008 05:14 PM
Erland Sommarskog

I am stumped on the error reporting with sql server. I was told i need to return @SQLCode(code showing if successful or not) and @ErrMsg(and the...

barmatt80@gmail.com

01-07-2008 10:18 AM
barmatt80@gmail.com

Hi, I'm working with a SQL statement to select from tables and only return that which matches the semester AND value of 'N'. The statement...

ll

01-04-2008 03:53 PM
ll

Hi I have a requirement where in i haev to convert the SQL from Oracle to the one which will run on the SQL server. in the Oracle Query i am doing...

narendra vuradi

01-04-2008 07:14 AM
Serge Rielau

Dear ladies and gentlemen, Upscene Productions is happy to announce the major version of their test data generator tool: "Advanced Data Generator 2"...

Martijn Tonies

01-04-2008 03:49 AM
Martijn Tonies

Running a SQL 7 system on a Windows 2000 server using Access 2000 on client machines as a front end. System administrator currently reboots the...

Neil

01-03-2008 11:48 PM
Neil

Recently, I was in a training course about the new features of 2005. The trainer said that 2005 dealt with active/active memory differently during a...

M Bourgon

01-03-2008 09:11 AM
M Bourgon

Dear All, I want to get more than one table columns as a single column by alternative. For eg, Table name = employee columns = empid, empname,...

Ganapathi sundaram

01-03-2008 08:36 AM
Madhivanan

Yikes! My database, which had been consistently 1 gig for a long time, went from being 1 gig to 3 gigs overnight! Looking at the nightly backups,...

Neil

01-02-2008 10:07 PM
Neil

I would like to call this stored procedure, but I am unable to pass parameters to the @Start and @End. Is thier a way to pass parameters to a pass...

gumby

01-02-2008 05:35 PM
Erland Sommarskog

Hi, I have one table name: art column: symbol_art price1 price2 ----------- ------- ------- AG-0001 20 ...

info

01-02-2008 04:19 PM
--CELKO--

Hi We usae Sql2000. I'm setting up backups jobs and need advise. When I run a backup of a database, does it automatically clean out the transaction...

David Greenberg

01-01-2008 04:56 AM
Erland Sommarskog

If I do SELECT TOP 25 * FROM table ORDER BY id does it select any 25 records and then order them or does it SELECT all the records, order them by...

metaperl

12-31-2007 02:42 PM
David Portas

Sono in procinto di passare da access a sql server, per ora passando solo il db in sql server e collegando le tabelle in access per sfruttare tutte...

TheProf

12-30-2007 05:21 AM
TheProf

Hello, I'm sure this has come up for people before. I have two fields in one table that both refer to my users table. TakenByID EnteredByID Both...

Matthew Wells

12-29-2007 06:34 PM
Erland Sommarskog

Someone renamed a server from 2A to A. When I do @@servername I get 2A. The server/machine name is 2. Should my triggers say 2A or 2? Does it...

jantaneey@gmail.com

12-29-2007 06:18 PM
Erland Sommarskog

I am absolute a novice in XML but need to shred XML into SQL Server 2005. I studied some examples, but only with simple XML Docs. My docs seems to be...

Theo Müller

12-28-2007 05:32 PM
Erland Sommarskog

I'm having trouble running TSQL commands when SQL2005 is in single- user mode. I've restarted SQL with -m, -c, -T3608 set in the startup options. I...

Mike

12-27-2007 05:42 PM
Erland Sommarskog

This site really was a surprise. Also check out http://www.justfordiscounts.com that features over tons of retailers and services.I even found...

rzt8lias

12-27-2007 04:00 PM
rzt8lias

I've been using SQL Server 2000 and am not familiar with all the new features in 2005 but I understand it has the ability to make web service...

Lauren Quantrell

12-27-2007 12:03 AM
Lauren Quantrell

hi, all. I want to verify data merged from access in sqlserver.but it has too many records .so i need a tool do this. someone maybe has it. thanks

mymoup@gmail.com

12-24-2007 03:30 PM
Ed Murphy

On Fri, 21 Dec 2007 03:51:41 -0800 (PST), zhuxingsheng (AT) gmail (DOT) com wrote: By creating a Linked Server? Look it up in Books Online. -Tom.

Tom van Stiphout

12-24-2007 03:37 AM
Robert Klemme

For explanations about indexes, have a look at this: http://www.sqldruid.com/Articles/Indexes/tabid/57/Default.aspx Patrice

plevexier

12-23-2007 07:29 PM
plevexier

Hi there, I have a strange problem with an application running on Windows 2000 connecting to a SQL Server 2000 with Greek collation. Runnin this...

rsam2011@yahoo.com

12-21-2007 04:08 AM
rsam2011@yahoo.com

I was asked to look into a performance problem on a newly migrated DB server. The db server was moved from a local-physical-nt4-sybase to remote...

Diggla

12-20-2007 08:23 PM
Greg D. Moore \(Strider\)

I have 2 sql server 2000 database that participate in log shipping. Server A is the source database, which log ships to a database on Server B. The...

Justin

12-20-2007 05:29 PM
Erland Sommarskog

I am very new to all this I have a access databse wich uses a ODBC conection to mysql server. I can open the and run the database find but if i...

S.Dickson@shos.co.uk

12-20-2007 05:18 PM
Erland Sommarskog

I'm developing a library and want to display the alphabets across the screen. When a user clicks on one of the alphabets I want all titles beginning...

JJ297

12-20-2007 03:26 PM
JJ297

In order to run SQL queries without having to fully qualify ownership, I know it's necessary to either give ownership to the DBO or log in to the...

javelin

12-20-2007 10:33 AM
javelin

I have the following query SELECT * FROM ViewName WITH (NOEXPAND) WHERE FREETEXT (*, 'wills') ORDER BY Column1, Column2 This returns 0 results (not...

HardBap

12-20-2007 10:11 AM
HardBap

On Wed, 19 Dec 2007 12:38:57 -0800 (PST), stevedtrm (AT) hotmail (DOT) com wrote: In the long run, for a serious application, there are no...

Tom van Stiphout

12-20-2007 12:10 AM
Tom van Stiphout

= = = > Please forward profiles to michael.vigie (AT) pyramidconsultinginc (DOT) com Hi, Please let me know if you have any suitable references for...

Mike

12-19-2007 01:07 PM
Mike

I need to make a primary key, which constitute two different columns on our MS SQL server. When I wrote the following code I received an error...

YZXIA

12-19-2007 06:49 AM
David Portas

Hi all, I am trying to take the example of Expanding Hierarchies from SQL 2000 Books Online to include quantities. I have changed the BOL example to...

Artie

12-18-2007 10:53 PM
zzzxtreme@gmail.com

I'm relatively new to calling stored procedures, and I have a question about passing in a parameter. Very simple search proc that is called to...

paparush

12-18-2007 11:53 AM
Tony Rogerson