Hi Is there a way to remove duplicated records Also if there is a way what about records that are the same except the key field, is there a way to remove them? Thank you in advance, Shmuel Shulman SBS Technologies LTD ...more >>

Hi all, Is there a way to prevent an update from occurring if no columns have changed? I am looking for a way to do this in my stored proc without having to manually check each column. Any ideas? TIA! ...more >>

I have two tables: Orders (8million records) OrderNbr int, OrderDate datetime, ItemID int, ...... There's clustered index on OrderNber. DeleteOrders (1000 records) OrderNbr int There's no index on DeleteOrders table. When I use the below sub query, delete from Orders where OrderNbr...more >>

I need help for a server side cursor created from java app using MS jdbc driver. If I run the statement which is issued by the app replacing the bind variables, I have the result in 2-3 milliseconds. It shows me index seek on the appropriate indexes. If I run the same statement the way I see ...more >>

Hi, I have the following update statement but using a linked server Update txq005dev1.sprint.dbo.becinfo set unit = a.unit from becinfo a inner join txq005dev1.sprint.dbo.becinfo b on a.HRGType = b.HRGType and a.ChargSubType = b.ChargSubType I am not sure why it doesn't work. Can I no...more >>

Hi All, We have a web application accessing a SQL Server database, and it works fine. We installed the RTM version of SQL Server 2005, and it works fine if we use "SQL Server" as the "system DSN" for accessing the Datasource (ODBC) When we use "SQL Native Client" as the "system DSN", then we ...more >>

Hi, We are using SQL Server 2000. Is it possible to somehow schedule a stored procedure to run at a specified date and time? I know that its possible with DTS packages, but this is just a stored proc that performs a calculation. We want it to run at a certain time every day. JD ...more >>

I am building some functions and have not found documentation telling me if/how that are optimized. For example: SELECT companyName, dbo.getAddress(companyID), dbo.getContact(companyID) FROM company Will the query optimizer build a plan rolling the function SQL statements into the...more >>

Hi.... I could use some help here. Probably newbie question, but i couldnt find any easy solution :-) I have two tables. Table 1: Calls containing among else A-Number, B-Number. Table 2: ANumbers containing among else ANumber, Customer number. In order to select calls going from one cu...more >>

I have a scenerio where I am using a Push Merge Subscription set with "Run On Demand". How can I programatically (Stored procedure) run the SQL Agent Job that synchronizes the Subscriptions? Thanks, RSH ...more >>

Hi All, I got this one from lara. hi, >>> declare @xmlDoc nvarchar(4000) >>> declare @hDoc int >>> >>> set @xmlDoc = '<FieldTitle1> >>> <Request> >>> <Reference> >>> <Customer>ABC</Customer> >>> <XpciVersion>1.0001</XpciVersion> >>> </Reference> >>> <...more >>

Does SQL Server allow the user to create user defined aggregate functions? If so: What doed the syntax look like? Where can I find more information on creating user defined aggregate functions? ...more >>

