mohit ranjan

mohit ranjan

  • NA
  • 51
  • 0

Update in order by

Feb 25 2013 1:41 AM
Table 1

DataValue    TokenIndex
AB                  NULL

TABLE 2


TokenIndex    TokenValue
1                    AB
2                  ABAC


i want to update my table1 (TokenIndex) with the  (TokenIndex)  of table2  where table1 (DataValue) (sql LIKE) with (TokenValue)  
TABLE 2   with longest string

EG. AB like like   AB,and ABAC also  but i want 'ABAC'  TokenIndex (which is 2)    to update  in Token index of Table 1  against AB


i want retult 

Table 1

DataValue    TokenIndex
AB                  2








Answers (4)

0
Mahesh Chand

Mahesh Chand

  • 1
  • 270.3k
  • 240.7m
Oct 20 2010 12:57 PM

You don't need to post duplicate questions.
I posted an answer here:
http://www.c-sharpcorner.com/Forums/UploadFile/97719/

Here is a good reading:
Best way to generate Reports in C# and .NET Applications
0
Suthish Nair

Suthish Nair

  • 0
  • 30.5k
  • 7.2m
Oct 20 2010 11:10 AM

refer pdf: www.kenhamady.com/ssrscomp.pdf
0
Muralidharan Deenathayalan

Muralidharan Deenathayalan

  • 167
  • 10.9k
  • 2.5m
Oct 20 2010 11:00 AM
sql reporting services is designed to create reports for the web. Although you can still use it in winforms. While crystla reports.net (the one bundled in VS) is built for winforms. The main advantage that I can see of in using Crystal reports is that you don't have to have a sql server installed to be able to create reports.
Also, the GUI of Crystal is more advanced than that of Sql Reporting services. If I were to choose between the two, it depends on the project. If its a winforms project then I would definitely go for Crystal Reports (for the ease of use) but if its a web project then I would be using sql reporting services.
SQL Server Reporting Services and Crystal Reports
http://www.crystalreportsbook.com/SSRSandCR_Conclusion.asp