I am trying to run a simple bulk insert command it says it has completed successfully, but no data gets inserted. Even if i give a bad filename, which does not exist it still says command completed successfully. If i run the same command on a different machine with a different instance of SQL se...more >>

I'm aware that the documentation says that you cannot create an INSTEAD OF DELETE/UPDATE trigger on a table with a cascade update/delete relationship defined. I have even tested this out using the enterprise manager & yes, you get big error messages when you try. However, it was during this t...more >>

I have two stored procedures like procA,procB where procN return results as OUTPUT parameters In procA i have called procB and generate some custom table to return to user But in procB i used some SELECT statements to process data I want to prevent procB to return Result set... Is there and ...more >>

Hello, In a T-SQL Script, is it possible to write some text into a text file? If so, may I know how to do it? Thanks a lot. Sa ...more >>

Hi All, Quick question - when using the week function in analyser e.g { fn WEEK(On_Sales_Date) }, why would the 6/1/04 (6/Jan/04) be coming up as week 2. I thought it would have come up as week 1. Any ideas? Cheers David...more >>

I have one tabel, with 2 columns , named cust and price, i need to make a check or rule ( i dont know ), for block if the price is minor than 50 % of cust, sample Cust Increment(50%) Price 1 0,5 1,5 2 1 ...more >>

I currently have a stored proc that is dynamic. I build it up based in a variety of variables passed in. I would like to move away from this if possible. I have one sticking point, I have a series of statements like this if @language_id <> 'NA' BEGIN set @joins = @joins+' JOIN c_langua...more >>

The DB-library function dbopen() is returning null. When running as a Domain user (SAM) or Workgroup, dbopen() is working just fine. When running as a Domain user in an active directory, dbopen() is also working fine - as long as the user is connected to the active directory. When the user ...more >>

Hello everyone, I am looking for a way to create a cross tab table ( or at least I think its a cross tab tables) however I do not want to too sum the values fro each column up. To explain: I have a table called data whocjh consist sof the following columns. series_code series_data re...more >>

1+A+1 ²Öλ 1+A+2 1+A+1 1+A+3 1+A+2 1+A+4 1+A+3 1+B+1 1+A+4 1+B+2 1+B+1 10+A+1 1+B+2 10-B-1 2-A-1 10-B-2 2-A-2 10-B-3 2-A-3 10-B-4 2-A-4 10-C-1 2-A-5 10-C-2 ...more >>

Hi Everyone, I have the following XML data coming from a VB app and want to pass it to a SQL stored proc which will intern INSERT certain data it into a table. Can someone tell me how to do it? I can't seem to get it. I'm using SQL 2000 with SP3. XML Data <?xml version="1.0" encoding="UT...more >>

Hello, I've been in and out of this ng for a while and I've read that you should really get rid of cursors to increase performance. Well, I'm in a bit of a pickle with this stored procedure and function and wonder if anyone can help me out! My database has a million records scattered over ...more >>

Hi, I am writing a SQL statement which is trying to get the latest record for Each product However, i don't want to use Cursor / Fetch Next method to do so Is there any other ways to write that statmenet? Here are the datatable and my desired result [ContentTable] Type Content ...more >>

I have a data table that looks like this: key f_1 d_1 f_2 d_2 f_3 d_3 ----------------------------------------- 1 da1 zb1 dc1 zd1 de1 zf1 2 da2 zb2 dc2 zd2 de2 zf2 3 da3 zb3 dc3 zd3 de3 zf3 I need it to look like: Key f_Name ...more >>

Hi NG, I defined a database maintenance task as a job. The job will normally be executed by the SQL-Server according it's schedule. Furthermore I'd like to start the job on demand. Before I execute my job with EXEC msdb..sp_start_job @job_name='my_job_name' I have to check if it is already ...more >>

I am going to make a cursor that runs a reindex based on certain fields in the dbcc showcontig return. I need to know if there is a way to get the query that runs the dbcc showcontig procedure where i can pull certain records and do a where clause based them. thanks in advance...more >>

In my search feature on my site, I placed all product names, UPCs, Manufacturer, etc separated by a pipe (" | ") into one field in a table. the table has the fields (product ID, searchText - which contains the info above). now, when I do a search for "digital camera", SELECT TOP 100 tbl_searc...more >>

Hi, I'm thinking of stored procedure, which is called from client application and user interface allows/dissalows deletion of records loaded onto form if references to the table exist. Database records have unique ID; so parameters for this procedure might be targetTable and uniqueID. A...more >>

Hi everyone, Im a newbie at SQL programming, so please bear with me. I have a table with multiple fields, one of which is the "EmailAdress" field. The current format of this varchar field is %lastname%.%firstname%@%domain% I need to write a function/stored proc/query to convert this fie...more >>

Hi, How do I write query for full-text search from multiple tables (which full-text index enabled)? Thanks, ...more >>

All, Here is the UDF code that basically returns the concatenated version of a column based on some recurrence of data column. I need some help in understanding the UPDATE part of the code. I dont see any column name (only variable name @r) in the update command and yet the code works. ...more >>

