-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: Raghu_78
Message 2 in Discussion
why do
u need to declare a cursor for this?
You
can directly tranfer the content of one table into another like
-
INSERT INTO [TEMP]
([FIELD1], [FIELD2])
SELECT
[FIELD1], [FIELD2]
FROM
[MAIN]
-Raghu
-----Original Message-----
From: BalajiKrishnan
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 19, 2004 6:28
PM
To: BDOTNET
Subject: SQL SERVER
Cursor
New Message on BDOTNET
SQL
SERVER Cursor
Reply
Reply to Sender Recommend
Message 1 in
Discussion
From: BalajiKrishnan
I am declaring a cursor and i need to fetch the record from
the table and assign the record to the temp table
see below
Declare CurParsing cursor for
Select * from TempOpenEnr
OPEN CurParsing
Declare @mcoid char(8)
Declare @claimnumber
char(10)
Declare @iwssn char(9)
Declare @entrydate
char(9)
Declare @notestext varchar(3800)
Declare @testtext
varchar(3800)
Declare @mcotrack integer
Declare @subject
varchar(100)
Declare @dt char(10)
create table #temp(mcoid1 char(8),claimnumber1
char(10),iwssn1 char(9),entrydate1 char(9),notestext1
text)
FETCH NEXT FROM CurParsing INTO #temp values (? how do i
assign)
Balaji
View other groups in this
category.
DISCLAIMER:
This message (including attachment if any) is confidential and may be privileged.
Before opening attachments please check them for viruses and defects. MindTree
Consulting Private Limited (MindTree) will not be responsible for any viruses or
defects or any forwarded attachments emanating either from within MindTree or outside.
If you have received this message by mistake please notify the sender by return
e-mail and delete this message from your system. Any unauthorized use or dissemination
of this message in whole or in part is strictly prohibited. Please note that e-mails
are susceptible to change and MindTree shall not be liable for any improper, untimely
or incomplete transmission.
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
