pass a value

Article View: bit.databases.mssql-l

Article #224

Back to bit.databases.mssql-l Previous Next

#224

From: alexqa2003
Date: Tue, 02 Sep 2003 02:54

20 lines
1622 bytes

is it possible to do:
(A)
declare @numberofitems Int
@numberofitems = select max(itemorder) 
from store, department, etc.

and pass the @numberofitems to a #tempStore table, like:
(B)
(store, department, @numberofitems,...)

I got itemorder but not the number of items in each department
Alex
 



-- 
Sent  by 3 from yahoo part from com
This is a spam protected message. Please answer with reference header.
Posted via http://www.usenet-replayer.com/cgi/content/new

Technical Details

Message-ID: <l.1062471242.1626678466@host-66-81-78-52.rev.o1.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!logbridge.uoregon.edu!newsfeed.icl.net!newsfeed.fjserv.net!feed.news.nacamar.de!news1.ip-mobilphone.net!news2.ip-mobilphone.net!u128845214@spawnkill.ip-mobilphone.net

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f6611,8372ae1a97d26b7d,start
X-Google-Attributes: gidf6611,public
X-Google-Thread: 107d2f,8372ae1a97d26b7d,start
X-Google-Attributes: gid107d2f,public
X-Google-Thread: 104de1,8372ae1a97d26b7d,start
X-Google-Attributes: gid104de1,public
X-Google-ArrivalTime: 2003-09-01 20:10:12 PST
From: u128845214@spawnkill.ip-mobilphone.net  (alexqa2003@yahoo.com)
Sender: u128845214@spawnkill.ip-mobilphone.net
Newsgroups: bit.databases.mssql-l,comp.databases.ms-sqlserver,microsoft.public.sqlserver
Subject: pass a value
Date: Tue, 02 Sep 2003 02:54:02 GMT
Lines: 21
Message-ID: <l.1062471242.1626678466@host-66-81-78-52.rev.o1.com>
NNTP-Posting-Host: 66.81.78.52
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 8bit
X-Mailer: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4) Gecko/20030624 - ur
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!logbridge.uoregon.edu!newsfeed.icl.net!newsfeed.fjserv.net!feed.news.nacamar.de!news1.ip-mobilphone.net!news2.ip-mobilphone.net!u128845214@spawnkill.ip-mobilphone.net