What is the best way for a beginner to educate himself on SQL Server 2008 R2 SSRS (e.g. With CRE we have the option for RAW SQL Queries. My goal is to have the knowledge to build CUSTOM reports via queries. The main focus is reporting.ġ) How do you get the information from a DB you will need to start to build queries, when you want to build a query from a proprietary database?Ģ) I am working on reporting through a GUI interface. I am not new to SQL, but I have not had the opportunity to work with it like I do at this job. The company has 15 locations and we are growing fast. The company I work for is using SQL server 2008 R2 with the Point Of Sale software for the retail operations.
#BUY PC AMERICA CASH REGISTER EXPRESS HOW TO#
Re: how to find the return value of reader in mysql everytime (even select command returns data ) it is executing else block only.is there any mistake in select query. RetailEdge offers more features (22) to their users than pcAmerica Cash Register Express (8). MySqlCommand cmd2 = new MySqlCommand(str, connection) pcAmerica Cash Register Express is more expensive to implement (TCO) than RetailEdge, pcAmerica Cash Register Express is rated higher (87/100) than RetailEdge (85/100). MySqlCommand cmd2 = new MySqlCommand(s1, connection)
#BUY PC AMERICA CASH REGISTER EXPRESS UPDATE#
String s1 = " update transaction set out_time='" + s2 + " ' where tag_id='" + sEPC + " ' " MySqlDataReader rdr1 = cmd1.ExecuteReader()
MySqlCommand cmd1 = new MySqlCommand(query1, connection) Copy Code string query1 = " SELECT tag_id,category_id,product_id,product_name,gate_id,remarks FROM transaction where tag_id Like '" + sEPC + " ' AND out_time=NULL"
0 kommentar(er)
