|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL Server database programmingmicrosoft.public.sqlserver.programming
Combine records to calculate
David S. -
29 Mar 2007 4:17 PM - 1 message
I have a table that contains arrival times for different vehicles. I would like to be able to combine records by incident and calculate the difference in time of thier arrival. Example incd vehi time ...
Insert Into..Select * from --- minus the Identity column -?
Rich -
28 Mar 2007 7:38 PM - 1 message
I need to insert data into a table in DB2 from a similar table in DB1. I want to say Insert Into tblx Select * from server1.DB1.dbo.tblx tblx contains 40 columns which I would like to not have to list. One of the ...
Creative solution to relatively simply requirement
Rob -
28 Mar 2007 8:35 AM - 1 message
I've always wondered if there is an elegant solution in T-SQL to the following requirement. Consider a database consisting of three tables: Pubs: Table of pubs, e.g. "Red Lion" PubID: Unique ID Name: Name of the pub ...
JOIN Question...
Joe -
28 Mar 2007 12:06 AM - 1 message
I am trying to pull together information from two different Linked Server databases. Let's call the LinkedServerA and LinkedServerB, both of which are Oracle databases. So, what I want to do is pull the following Columns from LinkedServerA: ANUMBER, FNAME, LNAME, C_ID, S_ID, STATE ...
|
|||||||||||||||||||||||