Hello All, I just started in developing a web based report application with SQL 2000 reporting services. While most data filtering requirements can be handled by simple parameters, there are some occasional special requirements. For simplicity, i have the idea of creating a table with "Filter...more >>

I have a situation where I have multiple records, let's say ORDERS, and I have a record for each line item included in an order. Now, I want to find all ORDERS that includes item A and item G, for example. An ORDER could include many additional items but the ORDER #'s that I want returns must ...more >>

One of my friend's question: "When I get a big result by a query (such as 1M of rows), the memory usage of my system decreasing critically. What is the phenomenon that causes this behaviour?" Ok it is usual, because I can still observe the rows in the result pane below. But, Although I clos...more >>

I'm Maintaining an existing website. Many times user clicked the button twice, which results in duplication of row. now i cant do any modifications. but i can write an trigger to check any row with same data,time stamp etc. if so, then delete existing and insert new row with same data. but i do k...more >>

I'm querying SQL server from a vb.net application. This issue I'm having is that one of the fields in my query is of float data type, the thing is, when I retrieve the value it's rounded up. How can I prevent this from happening, I would like to get the float value as is in SQL. Any advice and...more >>

Hello, I've have a query that I want to convert into a view... but it contains a CASE statement. Views will not accept CASE and I really need to use a case statement here because of the way the tables are structured. Am I doomed to creating a new (very messy) query that will suffice in a ...more >>

Hi! I need a help!! How to download files in DTS package? Tanks ...more >>

How do I find out if a column has a default bound to it (created with sp_bindefault)? ...more >>

Hi, When I try this I get 0 select 580578/2401132 and ideas?...more >>

I want to backup a database every day, but i want that at some point (ex. when there are 5 bakupsets) it replaces the previous backups, one at a time. Can you help me?? ...more >>

Hello: I have one table that burn form a many-to-many relationship, and have the mahine_id and all it's states, like this: machine_id (int) state (int) -------------------------- 1 95 1 195 2 95 2 ...more >>

Hello: I have one table that burn form a many-to-many relationship, and have the mahine_id and all it's states, like this: machine_id (int) state (int) -------------------------- 1 95 1 195 2 95 2 ...more >>

I May have not made my query clear earlier in the post 'Query Between Times' so i will try again beacuse most of the replys were date orinated. I am trying to establish if a given time is between two times ( open and closed ) , and return ) for open and 1 for cloded. The only way i know to ...more >>

At least this is complicated for me. I hope it's not trivial for you experts! Accounts table has Acct_Number (unique), Client_ID, and Rep_Num. The rep num is the number that identifies the registered representative(s) on the account. (The client ID, of course, points to the client's name...more >>

Hi, I've a summing operation which may face with an element set as all null operands. The problem is that when I try to sum such a set, sum() returns the value of null instead the zero which how I want the result when such a situation occurs. I've tried that... case sum(THE_FIELD) when ...more >>

Hi, I have the following question and I apologize if I am on the wrong group and/or the question is very simple and stupid. I have created two related (1-to-Many) tables: tblCodes tblMeasurements --------- ------------------ Code Date Unit ...more >>

I need to convert a text column to a bit in a select query. Backing up, in case there's a better way to do this: I have a varchar column that contains one of six letters. There are two that interest me (Q and A). I want my vb.net application to update changes back to this column. For my...more >>

I have a table that is structured as follows: Id Date --- --------- 01 20040105 01 19990101 02 20020303 02 19980101 03 20030101 03 19990101 03 19960101 I would like to create a table or view that will give me the record in each Id group...more >>

Hi, I would like to generate the following: suppose we have the following table: Table1: Col1 Col2 a b a c d e f c d b Then the result should give the following series: b, a, c a, b, d a, c, f e, d, b b, a, c, f Anyone an idea what would be the ...more >>

I am trying to execute a DTS via COM according to the KB article http://support.microsoft.com/?kbid=321525 but I am getting the exception "File or assembly name Interop.DTS, or one of its dependencies, was not found." which is obviously a file not found exception. I have sql server 2000 inst...more >>

We have a few rather advanced calculation routines developed in C++. Currently we are using a Sybase ASA database for our app. and these routines are accessible by so called external functions exported by a DLL (dynamic link library) that we wrote in C++. Sybase supports this quite nicely. T...more >>