Can someone please advise how i join the following two tables: I want to left join on dt,Category and subcategory from Table 1 Table 1: SELECT TOP 100 PERCENT Y, M, Category, SubCategory,dt FROM (SELECT dbo.tblCalendar_jp.dt, dbo.tblCalendar_jp.Y, dbo.tblCalendar_jp.M, dbo....more >>

I have a query that has serveral Left Joins. Obviously when there are no results in the right tables a value of NULL is returned. When creating an MS Reporting Services report, the tables seem to ignore the NULL values (because they aren't recognized as real values I assume). How do I alter...more >>

hey , im new to SQL. i wanted to save a particular record before deleting i using a delete trigger can anyone help me on this .. thn - sabih rehma ----------------------------------------------------------------------- Posted via http://www.codecomments.co --------------------------------...more >>

Hi All, We have a Web application with SQL Server 2000. We upgraded to SQL Server 2005. It works fine as long as we use the SQL Server Driver for ODBC connection. Once we use the new "SQL Native Client " as the ODBC driver, then, we get an error as follows ADO error in [CReport::UnitSelecti...more >>

SELECT TOP 99 * FROM #TempExt WHERE eFolderID NOT IN (SELECT TOP 3564 eFolderID FROM #TempExt ORDER BY service_requested ASC ,sContractName ASC) ORDER BY service_requested ASC ,sContractName ASC Its not ORDER BY as intended , the out put i am looking is ....first the result should be ord...more >>

I need to do insert a lot of data into a table and need to improve performance. I don't think DTS is adequate since I'm not simply copying/transforming existing data but rather computing it as I go. I think transaction logging is an extra cost that I should avoid, but I'm already using simpl...more >>

I have 4 tables all with an accountingDate [DateTime] and an amount [money]. I also have an AccountRegister that acts as a Ledger and has the invoice items. I am trying to create a query with a single amount column as a result, right now my joins create 4 "Amount" columns, is there a way to co...more >>

SQL Question - declare @sql varchar(1000) set @sql=select count(*) INTO #tmpReport from TableA exec (@sql) select * from #tmpReport go How come exec(@sql) indicates that 1 row inserted, but I get "Invalid object name #tmpReport" from the last select statement. Any help is appreciated...more >>

Have used the EM to copy all objects in an existing database on computer a to computer B, but the diagram did not follow/ How do I copy the diagram(s) from computer A to B? Thanks, Bob ...more >>

I Have 2 separate data bases with the same Tables and records, I create a batch to synchronize my data every 2 hours but now I need a Script that Return the number of Rows for each Table on each DB. Can someone give me an Idea or the solution for this, I will really appreciate it. ...more >>

Hi We are using a 3rd party app that allows us to call functions and SP's. The only problem is that we can only call one line of a statement: Where we would usually use: Declare @Variable VARCHAR(55) EXEC @Variable = sp_mySP 'testing', '' SELECT @Variable We have to call it on one l...more >>

I need to be able to use a View that returns records of data accross, not down. In other words, I have a table with data: CREATE TABLE [dbo].[tblProblem] ( [client_id] [int] NOT NULL , [CIU_PROBLEM_CODE_VALUE] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [CIU_PROBLEM_CODE_Colu...more >>

Hi, I installed SQL Server 2005 Express on one of my development machine, I had since then having problem connecting to a SQL Server 2000 (On a cluster) database. The problem persist even after I remove SQL Sever 2005 Express. The following is the error message: SAC.EDS.CorpAction.Withholdi...more >>

I'm stuck in trying to find out how to solve this. Within a record set, I need to know when a id has been a certain value for x consecutive years. For example, Create table #Test ( tid int NOT NULL, yr int NOT NULL, value int NOT NULL) insert into #Test values (100, 1998, 0) insert...more >>

Hi everyone! How can I do to debug a Stored Procedure in SQL Server 2005 from SQL Server Management Studio? I looked for the Debug... option when I right-clicked the SP but it seems that in SQL Sever 2005 doesn't not exist. Thanks. Jaime Lucci ...more >>

Can a DTS package be added to a server via the command line using OSQL? Thanks in advance John ...more >>

Hello, Can we have a inputoutput parameter, in a stored procedure?? An if it can, how declare it??? Thanks....more >>

How come there is a Chaos isolation level in the Advanced tab in DTS package properties? Was someone having a bad day and thought there life was in chaos?...more >>

Hello What's the easiest way to get the number of months between two values like this? Present date 200505 (YYYYMM) and 199905 (YYYYMM) Steve Thank you...more >>

I am no SQL wizard, so if I have a flawed basic understanding please be blunt so I will understand... In 2000, we set up a lot of views with ORDER BY to get records in an expected order. If I had ViewA and it contained an order by for Field1, then if I did "SELECT * from ViewA" in SQL Ser...more >>

Is there a away to determine how many elements would have been returned without out running a seperate count, even though the outer query was filtered by rownumber? Here's a quick sample: Declare @Start int,@RecordsToReturn int Declare @NameList table (NameId int) Select @Start=0,@Records...more >>

My bcp process is now working. FINALLY. But, my import data file is comma-delimited and everything is surrounded by quotes; therefore, they data goes into the SQL databases with quotes. Any suggestions on how I can remove these quotes, either before,during or after the BCP process? Samp...more >>

I have a function that does some processing, and returns a row of data in the form of a TABLE. I also have a stored procedure, that iterates through a table, and calls the UDF for each row (using a cursor), and returns a TABLE of results where each row is the ouput of the UDF. I need to us...more >>

We are getting a raise here at work, and I need to update all the salaries to show this raise. This was easy last year, because it was just a raise of 3% so I just updated the salary field like this, UPDATE FiscalInfo SET Salary = Salary * 1.03 WHERE EmpActive = 1 This worked a char...more >>

I could use some help on a SELECT statement. I have two tables - Organization and PR. Organization has 41 distinct records. PR has 11,168 records. One of the fields in PR ("Org") is a foreign key to the "Org" field in Organization. I want to return "org" and "name" from Organization for any...more >>

Hi everyone, I have a cursor which extracted a field as a nchar of size 3000. The field has a form like: WordA WordB WordC WordD I want to extract each word and apply the soundex function on it to obtain the value. Then I want to rejoin the soundex values into a string of the form: ...more >>

SELECT TOP 99 * FROM #TempExt WHERE eFolderID NOT IN (SELECT TOP 3564 eFolderID FROM #TempExt ORDER BY service_requested ASC ,sContractName ASC) ORDER BY service_requested ASC ,sContractName ASC Its not ORDER BY as intended , the out put i am looking is ....first the result should be ord...more >>

Hi All, I posted an earlier question here a week ago, it was never answerd.. I'll try to simplify it a bit. I need to get an example of a Pivot Query, with a datasource. i've looked at alot of them online, and They don't really make sense...either they're too general, or they're witho...more >>

Hi, I want to display the result set of a query in a particular order. My query looks like this - SELECT col1,col2,col3,col4 FROM tab1 WHERE (col2 = 1) AND (col3 = 1) AND (col4 = 5) OR (col2 = 1) AND (col3 = 1) AND (col4 = 3) OR (col2 = 1) AND (col3 = 1) AND (col4 = 1) OR (col2 ...more >>

Hi All, It may be getting a bit late in the day but I just cant seem to get the code for a very simple select, I have a table with 100 rows in it and I do a select distinct into a temp table and I have 50 rows in it, I now want to see the rows that were duplicated, is this possible or am I ...more >>

Hi! I have a trigger on a table that record the number of time an insert is done on a particuliar row. It look like this: CREATE TRIGGER CountInsert ON mytable INSTEAD OF INSERT AS BEGIN IF SELECT COUNT(*) FROM mytable INNER JOIN INSERTED ON mytable.pk_key = INSERTED.pk_key INS...more >>

Hi everyone, I need to write a stored procedure that takes each row in a column called "variations" A typical field in the "variations" column takes the following form: Dublin, Baile Atha Cliath, Atha Cliath, Co. Dublin, Dublin City, Dub, dublin and produce an outcome like: D145 B...more >>

Users get monthly data disks that need to be imported into our system. There are a variety of different versions of these disks, so during the import I need to build a version-compliant temp table to house the incoming data. I'd like to store the DDL for each version in different text files th...more >>

I have an earlier issue that has now been resolved, but now I am dealing with a CSV file that is causing problems with my BCP import. The csv file has column headers in the first row. Unfortunately, they have spaces in the labels and the BCP utility cannot handle it. My BCP command line says t...more >>

All: Say I need to duplicate a table, but the CREATE script must only include those columns of the table where the value in ALL the available rows is not null. For an ad-hoc exercise (one or two tables), this is easy, but for duplicating, say, 90 tables with the empty columns filtered out, I ...more >>

Good morning, all.. your mission today (if you accept it) is to decipher what I am trying to do and offer assistance to the poster. (me!) I have searched newsgroups but can find no topics similar to my needs. Background: Trying to create a 'dqy' (MS Query) file for distribution to field pe...more >>

When I run the following query: Select * From Information_Schema.columns Where TABLE_NAME = 'Answers' I see that, for my table "Answers", I have 9 rows returned, showing each field in my table. The sysobjects query shows where I can get the Id for Answers and use it for getting the fie...more >>

I have successfully used BCP before. But, this time, I have an entirely new import csv file and it's causing me so much trouble. I am working with a CSV file with more fields than the SQL table but I am following what BOL tells me to do. PLEASE HELP!!! ERROR: Incorrect host-column number found...more >>