I have two tables (T1 and T2). In T1 I have a field FT1 that is a primary key in T2 I have a field FT2 that is a foreign key linked to FT1. These fields have been populated with data. Lets say that in one row of data I have in T1 under FT1 "my cell" as the data entry, similarly with T2 under FT2...more >>

my query: select Product_List.*, Product_Sales.* from Product_List left outer join Product_Sales on Product_List.ID = Product_Sales.ID this works fine. its simple. I have this in a report and I would like to add a parameter @p1 to add to the query where Product_Sales.Order_Amount >= @p1 ...more >>

I have the following 2 tables: (BATCHES) BatchID [int] KEY ID [int] OrderID [int] Action1DateTime [datetime] Action2DateTime [datetime] Action3DateTime [datetime] Action4DateTime [datetime] Action5DateTime [datetime] Action6DateTime [datetime] Action7DateTime [datetime] Action8DateTime...more >>

Hi, I would like to know details about the table name starts with prefix in sql server 2000. Actually i'm working on existing code. The existing code insert a record into a table, but the table name in the code and table name in database are different Table name in database : tbl_mmm_ox In c...more >>

We are planning a SQL Server 2005 install on VMware ESX, as the backend to a Sharepoint Services 3.0 web front end.. Do I gain anything at all by installing SS 2005 on Win2k3 ENTERPRISE as the OS instead of Standard?? Thank you, Tom ...more >>

Hi, I have a Sybase dataserver containing lots of (huge) tables that I would like to access from SQL Server (two different applications, using two different datasources, now want to talk to each other). MS Access has a feature for 'linking' external data. Can I do similar stuff in SQL Server? ...more >>

Hi, I would like to compare two sql server databases. I need to find the difference in the two database(i.e table, colums, data type) Is there any free utility available to compare sql server database I'm using sql server 2000. Help me out to compare databases Thanks & Regards, Mani ...more >>

I discovered that many of my very busy colleagues are having an extremely difficult time pulling themselves away to take vital training when it requires being away for consecutive days. I just completed training for .NET in Chicago through a mentored learning program that personally helped me t...more >>

The first query returns me the results from multiple databases, the second does the same thing except it puts the result into a #temp table? Could someone please show me an example of this using the first query? The first query uses the @exec_context and I am having a challenge trying to figure ...more >>

Hi, I have a need to create a table detailing the ID of all contacts and the last time they were contacted. This information is stored in 2 tables, 'contact' and 'activity' (ID in the 'contact' table links to 'main_contact' in the 'activity' table). I guess I need some sort if iteration ...more >>

I am using SQL Server Express and ASP. I have a table that contains news articles, headlines, start and end dates. I am trying to create a recordset that shows all of the articles that are greater than or equal to the start date and less than or equal to the end date. For some reason I canno...more >>

Does anyone know where to start if I want an exported copy of home appliances, cars, cell phones etc. I just need to populate my database and I want to get some data feed from all the different types of manufactures. I think there are services out there. But I have not seen one. I want a ...more >>

create table t1(c1 int, c2 varchar(10)) insert t1 values(1,'Hello') insert t1 values(2,'') insert t1 values(3,NULL) select * from t1 c1 c2 1 Hello 2 3 NULL select * from t1 where c2 = ' ' c1 c2 2 select * from t1 where ltrim(rtrim(c2)) is null c1 c2 3 NULL T...more >>

Hi friends, First I would like present me. My name is Eduardo, I am publisher of the Mr.Bool Portal (that can be accessed through the address www.mrbool.com= )=2E There is short time was given beginning to this new challenge, and now I am finding columnists that have interest in write artic...more >>

Hi, I posted this in an access adp newsgroup, but there don't seem to be any messages there since 9-06. I am accessing an online SQL Server (2k) database with an Access adp (also 2k). I'm new to doing this. Does anyone know if I can append records to a SQL Server table thru access? Wi...more >>

Sorry if this seems too easy to be interesting - I have yet to find an elegant solution, as I am completely new at this so don't really know what to look for. I have the following table: Id Cat 1 A 2 B 3 C 4 A 5 B 6 B 7 C ....more >>

I have a table with a date_created and date_expired and I want to look at the 15th of each month and every month since the system started and count up how many accounts were active at each of those points in time. Will have to assume that if there's an expiry date bigger than today then that ac...more >>

Can someone tell me options to do this statment because this one does not work! SELECT Name FROM tbl_J WHERE J_ID IN (SELECT J1, J2, J3, J4, J5, J6 FROM tbl_CJ WHERE CJ_ID =23515) ORDER BY Name ...more >>

I was able to view table content easily before, but after I reinstalled everything, I cannot find the option to view table content in MS SQL Server Express. I can define table with no problem. Check out the screen snapshot below, from which you'll see that the popup menu frrom right-clicking on...more >>

I have a stored procedure that calls another stored procedure with the first stored procedure opening a transaction: BEGIN SET XACT_ABORT ON BEGIN TRANSACTION does various updates/inserts calls 2nd stored procedure to proccess updates/inserts common to many other stored procedures...more >>

What is the easiest way to solve "," problem Fields A, B and C are float-values INSERT INTO Table (A, B, C) VALUES (1,2,3) This is ok, but. How can I insert values A=1,1 B=2,2 C=-11,123 This is not working INSERT INTO Table (A, B, C) VALUES (1,1, 2,2 -11,123) ...more >>

Hi everybody, I've five instances of SQL Server 2000 with the SAME database with a DIFFERENT owner in each server. I, as the administrator, have a lot of queries that I have to execute in some or all servers. The problem is that I have to connect to all servers with MY user, not each of the db...more >>

I have a table that has a DateTime column which uses a DataTime datatype. How do I retrieve the minimum and maximum year using ms sql? Eugene Anthony *** Sent via Developersdex http://www.developersdex.com ***...more >>

I have a table that has a DateTime column which uses a DataTime datatype. How do I retrieve a range of records based on the month and year using ms sql? Eugene Anthony *** Sent via Developersdex http://www.developersdex.com ***...more >>

I'm trying to write some T-SQL code for adding some fills and thrills to backups but ran into a snag. Is there a way to query what backup model a database is using? I can see it if I right click a database, go to properties, select the options tab, and then can see the current model (full, bul...more >>

Imagine a restaurant which we want to store information about. Two types of people are related to it. 1) People who simply call and the food is delivered to them. 2) People who actually come to the restaurant and eat their food there. For both categories, order information(OrderID, ...more >>

I have been unsuccessful locating information about the maximum number of CPU's SQL Server 2005 Enterprise supports. However I did find info in a document about configuring a fail over cluster solution. It said 4 CPUs, but it is unclear how that works out with multi core processors. Is it 4 soc...more >>