Hi, What I should review to ensure multiple scheduleed SQL jobs do not "collide" with each other? And if I'm running a stored procedure definition script how would I guarantee the definition could be "rolled back" in the event of problems? Thanks...more >>

I have a stored proc that accepts a varchar as a parameter. What is being passed in is one or more IDs in a comma separated list. (ie '123,567,789') In the where clause I want to pull are records where a value is IN the list being passed in. (ie. WHERE column IN (@Var)) When I run this sto...more >>

We have a Windows 2003 Server with SQL Server and IIS. I tried to use the SQL Server Configure SQL XML Support on IIS and can not get it to work. On my local machine, Windows 2000 Profression, SQL Server 200 and IIS, I have no problem.. Are there any articles that can help me with setting ...more >>

Hello Experts- I would like a sproc to return a 1 row select with results based on the results of what it has found. For example say the following table were created by the sp: ID Name Dept 23 A 4 38 B 4 117 C 4 if the sproc could te...more >>

I have 2 tables mvm_campi id_camp dsc_cam 1 desc1 2 desc2 3 desc3 mvm_prova id_prova id_camp desc 1 2 x 2 2 y 3 2 z 3 1 k Is there a way to...more >>

If i were to have a dynamic SQL transaction, where i want to insert a record, and use the ID generated for this record, in a subsequent query in the same transaction , how do i do it ? Regards, Chak. ...more >>

I have 2 sql servers behind the same router, I made one a linked server from the other using the 192.168.2.x IP. I select from the linked server into a fast_forward cursor and fetch through it doing inserts on a local table. the inserts happen at 1 insert every 5 seconds...way too slow. w...more >>

i have two DateTime fields One called 'Open' and one 'Closed' . I need to know if a given time is inbetween the Open and Closed times ? ...more >>

Hi, I got two tables, the first one is tblGeneral and the second one tblPersonal. Both are related via Id field. The data and structure for the tblGeneral is: ID Age Sex Race Name SS Salary 1 35 M Asian 2 40 M Black 3 42 F White while the data and structure for tblPersonal is: ...more >>

A co-worker suggested that I read up on the UDF and that it might solve my current situation. And it will, COOL!!! HOWEVER, my UI-frontend is Access with linked SQL backend tables (except for the one table that i need). So, my question is... How can i call a Table-Valued UDF from within an A...more >>

