TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
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
Reply
Answers (
4
)
0
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
0
30.5k
7.2m
Oct 20 2010 11:10 AM
refer pdf:
www.kenhamady.com/
ssrs
comp.pdf
0
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
select distinct
Incorrect syntax near the keyword 'INNER'.