• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 282
  • Last Modified:

Creating new ms sql field to link records across table for easy user recall in vbscript

I'm a newbie with vbscript and i need help creating a concatenated field joining transID, Date and userID in a hidden form field that ties records together across tables giving user ability to save and come back. Because transID is an incremented field transID in each table differ. Once this field is created it will then be dumped into a session variable to be used in subsequent record creation. Any suggestions how to go about this.
0
GMMC_man
Asked:
GMMC_man
1 Solution
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Select those combined value as a new value and try
Try using like this:

select transID, Date, userID, transID + Date + userID concatvalue
from urtable

Use the combined value for your comparisons or manipulations
0
 
GMMC_manAuthor Commented:
Thanks!
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now