The first query below returns 46 rows (correct result set) while the second one returns all of the records from app_type table. The second query is similar (atleast thats what I'm trying to accomplish) to the first one, difference being non-ansii statement. Can someone help me figure o...more >>

Hi All, I would like to know whether there is a way to search a stored procedure either by name or by content? Any suggestion would be appeciated. Thank you, Sasidhar ...more >>

I am trying to run a job, but SQL Server keeps popping error 22022 and saying that SQLAgent is not running. I have restarted the service serval times, but seem to be having the same issue. Anyone know why? Thanks ...more >>

What is the efficiency (creat time, read/xfer time, long-term (fragmentation issues, etc.)) of SQL Server (out-row, I'm assuming) BLOB (type image) access compared to remote filesystem access? (NTFS using \\shares, probably.) Enviroment will be .Net 1.1. I'm planning at peak potentially creat...more >>

Hello, My workplace is upgrading Microsoft Access from 97 to 2002 which has the Access Data Project file that can create an addhoc Sql Server DB on the Sql Server computer on the fly from remote workstations. The wizard in the Access 2002 .adp file does not offer a location option where ...more >>

According to Best Practices, it is not recommended to put user objects in the master database. I have a group of scalar functions that perform that simply format strings. They are shared by several databases. Because they don't belong to any particular database, it makes sense to me to put ...more >>

I am having a problem with the size of my primary filegroup. I have the 'automatically grow' option turned on. I have 7GB free disk space.But still the log file complains that it does not have enough space to grow.Can anyone please help me out? Thanks in advance....more >>

Hi, I have a script which uses xp_cmdshell to create certain log files on the harddisk. I can run this script easily through "sa" account. But when i try to run the script through another "sql user" i get the following error: Msg 50001, Level 1, State 50001 xpsql.cpp: Error 1326 from Logo...more >>

Im running a query like select * from MyTable where SUBSTRING(MyColumn,1,300)='searchtext' MyColumn is th the text type. The text in MyColumn contains a lot of tabulator characters (TAB), carrige return (CR) and linefeed (LF) characters. Sometimes (but not often) when I run the query, ...more >>

Hya, I have a counter in a table, in a production line I have three stations that could generate a unique serial number base on the counter. To generate the SN I get the actual counter (SELECT), I increase the counter and I UPDATE the counter in the table. Simple! My problem is ...more >>

Please help me. I want to know how to bind the datetime field to sql server 2000 in vc++ .net 2003. my program like this: String* strArgs[] = new String*[10]; strArgs[0]= .. .. .. strArgs[9]= ??? datetime field problem here initialize. String* strSQL = String::Format(S"INSERT Transfe...more >>

SQL Server 2000 SP3a Im using a sproc to make a sql statement. The statement is built up and assigned to @SQL1 nvarchar(4000), then at the end of the sproc its runs: exec sp_executesql @SQL1 The problem is that I've reached the 4000 limit!! How do other people get round this, bearing in...more >>

I am running a DTS package and the dates are hard coded...which means I have to change the date each time I go to run it. I would like to change it so that it does it automaticaly...so when it runs, it takes one off the system date and transfers the data....so it only transfers the previous...more >>

Is there another way to resolve the following problem (instead of using a cursor for Tab1, especially if the table is "big"): Suppose you have the following table: Tab1: col1 a b Tab2: Col1 Col2 a c b d Or Tab2: Col1 Col2 a b c d Or Tab2: Col...more >>

I would like to create the stored procedure listed below. If the CounterValue <> 0 then abort the stored procedure raise the error message "System Down". Please help me with this task. Thanks, Create Test_Counters AS IF NOT EXISTS (select CounterValue from counterdata Where C...more >>

Declare @ACC varchar(3) DECLARE @COMMS Bit DECLARE @ORIG as Bit SET @ACC = '001' SELECT CASE WHEN EXISTS ( SELECT * FROM Table1 r WHERE r.Licence = h.Licence) THEN cast(1 as Bit) ELSE cast(0 as bit) END AS Communications, CASE WHEN EXISTS ( ...more >>

What I would like to be able to do but am not sure if I can is the following. I need to set a variable = to the results of a single field recordset: @X = select EmployeeID from Employees where DepartmentID = 1 Then I need to build a dynamic sql statement based on the above results. If the ...more >>

I would like to find a single Average daily value for fields a1-a10 in Table A for the hours between "09:00:00" AND "21:00:00'' Also would like to find a single Average daily value for field b in Table A for the hours between "09:00:00" AND "21:00:00''. Table A is sampled every minute (sam...more >>

Hi I have problems storing Polish characters in my MSSQL DB. Words like:=20 &#347;wie&#380;ych kwiat=F3w=20 do not get stored correctly The fieldtype is ntext. Hope you can help Ciao Edward...more >>

Hi I am trying to use the select statement to return rows which have a MAX date and then associate the date with a Title field in the #c table. At the moment when I add the Title field to the Select list I am getting the latest date for each Title. How do I exclude the Title field form the ...more >>

Hi, How can I return the date for the Monday of the previous week and also the Friday of the previous week. This can be two seperate queries. For example, executing the query today (Friday 11th) will return 2005-02-28 and 2005-03-05. Does this make sense? Thanks Niall...more >>

Simple problem: CREATE TABLE Test (dec_col DECIMAL(5,5) NOT NULL); INSERT INTO Test VALUES (1.1); Error: Arithmetic overflow error converting numeric to data type numeric. How do I cast/convert my value to get it into the column? Thank you....more >>

Can this be done in Yukon using T-SQL? declare @DB as nvarchar(100) declare @owner as nvarhcar(100) Select * from @DB.@owner.TableName Thanks in advance...more >>

Im currently trying to write a SP to do limit checking and other test for client banking files. one of the things i need advice on is that after the 'testing' is completed im returning a Varchar as an output parameter. Is it possible to fire off a DTS from the SP without the SP then waiting fo...more >>

In what way is SQL server better than Oracle Database server? ...more >>

What is the equivalent of Oracle's Merge statement in SQL server ? ...more >>

Hi, I want to make a check against a column. The column should carry only alphabets, numbers and a hyphen. any help? thnks anu...more >>