I am a newbie. Just started using SQL recently. My SQL statement adds up monthly sales fields to get a '12MONTH' number. I then repeat the previous statement and divide by four to get a '90DAY' supply. Then I take my quantity on hand and subtract the result of the previous statement to get a ...more >>

I have a question on how to return only some records from my existing query (shown below). I want to return only records that occur in both sides of the union AND have the same tablename. (Maybe thier is an easier way than starting with the union, which you may suggest). So, for example, ...more >>

I have a table with news, they have dates and right now I select * from table order by date How can I select only the top 5 results And then how could I select all others BUT the top five ? Thanks for the help, Aleks ...more >>

SQL scripting... is there anyway to create a script that inserts a column into all the USER tables in a database that is a primary key column, doesn't allow nulls and identity is set to yes, the seed is 1 and the increment is 1 as well? I am enabling a database for replication and need to crea...more >>

Hello, I am trying to obtain field definitons for all user tables. I see the columns I need if I use sp_help tablename, but do not see all the columns I need (such as calculated) in inforamation_schema.columns. Does anyone know what the name of the table is where the fields reside for sp...more >>

Hello, anybody knows about an SQL Server 2005 book? regards, Robert ...more >>

Hi I created a pass through query which concatenate a few fields. When one of the fields is null, the whole string doesn't show. How do I over come this issue. the syntax SELECT Company.CompanyId, Company.COMPANY, ([Floor]+' ') + ([building]+' ') & ([street No]+' ') & [street] AS [MAILIN...more >>

Hi all, I have some processes on my SQL 2000 Enterprise SP3, that won't go away unless I reboot the whole physical server. I've tried restarting the SQL service but no luck. Anyone has suggestions on why these processes won't go away? Tom ...more >>

Using VB, I'm creating a table in SQL Server that has two columns defined as a primary key, however I get an error msg telling me I can't have multiple primary keys. Here is my SQL statement. CREATE TABLE INSP_Detail (INSPDT_Ins_Num integer PRIMARY KEY, INSPDT_Seq smallint PRIMARY KEY, IN...more >>

We are gettingready to get the SQL Server 2000 Trial Software. Is the trial software a full version of the software or does it not give you everything?...more >>

Hi.... I need to buy a new server for my MS-SQL... becose frequently appear deadlock's, and the Disk Times (read and write) are over the 80%... so i have some questions about that... What's better for SQL... server with 2 cpu bus 800 or 4 cpu bus 400?????? If i bought 2 servers for cl...more >>

Unaccountably, for about a 90 second period the performance monitor hits %100 for disk queue length. During this time the windows 2003 server seems to freeze. Clicking "help" or even "start" takes 10 - 20 seconds before anything shows up. Client workstations (development system running our sq...more >>

I had Office 2003 Pro Ed on my WinXP pc and just installed the additional Small Business Management Edition 2006 components, namely, Small Business Accounting 2006 and Business Contact Manager. Now in the lower right of my taskbar I have an icon for SQL Server Service Manager which starts u...more >>

Hi, I'm trying to stop and re-start my MSDE instance (it shows one user is still connected). I've used the Service manager to stop it thinking this would disconnect the user (really new at this). It shows "stopping instance name" and it doesn't do anything. I've tried on the cmd promt NET St...more >>

We are getting ready to get a new server (lease is up on the old one) and we currently have a license for SQL 2000 and this software meets our needs so I am currently planning on using the existing license on the new server. However, I am thinking that since we are going to get new hardware w...more >>

I am having a database in SQL which is of size 6GB. My application will be logging the data into database, which makes increases the size of database.(currently it is growing by 10%). I am running a query againest the database, which refers many tables, which is taking around 5 Minutes. I a...more >>

Hi ppl, I need to create a view which contains both SALES and CANCELLATION/RETURN data. Is it possible for a VIEW to store data from 2 sources? Eg. Create VIEW MyView (RefNo, Date, Data1, Data2, etc...) As Select (sales_table.SalesNo, sales_table.SalesDate, ..) From sales_table Where ....more >>

I have SQL Querys. Some people said me I must use the INNER JOIN, but I don't now Why???. I need some help with the INNER JOIN. Thanks in Advance. SELECT * FROM table1, table2 WHERE table1.tb1_id=table2.tb1_id AND table1.aaa > 5 SELECT * FROM table1INNER JOIN table2 ON table1.tb1_id=tabl...more >>