Hi ! sorry to bother you again with that topic..but... Bulk Insert inserts null value when it finds null string in my source file to load... is there any way to prevent this?? I would like to get null fields instead of NULL value in my base.. thanks again :) ++ Vince...more >>

Hi, I have a string which contains some german characters e.g 'Menü'. I am converting it to upper case using wcsupr (). But ü is not converted to Ü. There are other characters too. I can use the _wsetlocale () function before using _wcsupr (). I cannot use the current machines locale sett...more >>

Hi, I tried to the following but i'm getting an error near '.' Can someone tell me if this is correct? Here is my syntax to backup a database from another location: BACKUP DATABASE [192.168.160.20].Mydatabase TO DISK = N'\\BACKUPSERVER\Backup\Mydatabase.bak' ...more >>

Hi, I have a query that is supposed to return records and make a left join where one field is not null, but for some reason is not working properly and returns the records even though they are null. ---------- SELECT * FROM cases a left join activities as w on a.id = w.caseid AND w....more >>

Greetings, The following crosstab/pivot query is not working. create table tbl2( col1 varchar(10), col2 varchar(10), col3 char(1) ) Insert Into tbl2 Values('dbo', 'area1', 'A') Insert Into tbl2 Values('dbo', 'area1', 'B') Insert Into tbl2 Values('dbo', 'area1', 'C') Insert Into tbl2 ...more >>

Hi, I have a query that is supposed to return records and make a left join where one field is not null, but for some reason is not working properly and returns the records even though they are null. ---------- SELECT * FROM cases a left join activities as w on a.id = w.caseid AND ...more >>

If I have an Identity column defined as a smallint seed=1, increment=1 Does it automatically roll back to 1 when the number of records reaches 32,767. Assuming of course, the last record assigned identity 1 has been removed. I assume it does, but hey, I've assumed stuff like this before ...more >>

I'm trying to do something like this: ALTER TABLE [tablename] ALTER COLUMN [fieldID] int; I've tried several versions of this, and the data type is never changed from numeric. I have removed all indexes on the table and it still doesn't work, no error messages or anything. I am trying to...more >>

Hi all, I'm having trouble coming up with the correct MS SQL statement to do the following operation. I have two tables: Participants (p_id, p_fname, p_lname) Participants_Keywords (pk_p_id, pk_keyword) I want to write a query that matches participants based on the keywords they s...more >>

I have been seeing a high CPU load on one of our SPs and the main cause of it is a function to find the minimum date of 3 dates. The SP updates 3 date columns and also needs to store the earliest of the 3 in another column. When I use a function to return the minimum date, it works, but it for...more >>

We're starting out some development efforts here at work (with SQL Server 2000) and I'd like to know where I can find some best practices regarding migrating changes from your test sql server to your production server. The basic iteration as I see it is: 1) Create initial database on produ...more >>

Hello All! Is there a way to write this SQL without a UNION, because where i have to set one field to null to match the number of field of the second sql :( SELECT ('Caixa' + ' - ' + Nome) AS Nome, Caixa.CaixaID AS ID, NULL AS AgenciaID, 'Caixa' AS Tipo FROM Caixa UNION SELE...more >>

I have a self-referencing table, with a parent child relation (parentDepartment) How do I select a table of a single department and all it's children and grand children and their children etc. using TSQL? I'm guessing I need some sort of recursive function? ...more >>

Hi, all. How does one list all the user-defined objects (tables, udf's, udt's, stored procedures, and views) for a SQL Server 2000 db -- the ones owned by dbo? Thanks. ...more >>

I need to create a trigger that will run whenever a record is deleted. I want the trigger to delete records from table2 where the value in the ID field matches the value in the ID field of the record being deleted from table1. I'm new to triggers and am not sure how to set this up. Tha...more >>

I need some assistance... I have a column of numbers, in varchar format (I made a mistake, should have defined as numeric) but to further compound the problem, users have entered amounts, in this field, for example: 123 123.00 123.12 12345 12345. 123456.77 .... etc What I Would ...more >>

I am experimenting with a table in the Tables view. I chose to Open Table | Return Top from the right-click menu and made an edit to a row's field. It was previously <NULL> and I want to set it back to its default value. How can I do this within this view? If I can't, how can I do this wit...more >>

Hi, I'm seeing something that I don't understand and really need to know "why". I have a view (call it V_1) that is generated by a statement containing a correlated subquery. Assume a table T_1 that has 3 columns: two ints (say C1 and C2) and a smalldatetime (say C3). The sql to create V...more >>

I'd like to know if there is a way to select a subset of rows from what would otherwise be the entire result set. I know you can build a query with "select top x", where x is the number of rows you would like returned from the top of the result set. I'd like to be able to produce a select ...more >>

I'm just getting up on SQL and I have a very basic issue. How would you implement a "loop" or FOR/NEXT directive in SQL. I have looked around and do not see anything that seems like a likely command. Thanks in advance for your input....more >>

I'm trying to create a unique clustered index on a view, I have set the proper SET options, used 2 part naming, explicitly named the columns, the objects are owned by the same owner (dbo), the objects are all in the same database, the tables are all contain a unique clustered index and a c...more >>

I have a table that contains a date field called trans_date and a string field called card_name. Basically, what I need to do is check what card_name has. If it has 'A', then I need to add 30 days to trans_date. If it has 'M' or 'V', then I add 2 days. Once I add the days, I need to check...more >>

Hi, I have a StoredProc (using Cursors) running on SQL Server 2000. I use DataAdapters from ADO.Net (2K3) to fill the DataSet from a Win App. But the number of records returned in each case do not match. Further, the DataSet has different # of records when invoked from the ADO.Net method...more >>

Hello, Who can help me with this issue: I've a database with a field "Value" that is of the data_type nvarchar. There is also a field "Method" that has the value "DateTime" if the content of the field "Value" has a date and time value in the format "dd/mm/yyyy h:mm:ss". If the record h...more >>

Dear all, one of my custoimer request is the possibility to import graphics inside a database field, graphsics usually coming froma scan document or picture. Format could be gif, jpeg, bmp etc.. First of all is it possible to do so with SQL server ? If yes, how the graphics is stored i...more >>

Using ADO's GetSchema method with SQL Server 2000 (provider = SQLOLEDB.1) to return a column's data type, my VARCHAR column is returned as adChar. Getting the type via ADOX gives me the correct value of adVarChar. I have my workaround but is there any info on this e.g. known issue, KB arti...more >>

Hi I am looking to create a simple trigger for both UPDATES and INSERTS where any change to tbl1 will be inserted/updated in tbl2. The insert works okay, with values added to both tables, however when I perform an update, it seems to add an extra row in tbl2. Here's the code: CREATE TABLE [...more >>

Hi I have the problem with the DISTINCT keyword. I used the following statement to get the distinct values from the table: SELECT DISTINCT trade_name FROM Customer This works absolutely perfect getting the distinct values and getting in sorted order. But my requirement needs the stateme...more >>

Hi Guys, I am using sql server 2000 and i want to find missing number between 1 and 1000 in a table. what is the query for that? pls advice me. RGDS Biju ...more >>

Does anyone now how I can create a SQL function to return a week number for any date with the following guidlines? -Weeks begin on a Thursday and end on a Wednesday. -1st January is always in week 1. -Week 1 for this year would go from 30/12/2004 to 05/01/2005 I have been going round in circl...more >>