2003-06-09
career
RE: SQL Server 2000/ SQLXML
ahhh. That was the easy route 🙂 What I thought you want was: <ROOT> <ElementName ATTR1="xxx">Some Value1</ElementName> <ElementName ATTR1="yyy">Some Value2</ElementName> <ElementName ATTR1="aaa">Some Value3</ElementName> <ElementName ATTR1="bbb">Some Value4</ElementName> </ROOT> You can get a lot done with EXPLICIT but it took me a while to understand it. Cheers, Crispin
2003-06-09
RE: import excel file to sql table that has ID field
Hi bud, thanks for the reply. The destination table already has data in it, so I really just want to append the imported data from the source to the destination.I did the following: 1) Left the Identity field out of the Excel source file 2) Defined the spreadsheet as source 3) defined the SQL database […]
2003-06-09
1 reads
RE: SQL Server 2000/ SQLXML
True, but should the objectives of a sporting code be to be played by and appeal to all nations. It is great for athletics and such, however for certain sports I think it is good to retain ethnic and regional traditions and keep 'em tribal. Talk about digression....!
2003-06-09
RE: SQL Server 2000/ SQLXML
This is true but indo so, it keeps a lot of countries out of the sport. Cheers, Crispin
2003-06-09
RE: SQL Server 2000/ SQLXML
..you guys have digressed from my query, but it looks like FOR XML should do the trick. ..I know this is subjective, but I reckon passing the ball forward during sport reduces the complexity of the game
2003-06-09
RE: group permissions
If yuo are saying they have a local account on the server that needs to be used then you can create the group locally and add domain accounts or domain groups to the local group and work with that way.
2003-06-09
RE: Trace DTS package deletions
Andy, sysdtspackages isn't a system table in the same sense as system tables within master and model. Your can define triggers on them. Try the following for logging the activities to the SQL error log. CREATE TRIGGER tr_sysdtspackages ON msdb.dbo.sysdtspackages FOR DELETE, INSERT, UPDATE AS BEGIN DECLARE @msg VARCHAR(500) DECLARE mods CURSOR FOR SELECT CASE […]
2003-06-09
1 reads
RE: import excel file to sql table that has ID field
Leave the Identity field out of the Excel file... it's not needed. In the DTS Import/Export wizard: 1. define your spreadsheet as source 2. define your SQL database as destination. 3. select "copy tables and views..." 4. select your source sheet (eg. tblExcel$) 5. within transformations dialog, choose "Create destination table" and click on "Edit […]
2003-06-08
1 reads
RE: Primary key / DTS load question
-- Assuming, for simplicity sake, that your main table is defined like: CREATE TABLE MainTable ( PKField INT PRIMARY KEY, OtherFields SQL_VARIANT /* or whatever.... */ NOT NULL ) -- I would create a staging table with an additional identity field, thus: CREATE TABLE StagingData ( IdentityField INT IDENTITY, PKField INT NOT NULL, OtherFields SQL_VARIANT […]
2003-06-06
1 reads
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers