dbTalk Databases Forums  

I need code

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss I need code in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
vidro
 
Posts: n/a

Default I need code - 12-17-2004 , 02:34 PM






Creating a view from a table I can get the Min and Max of
a column values and than get the diff of the Min and Max.
What I need to do is than is create a database and save
the result into another table.

Anybody have any idea what the code would look like?

Reply With Quote
  #2  
Old   
 
Posts: n/a

Default Re: I need code - 12-22-2004 , 01:29 PM







if your view is named myView

you can just run this:

select *
into myNewTable
From myView


"vidro" <vid_ro (AT) myalias (DOT) postalias.com> wrote

Quote:
Creating a view from a table I can get the Min and Max of
a column values and than get the diff of the Min and Max.
What I need to do is than is create a database and save
the result into another table.

Anybody have any idea what the code would look like?



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.