Hello, sorry for my poor engish : I can't ex=E9cute =E0 very complexe query automatiquely make=20 by People Soft. This Query use 6 tables with no more 80=20 000 rows each. When i try to launch, I get this answer from SQL Server=20 7.3. Insufisient m=E9mory. Now I drop the 6 tables ...more >>

I have a table of data storing the following fields Stock_Code (varchar 10) Location (varchar 10) Quantity (int) Sample data is as follows Stock_Code Location Quantity AD002 B1 200 AD002 B2 150 AD002 B3 350 AD003 ...more >>

Hello. I am getting unwanted whitespaces returned from a select statement. I understand my table definition has stated a "char" with field length 10. However if my value stored is only 5 characters, how do I structure my select query to trim extra 5 spaces returned in my query. It is ...more >>

Is there a way to create a column that will show the value of field1 unless field1 is null in which case it will show the value of field2? I do it all the time in Access but can't seem to figure out if SQL Server can do it as well. Any help or suggestions are geratly appreciatd! Here ...more >>

I apologize if this isn't the right place to ask this, but I'm looking for a way to copy an SQL/Server ODBC connection from one PC to another (actually, many others). I tried copying the ODBC.INI file but that didn't seem to work. That seems to be the only file that is updated when I cre...more >>

Looking at http://www.databasejournal.com/features/mssql/article.php/3112381 the guy creates a table called Orders, then has the quer select OrderId, OrderDate, O.OrderAm ,(select sum(OrderAmt) from Orders where OrderID <= O.OrderID 'Running Total from Orders My...more >>

The object name 'pic_db.pubs.dbo.authors' contains more than the maximum number of prefixes. The maximum is 2. when i tried selecting from a linkedserver i get this message. help anyone? thanks very much PHil...more >>

Good day, [SQL Server 7.0, SP4] I have a table wich contains only one column [varchar (1500)] filled with some texts (different length, ranging from 150 chars up to 1200s). When I execute "Select * from Table1", I only get parts of my texts; the returned strings are truncated, but not ...more >>

I'm try to set an IIF statement in a query/view for a column. I repeatedly get an error message stating the IIf function doesn't exist. When I try IF, it put my function in 'quote marks'. Please help...more >>

amount before 82.758 960.000 331.034 After 82.7 960.0 331.0 hi there i want to trim last 2 digit. how can i accomplish in sql script?? ...more >>

I want to drop FK constraints while I do mass delete from tables which has several steps relationships. And then when deletions are done I have to set back. In the tables even after the deletion there are over 300 million posts. So, I want to add FK constraints with nocheck so that SQL ser...more >>

Hi! How do we limit the number of sql statements that are running at a time in order to prevent transaction log to grow infinitely. This is urgent!!!!...more >>

Hello, I am trying to figure out how to write a query that can update only part of a string in a given column. Example: Table = WebSites Column = url Exsiting record = http://www.site.com Needs updated to = https://www.site.com or Exsiting record = http://servername/pathX Needs upd...more >>

Hi, I am new to SQL 2000. We have bought the full version and we have created some tables with large numbers of records (20m, 60m etc...) but I wish to know more about Indexes and all the different types within SQL 2000 and which one to use and for what. Clustered and Non-clustered ne...more >>

I get the following strange error when executing the query below. Can anyone help me find the error ? thanks in advance. Server: Msg 207, Level 16, State 3, Line 1 Invalid column name 'A'. ---------------------------------------- Query: SELECT A1.EecSupervisorID, A1.EecEmplStatu...more >>

Hello, I'm trying to compare data between tables for the purpose of performing a large update. The first table has 210 fields (consumer) of which I need to compare 3 of them (last, address, zip) to a second table (do_not_mail) that only has those 3 fields (last, address, zip). The purp...more >>

Hi! Think that you get 100 rows in result of a query. But i=20 don=B4t want to see all of them. I want to see the rows=20 between 20 and 40. Is it possible to do a query who get=20 the rows between 20 and 40??? Thank you for helping me Kind regards Mehran...more >>

hello if i have a forula string looks like a '150000*0.9*21/31', how can i covert them to the result 91451.61? thanks in advance!!...more >>

I have problem of Navision within MS SQL.Problem is , I want select customer table within ASP. But when I connecting the MSQL server, I take error because Navision table name have '$' character How to find good solutions? I try to C/ODBC but not working ...more >>

Variation on prev post . . . I have 3 tables SO SODet, and SOQuot SO is linked to SODet by SalesOrder SO is linked to SOQuot by Quote I want to update SOQuot.TotalQty with the result of Sum(SODet.OrderQty) What would the syntax be for this? Thanks ...more >>

Hi, I want to be able to update a field in one table with the sum of a field from another table but i don't know how to link the two Here is what I have so far to get the TotalQty *****TOTAL QRY***** SELECT SalesOrder,SUM(OrderQty) AS TotalQty FROM SODet WHERE (SalesOrder ...more >>

Im trying to get a running total to work example that I found @ http://www.databasejournal.com/features/mssql/article.php/3112381 select OrderId, OrderDate, O.OrderAm ,(select sum(OrderAmt) from Orders where OrderID <= O.OrderID 'Running Total from Orders Ord...more >>

Good morning, I am trying to write a query that selects a weeks worth of data. This is what I wrote to get the date minus seven days: convert(varchar, Getdate() , 101) - 7 . I keep getting the error: Error converting data type datetime to varchar. I know it's something like this but, I ca...more >>

Hi. I have a view that lists account number, course date, and location as shown below. I'm trying to get it so it groups the table by date, which i've done, but only show the earliest course date for each account number. Any suggestions would be great. Thanks!! SELECT TOP 100 PERCENT ...more >>

Does anybody knows how can i reterive date from datetime field .i don't want time .Thanx in advance...more >>