I have a stored procedure that is executed on every web request that we get. On the web server, I get about 50 Requests a second. After looking into the bad performance I narrowed it down to my update statement in my stored proc: Update tblStats set counter = counter + 1 Where id = @id If I...more >>

Given a server name, how can I tell if it's using Windows Authentication Mode or SQL Server Authentication? I'm retreiving a list of servers as follows: Dim dmoApp As SQLDMO.Application, dmoServerList As SQLDMO.NameList, srvrNm As String dmoApp = New SQLDMO.Application dmoServerList = dmoA...more >>

Hi, my select statement (select tib from table1) returns true or false. tib is a bit value. Can I modify the select statement, so that the return values are Yes or No, or something like value1 or value2. Thanks Otto ...more >>

Hi all, I have a table that holds calendar info with these fields: id, username, date, description. //fieldnames and some sample data looks like: 1, 1, '01/01/2005', 'task1' 2, 1, '01/02/2005', 'task2' 3, 1, '01/03/2005', 'task3' 4, 1, '01/04/2005', 'task4' 5, 2, '01/01/2005', 'jane1' e...more >>

[SQL 2000, writing Tran-SQL]: I have an appliation where I need to create columns in a temp table dynamically. The code is supposed to scroll through #tempA and create columns in #tempB for every record it finds in #tempA. I can't get the alter statement to work when I try to add the column to...more >>

Hi, How can i limit records on insert? I have a table where i store different type of forms. Each type of form has a max for inserting data. The table definition looks like this: CREATE TABLE FORMS ( form_Id int identity(1,1) Primary Key, main_Id int not null, form_type int not null, ...more >>

Hi Guys, I've installed 2005 Management Studio, and would like to know where I could get more information regarding the user interface, and new featuers? Where would be a good place to start? Thanks, Justin ...more >>

Hi, If anyone knows: what is the order in which the Update and Case statement work together when they modify data. Will it be the order in which the WHEN <expr> are listed OR will it be the order in which the rows are listed based on their position inthe table/index. For e.g. in the followi...more >>

Can anyone please advise if there are any obvious problems with the udfGetWorkingDays function and its use in the computed column in the AbsenceDetails table? thanks IF EXISTS ( SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[EmployeeTypes]') AND OBJECTPROPERTY...more >>

I am trying to automatically create linked servers, then extract the DB names from them and delete the linked server. This is for an inventory program I am writing to keep info on all of our SQL Server up to date. The problem I run into is the linked server procedure, even when run with Exec(), ...more >>

I'm trying to create the following function to return a string based on an input string in a complex IF ELSE statement CREATE FUNCTION Describe (@Data varchar(32)) RETURNS @Description varchar(50) -- Description AS BEGIN if SubString(@Data, 0, 5) = "*0020" select @Description = "Nor...more >>

Hi This is a question about "best implementation" option(s) The problem is basicaly a matching service. For example, like in most online dating services. Now, when a male searches for his criteria there will be some results. However, each of the result (female) in turn have their own pr...more >>

What datatype should be used for storing a serialized .NET class instance in a SQL Server 2000 database? For what it is worth, assume the class has 8 fields, 8 properties and 5 methods. Data stored in the class is typically integers and short strings. Thanks in advance. Mark ...more >>

Let's say I'm in the Northwind database and I do this: select regiondescription,territorydescription from region r, join territories t on r.regionid = t.regionid I will get results like: ---------------- Eastern Westboro Eastern Bedford ......more >>

I have two tables, ClientDataStore and AcctStatusHist. Here are abbreviated column lists: ClientDataStore AcctNum char(26), ClientID char(2)... these two columns are a composite PK for the table. AcctStatusHist StatusRecID int identity (1, 1), AcctNum char(26), ClientID char(2), Stat...more >>

I have some sql in a DTS package and one of the fields gets updated with a date variable that is based on a calculation...the problem is that the package will only run fine on any computer that has a local SQLserver on the specific machine...For some reason it will not work on any machine that...more >>

I have a table with provider names and their primary locations (dictionary) and another table with transactions like discharge date and patient account numbers. There is a report(SQL Server Reporting Services) which displays the number of patients seen by each provider in a pivot table for...more >>

Hi If i configure a job to be executed for every sixmonths on the first and Iam starting job on 1st of jan( that is ,it should be executed every year 1st jan and 1july), will it fire on 1st july or 1st agust i:e DATEADD(MONTH,6,01-01-2005) WILL BE 07-01-2005 - MDY R.D...more >>

Hi My problem is a simple one. I build up a connection string for linkedserver but it won't work. EXEC sp_addlinkedserver @server = 'MYSERVER', @provider = 'MSDASQL', @provstr = 'DRIVER=SQL Server;SERVER=MYSERVER;UID=sa;PWD=pass;'...more >>

Hi i want to convert myDateTime to an hour string in the right format so 00 and not 0 when hours = 0, this does not work: select Convert(nvarchar(50),DatePart(hh, myDateTime),'00') from ... any ideas? thanks Ch Tom ...more >>