<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto"><div>You're better off storing them as one column. You would be looking at a very complex schema to replicate a parsed message. We have some of the basic fields as columns for filtering, and then store the raw message in a separate column. Good luck<br><br>Sent from my iPhone</div><div><br>On Dec 2, 2013, at 0:54, vishvesh raval <<a href="mailto:vishveshraval@hotmail.com">vishveshraval@hotmail.com</a>> wrote:<br><br></div><blockquote type="cite"><div>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style>
<div dir="ltr">hi sir,<div> i have one query about quickfix messages.i will be very grateful if you give your valuable guidance to me.</div><div><span style="font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif; font-size: 14px; line-height: 18px;"> I want to know that how to store the FIX message into the database to keep the log of the transferring message in sql server 2005. Is it to store whole message into the single column of the table or store the whole message in the Tag value format i.e. column names should be tag names or tag values and actual transferring message values in the row. can anyone give me suggestion on it. Thanks in advance.</span></div><div><span style="font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif; font-size: 14px; line-height: 18px;"><br></span></div><div><span style="font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif; font-size: 14px; line-height: 18px;"><br></span></div><div><span style="font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif; font-size: 14px; line-height: 18px;"><br></span></div><div><span style="font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif; font-size: 14px; line-height: 18px;">Thanks & Regards,</span></div><div><span style="font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif; font-size: 14px; line-height: 18px;">Vishwesh Raval</span></div> </div>
</div></blockquote><blockquote type="cite"><div><span>_______________________________________________</span><br><span>Quickfixn mailing list</span><br><span><a href="mailto:Quickfixn@lists.quickfixn.com">Quickfixn@lists.quickfixn.com</a></span><br><span><a href="http://lists.quickfixn.com/listinfo.cgi/quickfixn-quickfixn.com">http://lists.quickfixn.com/listinfo.cgi/quickfixn-quickfixn.com</a></span><br></div></blockquote></body></html>