Is it possible to update for a group statement, I want to do the following but keep getting errors : CREATE PROCEDURE ARCustomerRebalance AS begin update cust_detail set curr_bal = (select(sum(ar_master.bal_amt)) from cust_detail, ar_master where (cust_detail.cust_code = ar_ma...more >>

How can I create a column in a query that simply creates an number listing the order of the rows? Row 1 would contain 1, 2 would contain 2, etc. I need to sort a table based on a bunch of fields and then "rank" the results. Thanks. ...more >>

I can do the following SELECT CAST( '20050331' as datetime) and I will get back 3/31/2005 How can I format the string being cast to include the time as well? I've tried SELECT CAST( '20050331T115959' as datetime) SELECT CAST( '20050331115959PM' as datetime) SELECT CAST( '2005033123...more >>

Hi, I'm trying to create a subquerie but it is returning a weird result. Queries: Querie 1: select grupos_tipos from tipo where num_abs = 8 Result 1: 33010013,33010021,33010030,33010048,33010056,33010064 Querie 2: select mne from laudos_amb where codigo in ...more >>

I have a table with the following fields: ID SalesAmt SalesMonth Every month the table gets updated with sales values from the previous month. If a particular ID doesn't have sales, there is no record. I need a query/view showing ONLY the records for the latest month posted for each ID....more >>

I am creating a VIEW, and in it I can successfully create a column named YTD_OSO. The data in this column is created by doing calculations on two other fields that are money-type (in another test they were float). So far, so good. See snip of code below: CASE WHEN aipdn.D017_all.YTD_TotO...more >>

When I tried to backup the log of the database, found the option for backup log is disabled, why this happened? ...more >>

Hi, Is there any way to modify the output of sp_helpdb? Sometimes I would like to run it and only see a few of the columns instead of the complete output so I can save to a file for reporting purposes. Is there anyway to specify what columns you want it to return instead of everything? ...more >>

I'm finally getting somewhere, but getting an error message and not sure how to get around it. I'm guessing it's a text/numeric issue, but not sure what to do to fix it. Anyone know what I can do? Here's the message: Server: Msg 245, Level 16, State 1, Line 1 Syntax error converting the v...more >>

hi, I am sort of new at this...is there a way of handling errors using try..catch in sql server? I know of @@error and @@rowCount but is there an option for try-catch kind of stuff? thanks in advance. Ramakant ...more >>

Can this be done or do all of your company tables have to be put into one large database? I can't find anything in the SQL Help files. -- Hey, I've got some books and I'm doing my best......more >>

Hello. I'm creating a stand-alone windows application using the MSDE server. Performance issues in this application are big-deal to my client. I need to insert data to the database in rate of – 2MB / sec. Each insert action should insert ~ 10-40 MB to the database. My questions are: 1. Wha...more >>

Hello, I posted yesterday not understanding why the sql from Access wasn't working in sql. As was explained, IIF doesn't exist in sql and I must use CASE. I have looked through the link that was provided, and see the samples use other statements like "Use" and "Go" and it doesn't look like I...more >>

I would like to download the SQL Server 2005 Hands-On lab material. I downloaded and installed SQL Server 2005 and the SQL Server 2005 Beta 2 Resource DVD. I never got the following directory structure that is referenced in the hands-on labs: C:\SQL Labs\.... The download location of the ...more >>

I am very new to sql, and have been managing by making queries in Access and tweaking the sql as needed. This one I can't figure out, though. It seems to not like my ">" or "<" . Getting "incorrect syntax near '<'." What's wrong?? Thanks in advance. SELECT TOP 100 PERCENT aipdn.Data0...more >>

Hello, I am totally new to SQL Server and need to learn from ground zero. So I downloaded the SQL Server 2000 Evaluation Edition, and would like to get a feel for the software. Can I work with this without having a dedicated server. I currently work with Microsoft Access and work off our co...more >>

I am a NEWBIE at this as I am stepping up from A2k. In A2k the autonumber used as the primary key allows formatting in which text can be used. Does MS SQL Server 2000 allow it as well? If so how does one go about it? Several A2k databases are also being considered for upsizing and they hav...more >>

Hi I am getting an error message from the following query using Crystal reports 8.5,win98OS,SQL Server 2000. Your help is really appreciated Error message : Syntax error near }. Can I use oj syntax twice in a query??? SELECT DISTINCT National_Oxygen_TEST_Customer."Name", Nation...more >>

Can anyone advise me of the syntax for getting a summary count ? This is a sample of the procedure if you can help, CREATE PROCEDURE PlannedPaymentas begin delete from pp_detail delete from pp_master insert into pp_detail(FULL_CHECK,VENDOR_CODE,TRANSACTION_NO, TRANS_AMT,disc...more >>

Is it possible to add an instruction to rollback the entire procedure, if any part of the procedure fails ?...more >>

Hi i am running the following query generated using crystal reports 8.5 designet,win98,sql server 2000. i get the following error message. i am not sure where i could put the alias for the table "The column prefix sales_cr_memo_header does not match with a table name or alias used i...more >>

Hi all, Im writing a product using MS-SQL, using a Magic as my programming language. When I execute a large process (such as a backup, or a long running query) through a Magic task, the user has to sit through a blank screen while it runs though processing. The problem is that the task ...more >>

hi :) ! hello every body i want to learn Sql Server so plz i want to know how to do create a new table in sql server if any one help me and also give me site about sql server because i want to learn it and to be very well of sql Server ...more >>

Are there any good tools in SQL Server 2000 for generating test data to populate a database? Or do I have to look for third party solutions? Any suggestions welcome. Jim ...more >>

I want to change some Databases' name. But the only way I know is backup the database, and change another name when recovering it. Is there any other way that is easier than that below? thanks zlf ...more >>

does anyone know how to get SQL Enterprise manager to display a field that currenly shows <Long Text>. Is there a Cache setting some where ... or another way to get it to display those fields with TONS of data? i want to edit the data through Enterprise manager but cant when it shows <long...more >>

Hello. I had a table with identity column set to datatype [smallint]. I've reached near 32800 records. That's the limit for [smallint]. So, I've changed the identity datatype to [int], that SHOULD allow me to have more records. But the error continues. "Arithmetic overflow error convertin...more >>

Any thin good book as an introduction to the SQL Server? Particularly I need a manual for OSQL and for security under Windows XP Pro. I have problems with managing accounts, permissons and remote data connectivity....more >>

Hi, I am trying to access data from a Sage Line 100 database to populate tables in SQL 2000. If I use the following syntax in Query Analyser I only get the first row of a table returned: select * FROM OPENROWSET ('MSDASQL','DSN=SageLine132',UID=admin;PWD=;','select * FROM STO_DEPOT_NA...more >>

ok i am basically searching a field for a piece of text then replacing it with new text heres what i have (it works BUT) UPDATE tablename SET columnname = REPLACE ((SELECT CAST(columnname AS varchar(8000)) AS columnname), 'text looking for', 'new text') that will work.. however, t...more >>

Could anyone direct me to the " how to use binary data"? Thanks, Jim...more >>

I've got SQL Server Developer installed on my laptop. I'm trying to get merge replication to work, but when I try to create a new publisher, when I select the option to make SQL Server on my laptop its own distributor, I then get an error msg. saying I've chosen a local system account, and ...more >>

Hi all We created a virtual column in a SQL-VIEW. We now want to change some of the rows of this virtual column, but it doesn't work with a normal UDPDATE statement. Not sure why :( Question 1: Is it possible to change datas of a virtual column Question 2: What is the SQL-statement for that? ...more >>

I have a *.sql file that will create a database. I've found how to create one, but how do I execute this file. Dbl-clicking will only open the file in notepad. ...more >>

Hi all, I have a small database file I created a few months ago--I don't remember the details of what happened when I created it, but suffice it to say, I've been using it without any problem. For some reason, the file doesn't have an .MDF extension (the filename is simply "toolbar"), and ...more >>

I have a customer who needed SQL Server to support a new line of business application. SQL Server was terra incognita for me, but I read a couple of books and successfully installed SQL Server and the lob app on the existing Win2k server. Customer has one employee whose task it is to get al...more >>

I am currently using a stored procedure to delete users from our database who are considered inactive. This works great. However, we have decided that we want to archive these users to a identical (structure) table in the same database. To do this, I need to find an easy way to take the dat...more >>

What is the command (or steps) to make a copy of an existing table and how to restore it? Are there any tools at all that I could use to import external data (from a delimited text file, from an Excel file, from an Access Database) onto a SQL server Database?...more >>

It is nowhere in "about" menu choice. Can someone point me to the right direction? ...more >>

Hi everyone, When configuring the dataAdapter, I see an error message. The SQL statement is: SELECT StokGiriþ.* FROM StokGiriþ The error message is: Invalid Object Name "StokGiriþ". What may be the reason? Thanks alot, Arif Çimen. ...more >>

Hello, I am new to distributed databases. I wanted to use stored procedures in distributed databases. If a view contains query in which tables from different servers are used, how should I reference them. For example Suppose me view is CREATE VIEW dbo.Example1 AS SELECT...more >>

Can anyone tell me what is wrong with the following select if syntax ? insert into pp_detail(full_check,vendor_code,transaction_no,trans_amt, disc_amt,net_amt,disc_date, due_date,paid_amt,disc_tak, full_vend_inv,trans_type,sort_data) select full_check=bank...more >>

Somehow I have messed up my sysxlogin table in the master DB. the svrid for the 3 users I have is null and the name for the one login assigned a server is null. How can I fix this? ...more >>

Is it possible to insert data into a table at group level with a count for the summary, for example : we want to create a summary record for customers in table customers, showing the name of the customer, and the total amount owed, and then a count no for the number of records added to the sum...more >>

Can anyone help me on the correct syntax to insert data from a text file into a table, using a stored procedure. In sybase we would have used the command : input into emp_interface from '\\\\itpsrv01\\multisoft\\reports\\pif.csv' format ascii thnks ...more >>

Hello I just downloaded some hands on labs material of sql server 2005 but it references some files? Where can I get this? Note All of the code for this exercise is contained in the script file PIV_UNPIV.sql in the C:\SQL Labs\Lab Projects\T-SQL Lab directory. You can copy and pa...more >>

Hi, I need to know how to generate a PS file from two table in SQL Server 2000. This is to generate printable bank statements for customers. The customer details are stored in one table and their corresponding transaction details are stored in the other. PS files are to be generated for t...more >>

I'm writing triggers and any occurance of RAISERROR that occurs after an update, insert or delete statement don't return an error to the calling application. I am talking to SQL Server through ADO. Mike......more >>

How do I join three tables together that all have different columns? Viz: Table1 Table2 Table3 All have ID column There are many overlapping IDs in each table, but none of them matches perfectly (meaning all three tables have different numbers of records, some with the same ID acros...more >>

Hi I am installing an application, that requires the SQL server name in a list, I know that the "local", is ussully used to get around this probelm but in this instance, my new application wants the name. The application gives me a message to run sp_addlinkedserver but this is a stored pro...more >>