Viewing 15 posts - 1,816 through 1,830 (of 3,221 total)
bteraberry
Edited my post to note my assumptions - per your comments at 5:40 PM
August 2, 2010 at 3:53 pm
Here is a step by step conversion of the application format to SQL format
** Note this assumes that the application is passing the date in char format not some...
August 2, 2010 at 3:32 pm
june.troxel
In order to get a tested solution to your question, please post table definitions, sample data and required results. To assist you in doing that please post as outlined in...
August 1, 2010 at 7:58 am
tsmith-960032
In order to get a tested solution to your question, please post table definitions, sample data and required results. To assist you in doing that please post as outlined...
August 1, 2010 at 7:55 am
Nevyn Posted Yesterday @ 11:27 PM
Basically the same thing. Note that adding the AND derived2.A_ID =b.A_ID to my original will also fix the issue of duplicate B_IDs throwing it off....
August 1, 2010 at 6:56 am
Nevyn
I asked the OP a question :
Another question. What defines the first row in Table B? Remember there is no explicit guarantee that rows return by a SELECT statement are...
July 31, 2010 at 9:23 pm
Nevyn changed my create table statements to use your table names and ran your code:
SELECT *
FROM Table_A a
LEFT OUTER JOIN
(SELECT...
July 31, 2010 at 7:51 pm
After SQL Server 2005 SP3 has been applied, it cannot be removed without uninstalling the entire product.
Source for the above quote:
Also read:
July 31, 2010 at 12:42 pm
Alvin Ramard
You know what upsets me about this issue? Lots of companies would not have any second thoughts about doing this with SQL Server but wouldn't dare do this with...
July 31, 2010 at 12:26 pm
who's create date time stamp is first.
I revised table B by adding a column and an additional vaue of A_ID:
CREATE Table #B(B_ID INT,A_ID INT,City VARCHAR(5),State VARCHAR(2),Zip VARCHAR(10),Entered DATETIME)
INSERT INTO #B
SELECT...
July 31, 2010 at 11:03 am
July 30, 2010 at 8:05 pm
helpdesk-1100431
First of all to get tested answers please post your table definitions along with sample data as outlined in the first link in my signature block. It would...
July 30, 2010 at 2:38 pm
OOPs posted incorrectly -- hence removed...
July 29, 2010 at 8:05 am
sunshine-587009
I am unable to open your script.
Do you mean unable to copy and paste the T-SQL into SSMS for testing or
it can be cut and pasted but returns...
July 29, 2010 at 7:08 am
Viewing 15 posts - 1,816 through 1,830 (of 3,221 total)