HI all, Which is better, to use DTS for CSV type file imports or to write your own import app. Considering the following that it is most likely that the structure of the import file will change a few times within the next year, and that this is not inhouse but for an outside client, and that ...more >>

I need to be able to increment a Primary Key of type int without using IDENTITY. The reason is that I need to be able to Archive and restore data to this table, and maintain the Primary Key. Anyway, I setup a trigger to get the Max(MyIDfield) which works fine when inserting single records into ...more >>

Hi Just a quick question, we are thinking of moving to SQL 2005 and I heard somewhere that SELECT *, is not supported in SQL 2005, is this true? Kind Regards Ricky ...more >>

I have installed sql server 2005 express. I would like to administer it as I did with sql server 2000: - Enterprise Manager - Sql Query Analyzer Are there soem tools out there to download? Any help appreciated. Best Regards. Fabri...more >>

Consider 2 tables Tabe1, Table2 which both have int fields fld1, fld2. I can do a Cascaded Select on 1 field: SELECT fld1 FROM Table1 WHERE fld1 IN (SELECT fld1 FROM Table2) or SELECT fld1 FROM Table1 WHERE fld1 NOT IN (SELECT fld1 FROM Table2) and I can rewrite it as a INNER JOIN, no pro...more >>

Im a newbie with a sql table in a MSDE database that contains fields of CustName, BrokerName, Type, Status. I am trying to write a trigger that does this: 1. When a new record in a table is added, I would like the selected fields to be copied to another table (call it Master). 2. If that Ma...more >>

The Domain www.bestwaypay.eu is now for selling. The Domain for OVER 450 Million People in Europe. ...more >>

I would like to split a table in half and save one half for offline archive. ie. move all rows that have COL_ID < 10000 to another database and keep the structures, same index, primary key If I just use an update and delete query it would insert rows incrementally. There might be some delete...more >>

I have to retreive data that is somewhat complicated. This data in the past has required two views and a final ASP SQL Query. I am in the process of updating everything to ASP.Net 2.0 (VB) and would love some advice as to making this more efficient. What I am doing is collecting all of the d...more >>

I have heard that using floats in calculated fields are much faster than using decimals. Is this true? What is the role of the floating-point processor in these computations? Jason...more >>

I need a number generator. (e.g. for Receipt number, or transaction number, etc.) in a multiuser high volume envoironment. What is the best way to get one from SQLserver2005? (no duplicates allowed) 1) I've seen a StoredProc that will get value, value++, then save back, enclosed in a Transact...more >>

I have a field LastUpdatedBy in a table as well as LastModifiedOn. I need to have an insert edit trigger to puts today's date time in the LastModifiedOn and I need to retrieve the currently logged in domain user name and put that in LastUpdatedBy. I need to do it with a trigger. Its in SQL ser...more >>

I'm writing a .NET component that will bulk insert a file into a table. I also have a string array inside the class whose purpose is to capture the errors during the bulk insert process. Can this be done? ...more >>

I have a table which I'd like to create a Primary Key that would have to cover 6 fields to enforce uniqueness. My question is, is that too much. I know it's common to have tables with PK's that cover 2-3 fields, but 6 seems like a little much. [3 int fields, 2 varchar(5) fields, 1 tinyint] ...more >>

Hello, My schema is as follows: Create table Test (Emailaddress varchar(50)) I have numerous rows that have a comma after the emailaddress and I need to remove the comma. Example jonsamules@aol.com, Any help would be great....more >>

Hello, I need to create a view on a database based on tables from other databases. I'm creating a function to lookup the data in the other dbs and use the function on the view. This is the function. CREATE FUNCTION CTI_InventoryView () RETURNS @CTI_Inventory TABLE (INTERID VARCHAR(5), CM...more >>

hi there. please let me know if any of you found a way to set/get an unique row identifier without creating a new column in sql server. i'm in a hurry ... so please help if you can. even with alternative suggestion... thnx. ...more >>

Duplicate Information with Different IDs I am trying to sum monthly hours for weekly timecards which have multiple line items as tasks, but I am retrieving duplicate entries. This is because a timecard can have a timecard_type of "r" (regular), or a timecard_type of "c" (corrected). If the ...more >>

Hello, I've put together a format file for a text file that I need to import using ",\"" and "\",\"", etc. as column delimiters. This would normally cover the whole problem with quoted strings. However, in this particular file if a string value is NULL then that column doesn't have the double...more >>

I've got a question about how clustered indexes map to the physical order of the records in a database. I've always been under the impression that a clustered index orders the records physically in the order of the clustered key. As an MCT, I've taught this idea many times. However, on a ...more >>

I would like to utilize "query notification" (part of Service Broker in 2005) to inform my client app when a database table has been updated. I am using only SQL Server 2005 Express. BOL says: "Microsoft SQL Server 2005 Express Edition (SQL Server Express) database engine supports Service Brok...more >>

I am at a loss...I have tried everything.. Hopefull this is so easy I'm missing it all together. I have a very simple data entry table that is going to be used in other areas (asp, etc.) The table contains several columns. I need to have some of the columns automatically equal the values ...more >>

I have a question regarding database design. Apologies in advance for the length of this post, but I'm somewhat at a loss here. I am creating an items table which will contain records for many different types of products. Each product has a number of common attributes (cost, retail, etc....more >>

Hello: Is there a single, undocumented function in SQL Server 2000 or 2005 that returns the first letter of each word in a sentence or group of words as upper case and the remaining letters in lower case? We can do this with custom programming using a combination of string functions but fo...more >>

I know, I know. It's a bad idea and I understand why. But if DRI across databases is not an option, what are the alternatives? What do you do when you're hired to "sort out the database" and it turns out that the company that hired you has a central database of "reference data" (or several) an...more >>

--I have this temp table: declare @CatRel TABLE ( [Category_RootAndName] varchar(200), [Category_Id] decimal, [Category_Rel_Des] varchar(200), [Category_Rel_Id] decimal, [Category_Rel_Order] int, [Language_Id] decimal ) --I populate it with some data insert into @CatRel SELECT ...more >>

We are in the process of migrating our database to SQL Server 2005 Standard and I have a question regarding disaster recovery and bulk loads. We periodically do bulk loads of data from files (csv's, flat files, etc). Our current database product requires that we maintain a copy of the source...more >>

Can anyone tell me what the SQL requirements are regarding using APS.NET are? For example, can it work with windows only authentication? Are there articles out there I can refer to? Thanks for your help. ...more >>

Hi I have two tables First one contain TransID(Unique key) and Flag Second one contains TransID and Code There can be maximum three codes (Home, Host,Payroll) for a transid e.g TransID Code 120 Home 132 Home 132 Host 135 Home 135 Payroll 1...more >>

Hi. We are using a partitioned view across a number of tables. They are partitioned on a single column. We use the view to insert and update rows in the underlying tables. When loading all the rows for table XYZ through the view we find that SQL Server is creating IX locks against all of th...more >>

Dear group, how do I get all authors together with their sales.qty something like this: use pubs go select au_lname, qty from authors left join titleauthor on authors.au_id = titleauthor.au_id, sales where sales.title_id = titleauthor.title_id go I'd like the query to return only 23 rows f...more >>

hi There is a problem with sorting in db with SQL_SwedishStd_Pref_CP1_CI_AS collation. As I'd known there is a specific rules in the swedish language, one of which is 'V' = 'W' (this rule was revoked by swedish academy since april 2006 - http://blogs.msdn.com/michkap/archive/2006/04/25/583307...more >>