Hi experts, I am using SQL DMO in my program to call a SQL Server Agent Job. This SQL Server Agent Job is used to run the replication process at the subscriber. Basically my program will: 1. Read the name of the agent job saved in a database table. 2. Run the above agent job (with the...more >>

How can check if a search phrase contains a noise word and let the user about it so he/she can do search again without the noise word. Thanks, -- Dino Buljubasic Software Developer http://rivusglobal.com ...more >>

Hello, It's me agian. How can I feed a parameter to a view for use in a where part of the statement? This is the view(Thanks to John Gilson), with minor changes by me: CREATE VIEW dbo.TotalsForLast10WeeksIMP AS SELECT S.d AS end_of_week, COUNT(D.IMPCLK) AS weekly_total FROM ...more >>

My new employer is CMM Level 3. As part of the CMM/Personal Software Process, I am required to create pseudo code for my stored procedure and UDF design. Has anyone done this? If so, can anyone give me some advice?...more >>

I am trying to simulate wild card search like for example: cran* would return any word containing 'cran' at the begining *cran would return any word containing 'cran' at the end *cran* would return any word containing 'cran' in the middle Here is whay I am doing but it does not work SEL...more >>

Can anybody explain how the FROM clause works when used with DELETE and UPDATE (or point me to a good explanation)? While experimenting I tried the following: DELETE [Order Details] FROM Employees JOIN Orders ON Orders.EmployeeID = Employees.EmployeeID WHERE Employees.EmployeeID = 1 I t...more >>

We have a server by name TEST and SQL 7 installed and exists a login 'xx' and password 'xx' Recently we installed a named instance SQL 2K on TEST by name TEST\TEST2K and with a login 'xx' and password 'abc' I created an alias for TEST\TEST2K as TEST2K From TEST, Executed sp_addlinkedserver T...more >>

Hi everyone, I need some resources on how to export query result to excel through query analyzer using T-SQL I will be very thankful for any help ...more >>

Greeting all, I want to compare if the content of two tables is the same. Certainly the two tables have the same structure. Also I want know which records are in the one table but not in the other table. The following steps can help you to setup your test environment. CREATE TABLE [tes...more >>

I have 4 tables (AA,MAIN,CC,DD) Everything that is not in AA but is in MAIN I want put into CC Everything that is not in MAIN but is in AA I want put into DD Add everything in DD to MAIN Clear AA CC and DD Thanks in advance...more >>

I made the mistake of installing MDAC 2.8 and now my VB6 apps blow up. I want to go back to 2.7. How can I uninstall 2.8? ...more >>

I have an instance of an SQL server called servername\instancename. How do I pass it to connect to a SQL server from an ASPX page. The successful string without instance for a server called "servername" is as follows Dim ConnectionString As String = "server=servername;database=Northwin...more >>

Hi all, I have a table, and I basically want to duplicate all of the rows in the table into the same table, but changing one field while doing so. I think I have to use SELECT INTO, but not sure how to form the query so I can change the one field as it runs ...more >>

i have some queries that run in less than a second on two servers individually. Now on one server, i use Views to UNION ALL the data from a local table and from the other linked server. Now the query after 10 minutes complains about something to the effect of "too many resources used, query...more >>

Table A column id, column w, column x, column y, column z, column a, column b, column Timestamp Table B column m, column p, column x, column y, column z, column a, column b, column timestamp I use a cursor to get each of the records from table B and to fill certain colu...more >>

is specifying default values for sp parameters the same as optional parameters in other languages? ...more >>

Hello, I have a table containing 18 columns named Col1-Col18 (I assume the example a little easier as it really is). Now I have one record in it with e.g. the following values (NULL means column is not defined / is empty): Col1=Test1 Col2=NULL Col3=Test3 Col4=Test4 Col5-7=NULL Col8=Tes...more >>

hi i need to control a timestamp field using php, if i read timestamp the php cant manipulate the field... can anyone help me?? Carlo ******************************************** ...more >>

Help please, I thought if I do LEFT JOIN, it will only pull records from the left table. I ran this query and I got more records than I should get. Basically I get duplicated ssn. I just want distinct ssn. SELECT a.ssn, b.acct, + other fields FROM ( SELECT SSN FROM test GROU...more >>

Using: SQL Server 2k, Win XP Prof. Task : Write an SP to extract data from the event table based on the year and quarter of StartDate ordered by StartDate Query: Using SQL Query Analyser, the following query generates correctly the desired result... SELECT * FROM dbo.Event_Details WHE...more >>

I'm pulling my hair out and I'm hoping someone can help me! For my table, I have one column that I need to use for large amounts of text. Whats the best first step? Also, I don't understand how to use the TEXTPTR....more >>

Hi all I need to search exact data "ABCED" in any fields and any tables in a database. Does anyone have T-sql script to do so? Thanks in advance. ...more >>

The question I have today is? Is there a way to extract out of a sys or shema table the row count for a user table? I know this can be accomplished through the select count (*) but I need to be able to view all or several different table at the same time. Bill *** Sent via Developersdex h...more >>

Hi, Is it possible to set attached file produced by xp_sendmail to be ANSI encoding instead of Unicode? I'm using SS2000 Enterprise edition SP3 on Win2000 Advanced Server SP4 Thanks in advance Nikola Milic ...more >>

I wonder how to combine these 2 queries into 1. First I get the latest employee record. Then I use SSN and year to get employee's full data. I tried to use IN clause for 2 fields, but somehow it is not working. select SSN, max(year) as year into ##temp from Employee group by ssn order by ...more >>

Hi I have a VARCHAR field called 'location' that contains the UNC location of a particular file, for example: '\\myServer\myFolder1\myFolder2\myFile.txt'. One any particular day, the PATH part will be identical for every row, e.g. '\myServer\myFolder1\myFolder2\' will be the same for ev...more >>

Hi Please excuse the newbie question. I am running a SQL script through query analyzer on SQL 7. It creates a few of the tables but gives me a syntax error on the keyword 'COLLATE' in the following SQL The message is 'inncorrect syntax near COLLATE'. Can you please give me some ideas as ...more >>

I have an employee table as : SSN EMPNAME YEAR ---- ---- ---- 123456789 Joy J Smith 1999 123456789 Joy Smith 2003 I only want to return employee's lastest year records. My query is: Select SSN, EMPNAME, YEAR from EMPLOYE...more >>

Let say I have a table with 300000 records and 20 attributes. Of the 20 attributes there are 10 non-clustered indexes. If I need to update 500 records would it be faster to delete the 500 records and insert the updated records or just update the existing records? ...more >>

What coluld be the cause of the following message from the query analyser for the procedure that does not have any other syntax error... Server: Msg 457, Level 16, State 1, Procedure trial_sp, Line 143 Implicit conversion of varchar value to varchar cannot be performed because the collation of...more >>

Hi Everyone, I have a database table in Turkish character setting. I would like to select smilar sounding name and surnames from my table using soundex function but; it returns 0000 for my fields if field has turkish character. For example "çakmak" and "cakmak" are the same but soundex ignores ...more >>

Hello all. I am having a problem with a select query that sums a possibly null field. Can anyone tell me how to tell SQL Server2000 to treat NULLs as zeros? eg: Select acct, sum(totalpaid) from paymentmaster group by acct Thanks for any help you can provide. Joe ...more >>

I don't know if this is a stupid idea, In my procedure, I have a cursor, in the cursor I have a lot of transactions, basically, every row is a transaction, based on the @return_value, if -1 is failure, 0 is success. I'm not familiar with using transaction in the cursor, I'm afraid that I c...more >>

Hello, I want to create the following table CREATE TABLE [dbo].[tbl1] ( ID int IDENTITY (1, 1) NOT NULL , Datefld datetime, Cat nvarchar (50), Itm nvarchar (50), tCount int ) GO Data would look like this: ID Datefld Cat Itm tCount 1 1/1/03 A itm1 3 2 ...more >>

I've written some stored procedures that I want to use in my vb.net program. I know how I can add them to SQL by entering the stored proc as a string and then use the ExecuteNonQuery command to add them to the SQL server. However, I was wondering if there was another way to embed them into my vb ...more >>

Hello all. I have a problem trying to run this select statement. I realize that this is not the proper way to go about doing this, so if anyone has any suggestions they would be greatly appreciated. Select Count(Cname), (Case when StHour < 7 then 'Early' when StHour >17 then late else '' en...more >>

Hi, Is it anyhow possible use "table" data type in the stored procedures parameters list? For example like this: DECLARE @t TABLE(i_col INT) INSERT INTO @t VALUES(1) INSERT INTO @t VALUES(2) EXEC my_sp @t Sergei Horaskin...more >>

I am trying to run a query to return the form Name from Table 1 where the operator in table 2 has security access ie if the operator ghacs security access 2 & 3 but not 1, then only the formNames that have a security level 2 or 3 should be returned. can anyone assist me Table 1 ...more >>

Hi, Apologies if this is thw wrong forum - please advise of the correct one if so! In Access, it is possible to refer to tables which are external to the current database. (Known as linked tables if you are not sure of what I mean!) My question is fairly simple, can you do the same wi...more >>