Click here to Skip to main content
15,905,874 members
Home / Discussions / Database
   

Database

 
AnswerRe: (Expiring Next Month) Problem Pin
GuyThiebaut11-Aug-14 22:07
professionalGuyThiebaut11-Aug-14 22:07 
QuestionT-Sql Distribute data into groups based on existing numbers Pin
dreaddan10111-Aug-14 10:42
dreaddan10111-Aug-14 10:42 
AnswerRe: T-Sql Distribute data into groups based on existing numbers Pin
Jörgen Andersson13-Aug-14 22:44
professionalJörgen Andersson13-Aug-14 22:44 
QuestionProblem with Decimal Places and Rounding off Pin
Vimalsoft(Pty) Ltd9-Aug-14 23:02
professionalVimalsoft(Pty) Ltd9-Aug-14 23:02 
AnswerRe: Problem with Decimal Places and Rounding off Pin
Kornfeld Eliyahu Peter10-Aug-14 0:00
professionalKornfeld Eliyahu Peter10-Aug-14 0:00 
GeneralRe: Problem with Decimal Places and Rounding off Pin
Vimalsoft(Pty) Ltd10-Aug-14 1:28
professionalVimalsoft(Pty) Ltd10-Aug-14 1:28 
QuestionSelect and Update Pin
jkirkerx8-Aug-14 11:43
professionaljkirkerx8-Aug-14 11:43 
AnswerMy none soup version Pin
jkirkerx8-Aug-14 12:11
professionaljkirkerx8-Aug-14 12:11 
Here I get must declare the scalar @CCInfo in the UPDATE Section
I understand what it means, I just don't know how to go about getting the scalar to be recognized in Update.
The first part works, just having trouble with the update.

DECLARE @CardID INT, @OrderNumber VarChar(40);
SET @CardID = 645;
SET @OrderNumber = 'CA-2054';

DECLARE @CCInfo TABLE
(
   Label VarChar(40) 
 , CardBrand VarChar(80) 
 , CardExpMonth VarChar(80)
 , CardExpYear VarChar(80)
 , CardHolder_FirstName VarChar(80)
 , CardHolder_LastName VarChar(80)
 , CardNum VarChar(80)
 , CardPhoneNum VarChar(20)
);

 INSERT @CCInfo
 (
   Label
 , CardBrand
 , CardExpMonth
 , CardExpYear
 , CardHolder_FirstName
 , CardHolder_LastName
 , CardNum
 , CardPhoneNum
 )
 SELECT 
  Label 
, CardBrand 
, CardExpMonth 
, CardExpYear 
, CardHolder_FirstName 
, CardHolder_LastName 
, CardNum 
, CardPhoneNum 
 FROM CardInfoPerm  
 WHERE CardID=@CardID
 
 UPDATE
  OrderInfo
  SET
    CardID=@CardID
  , Cardlabel=@CCInfo.Label
  , CardBrand=@CCInfo.CardBrand
  , CardExpMonth=@CCInfo.CardExpMonth
  , CardExpYear=@CCInfo.CardExpYear
  , CardHolder_FirstName=@CCInfo.CardHolder_FirstName
  , CardHolder_LastName=@CCInfo.CardHolder_LastName
  , CardNum=@CCInfo.CardNum
  , CardPhoneNum=@CCInfo.CardPhoneNum
  , PaymentInfo=@CardID
  , ApprovalCode=''
  , AuthorizationID=''
  , CheckID=''
  , CheckLabel=''
  , CheckType=''
  , CheckName=''
  , BankName=''
  , CheckRoutingNum=''
  , CheckAccountNum=''
  WHERE OrderNum=@OrderNumber

AnswerRe: Select and Update Pin
PIEBALDconsult8-Aug-14 20:57
mvePIEBALDconsult8-Aug-14 20:57 
Answer[Solved] Pin
jkirkerx10-Aug-14 12:50
professionaljkirkerx10-Aug-14 12:50 
AnswerRe: Select and Update Pin
MeutherOlaf11-Aug-14 20:36
MeutherOlaf11-Aug-14 20:36 
QuestionWeird problem with UNION query in Access 2010 Pin
Peter R. Fletcher8-Aug-14 3:46
Peter R. Fletcher8-Aug-14 3:46 
QuestionFind the right SSMS Pin
Corporal Agarn8-Aug-14 1:53
professionalCorporal Agarn8-Aug-14 1:53 
AnswerRe: Find the right SSMS Pin
Richard Deeming8-Aug-14 2:18
mveRichard Deeming8-Aug-14 2:18 
GeneralRe: Find the right SSMS Pin
Corporal Agarn8-Aug-14 2:25
professionalCorporal Agarn8-Aug-14 2:25 
Questionsql server insert into select + in select part if else Pin
Karan_TN7-Aug-14 0:16
Karan_TN7-Aug-14 0:16 
AnswerRe: sql server insert into select + in select part if else Pin
Mycroft Holmes7-Aug-14 0:55
professionalMycroft Holmes7-Aug-14 0:55 
QuestionHow to change multiple date formats in Sql server Pin
AzeeM_R6-Aug-14 2:51
professionalAzeeM_R6-Aug-14 2:51 
AnswerRe: How to change multiple date formats in Sql server Pin
Corporal Agarn6-Aug-14 3:38
professionalCorporal Agarn6-Aug-14 3:38 
AnswerRe: How to change multiple date formats in Sql server Pin
Richard Deeming6-Aug-14 3:50
mveRichard Deeming6-Aug-14 3:50 
AnswerRe: How to change multiple date formats in Sql server Pin
Mycroft Holmes6-Aug-14 14:16
professionalMycroft Holmes6-Aug-14 14:16 
SuggestionRe: How to change multiple date formats in Sql server Pin
AzeeM_R11-Aug-14 8:14
professionalAzeeM_R11-Aug-14 8:14 
QuestionHandling Duplicate records Pin
Ambertje5-Aug-14 4:35
Ambertje5-Aug-14 4:35 
Questionsplit datatable column using c# Pin
Jaimin H. Soni4-Aug-14 22:31
Jaimin H. Soni4-Aug-14 22:31 
QuestionRe: split datatable column using c# Pin
Eddy Vluggen5-Aug-14 2:35
professionalEddy Vluggen5-Aug-14 2:35 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.