I need to update information on a table that is on my live server from information that is on a back up server. Is it posable to write an update like I would normaly if I was just doing it on the ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2304...
Hi
I am looking for a way in a SQL query of automatically resolving the date between in an SQL query to the last 12 full calander months.
eg if the report was run today it would return data ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2246...
How do I display row # when run a select * from table in sql 2005
http://www.experts-exchange.com/Microsoft/Development/Q_22778703.html
Hi
I have been using ms sql server 2005 for the past 6 months and mainly used inner joins with unique indexes in the tables. One area that I havent covered is relational databases. I am trying ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2294...
I am getting a syntax error for the following really simple insert statement... can someone point out my error please?
INSERT INTO tblsite
([num],[prod])
SELECT
(nu...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2300...
Hi,
Working on my first stored procedure and it's an archiving project. I am trying to run a select statement on a table, capture the rowcount in a variable, then run an insert statement to in...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23044630.html
Zones:
MS SQL ServerDate Answered: 12/28/2007 Rating: 8.8 Views: 0
I have worked out a sproc that returns the required products and details. I need to page the results on the site by multiples of 6 and have found a simple way of paging results with sql 2005.
T...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23085845.html
I read an article online not to long ago that described a method in which you could set up an autonumber field in one table and use that field to generate the values for several (or at least one) o...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2312...
This is strange, when I run a query in Query Analyser sorting Date, it works fine
ex
select date from AttendantDailyCallSummary order by date ASC
so why when I format the date does the order get...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2313...
Can anyone advise how to create a query using two sets of "LIKE %%" conditions? I tried tbe below query statement but failed.
SELECT *
FROM dbo.coy_free_listing
WHERE coy_free_list_publish = ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23152749.html
