Re: what's wrong w/ my queries?

From: oj (nospam_ojngo_at_home.com)
Date: 09/13/04 

Date: Mon, 13 Sep 2004 15:13:07 -0700

okay, i'm not going to add more naggin' instead i'll give you a solution to
your *merge" based on your info (no pk, no relation, etc.).

e.g.
declare @t1 table(i int, j int)
declare @t2 table(k char, l char, m bit)

insert @t1 select 1,2 union all select 3,4
insert @t2 select 'a','b',0

select t1.*,t2.*
into #tmp
from @t1 t1 full join @t2 t2 on 1=2
go
select * from #tmp

"John" <jtaylor@kmznet.com> wrote in message
news:2qmfnbFu27orU1@uni-berlin.de...
> Curses! He's seen through my diabolical Master Plan!
> heh
>
> Thanks for the help AM!
> To answer the DBA posts, basically,
> I'm just glad to have a job coding so early in my schooling and
> am learning as I go. Letting clients dictate processes to me?
> Hell yeah! The man directing me has been programming for
> more than 20 years. I offer my insight, but I'm not going to
> dictate to him how his programs should run. He dictates to me.
> If I can't figure out how to work around legacy apps, I'm
> sure he can find others who can.
>
>

Relevant Pages

  • Re: Can C do it ?
    ... looked above my present understanding and expectation of programming. ... the first one with pointers, ... int main ... char Verb2; ...
    (comp.lang.c)
  • global jumps and stack
    ... I'm programming two ATmega162s which should do some communication via their ... In the case that at that time no char would arrive at usart0, ... int i = 0; ... // Timer 2 output compare interrupt service routine ...
    (comp.arch.embedded)
  • Re: newbie strcmp woes
    ... > first foray into non-trivial C programming. ... Thus the compiler silently discards the terminating '\0' byte ... EOF doesn't fit in a 'char'. ... an 'int', and you may as well make the other chars 'int' too. ...
    (comp.lang.c)
  • Re: Access violation error
    ... char *encpwd16 = NULL; ... Passwd_Encriptado16, int *version); ... this actually says NOTHING about whether or not the first parameter is ... doesn't understand either C or modern programming practice. ...
    (microsoft.public.vc.mfc)
  • Re: Where are the program variables stored in memory(text, data or stack segments)
    ... int main ... char *test; ... char *tmp = NULL; ... local variables go on the stack, mallocallocates memory from the heap, and global variables go in a special area set up on program start up. ...
    (comp.lang.c)
Loading