table1: TransactionTable
ProdNo,Qty,Location
10,5,'A1'
20,9,'A2'
table2:ProductTable
ProdNo,Qty,Location
10,20,'A1'
11,34,'A2'
12,42,'A3'
I would like to add the qty in table2 with the...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_2320...
Hi,
I just installed the SQL Server 2008 (February CTP version) on a spare PC to see what its like. I noticed that :
a) the Management studio has some nice new features and
b) you can connec...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_2327...
I have a table that stores user ratings for a given product. (0 to 5 stars a la Amazon)
A user can only have on rating for each product so I have a priamry key on UserId and ProductId.
I want...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23745594.html
I need a sql query / script that will search and replace a text string in 1 of the tables & fields of my database. I know the DB, Table and Field name. I just need to search and replace %SearchSt...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_2377...
I am working on an Intranet for my company using ASP.net and Sql Server Express. I have Sql Server 2005 Standard on the test server.
I have the data model I want and will only add tables from ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23882039.html
I would like to create a dynamic SQL update/insert statement based on some parsed data in a table in SQL and run this against an existing table in the same database. The issue I'm having is that so...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_2313...
I am thinking about using SQL Server 2008 reporting services in an application. Does anyone have any good links to video tutorials?
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2330...
What killer features are in SQL Svr 2008 to justify my upgrading from SQL Svr 2005? I have seen a massive performance gain from 2000 -> 2005, I don't expect this gain again.
But what else does S...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_2337...
I have been doing some work on SQL Server 2008 but would now like to restore the database to a SQL Server 2005 installation.
Is there any easy way to do this?
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2337...
I have this Job that gets executed in SQL Server 2000. In the command box, there seems to be .exe or .dll are something loaded up and then is executed. It looks encryped. I was expecting a path to ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23469607.html
