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...
No DTS in 2008 ?
How do I do DTS style jobs in 2008 now then ?
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_2374...
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
Can you connect to SQL SERVER 2008 WITH ADO OR DO YOU NEED ADO,NET? I HAVE AN ASP APPLICATION THAT NEEDS TO CONNECT TO SQL SERVER 2008. IM NOT SURE WHETHER I CAN CONNECT USING ADO OR WHETHER I WI...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_2391...
I have the need to take in a text value from the UI, look the corresponding ID in the lookup table and then update another table with the ID that was found. I am not in charge of the UI or I might...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2394...
Hi All,
Playing with SQL PBM in preperation for the 70-453 Upgrade Exam. Looking into the PBM which I'm comftable with; however I cant work out how you set multiple conditions in a single polic...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_2394...
I have recently upgraded from Vista 32 to Vista 64 and I am now unable to attach any SQL Server 2005 DB that I had attached to SQL Server 2008 when I was running Vista 32. I have given the SQLAgen...
http://www.experts-exchange.com/OS/Development/Q_23954916.html
