Comments by jaket-cp (Top 200 by date)

oops - I thought you were the original poster
this time I done it correct though :)
been away from codeproject for ages
yep sorry

have a read of this answer it might help
https://forum.freecodecamp.org/t/cannot-understand-this-javascript-nan-practice-problem-please-help-in-explaining-it/464362/30

It would help if the hmtl markup was also supplied in the question.
Also really depends on how the image is linked to the dialog box.
Assuming the image click opens different dialog box tables with the checkboxes.
This is usually performed with the elements unique id.
Can the dialog box id be determined before hand?

created a fiddle and your answer is getting the expected results
https://jsfiddle.net/dmy7x234/
As Patrice T said - what do you not understand

here is a url link to more strings https://www.connectionstrings.com/

? liquid helium - mri

nice 5ed

nice solution - my 5
very similar to mine - but you beat me to it :)

my 5 :)

just for curiosity
could you not use
pro_price BETWEEN 1000 AND 5000
???

nice my 5 :)

I believe Maciej Los wants to know if the times (start and end) - can it be for example 9:35AM

Also can the start and end times span over days?

done a google search for
python int isdigit
https://stackoverflow.com/questions/33049167/attributeerror-int-object-has-no-attribute-isdigit
From the link
isdigit() works only for strings

Agreed +5
Just a small point - if the op wants to save client side they could use the following
https://github.com/eligrey/FileSaver.js/

Looking at the foreach loops
If first condition true (location and item type match)
when DataTable A row "Type" != "GRN"
and DataTable B row "Type" != "STK_ADJ"
I think a row of following will be produced:
| Location | Item Type | AmountA | AmountB | Type |
| A | A | | | |
Is this what you expect?

Another question:
If first condition true (location and item type match)
when DataTable A row "Type" == "GRN"
you want a row added?
when DataTable B row "Type" == "STK_ADJ"
you want a row added?

If that is the case, when testing for them - add new row for each true condition

did you check the fiddle http://jsfiddle.net/jaket/86f9rc7q/2?
I changed the input type from text to email for input id txtEmail.

Also if you click on the 'Reply' button - then codeproject will inform the user they have a message reply or something.

ok - agree with you entirely - new rules, new game :)
happy coding

oh okay - new rules :)

added to a fiddle and change the type to email
http://jsfiddle.net/jaket/86f9rc7q/2
have a look

Having a quick look at the code - I assume validateEmail($(this)); is not being called as the Markup
[input class="form-control" type="text" id="txtEmail" name="txtEmail" required /]
type is text and not email

Also its an answer for a question made in 2016 :)

glad to help :)

nice +5, multiple backgrounds - whoever new?

have you looked at LIKE?
Have a read of
https://www.techonthenet.com/oracle/like.php
Practice Exercise #1:

oh right - re-read your question - you need to use a string function of some sort

Looking at the error message - put another way - it says attempting to insert null into
JSolutionHR.dbo.tblEmployeeMaster.RevisionNo

Check to see what you are getting for
Select @RevisionNo = RevisionNo+1 from tblEmployeeMaster where SID=@EmpSid

Assuming it is getting to this part of the query

ok that's good :)

not used vb.net for some time
When assigning variable as string, should it be as follows:
Dim inputpath As String = TextBox1.Text

what is the value of inputpath (TextBox1.Text)
and is the value of inputpath a local path to input media file
https://www.nrecosite.com/doc/NReco.VideoConverter/html/M_NReco_VideoConverter_FFMpegConverter_ConvertMedia_3.htm

yep I did - I replied to the first comment and not yours

oh right - you want the query to get dynamic columns to put in the pivot query.
From my understanding it is not possible.
if you do a google search http://lmgtfy.com/?q=tsql+dynamic+pivot+columns
you will see that is how it is done

I use similar technique to do dynamic pivots.

http://lmgtfy.com/?iie=1&q=asp.net+c%23+mvc+pdf+viewer+free

print it and you can see the final static query

print @query;

glad to help - but I see that Solution 1 is good, he gets my 5+

what is pdfWriter?

You should be able to do it in SQL - something like this (untested):
select
gr.room_no,
gr.room_status,
gr.housekeeping_status,
case
when gr.roomno is null then ''
else 'R'
end AmIReserved
from room_master rm
left join guestreservation gr
on rm.roomno = gr.roomno
and cast(getdate() as date) = cast(arrivaldate as date)
;

sounds like web scraping is what you want
http://lmgtfy.com/?q=web+scraping+c%23
https://www.codeproject.com/Articles/1041115/Webscraping-with-Csharp

you can use JavaScriptSerializer to serialize a List<Dictionary<String, Object>>
https://msdn.microsoft.com/en-us/library/system.web.script.serialization.javascriptserializer(v=vs.110).aspx

never tried that search myself - lol

words of advice from solution 1 and 2 are good.
Here is a quick jsfiddle I knocked up so you can see how you could potentially do it in javascript
https://jsfiddle.net/oqe2um1f/
if you go through this one and see whats going on - there is a next installment of the fiddle to do a count of the letters
happy coding :)

Or you could declare @projektId to store the projektId and used that as an insert for each record

How does/do cover_id, file and TestCase relate to each other?

What else does the emoji click do?
I ask as if it is only related to the TextArea - you could hide the emoji on the server side when TextArea is being disabled.

agreed brilliant - 5'ed

I assume the customSelect is a jQuery plugin of some sort.
The code to use to setup the initial customSelect, do the same with the cloned one.

why go half way with the cte example?
the select union could go into the cte right?

BoySetsFire use the "Have a Question or Comment?" button instead of adding a solution.

Yep a bit naughty that, but it was similar to solution 10 by ppolymorphe so I thought it would be okay :) - well I think it is/was similar in any case.
I should have mentioned it was ppolymorphe's solution which made me think of the Enum.
Just wanted to get it out there - to see if was a viable way of doing it :)

This does not answer you question, but I wondered how a StringFormat functionality I created some time ago could be converted to remove the last calculation component.
Here is a fiddle I just created to test it out:
https://jsfiddle.net/45k9dq80/
Hope it maybe of some help.

glad to help

I created a quick fiddle:
https://jsfiddle.net/skobzLs7/
maybe it can help you

if copy and pasting does not work for you - you could try command line to merge the files using copy
copy /b *.css xyz.css
or
copy /b abc.css+efg.css+hij.css xyz.css
check out this link: http://stackoverflow.com/questions/2477271/concatenate-text-files-with-windows-command-line-dropping-leading-lines

if that does not work for you - check out this link
http://www.wikihow.com/Merge-Text-(.Txt)-Files-in-Command-Prompt

you may want to look at IDENTITY (Property) (Transact-SQL)
https://msdn.microsoft.com/en-us/library/ms186775.aspx

thanks - i feel like a dunce :)

genius +5
but not sure what SET DATEFIRST 1; is for :)

Implementing a search type engine is no simple task - especially if you want it to be fast.
Have you considered looking at third party tools?

Here is a link to one: https://www.wrensoft.com/zoom/
Not sure if that will help, as do not know what type of information is to be searched.

Query analyzer - that is old school :)
It is a bit more of a mouth full now - Microsoft SQL Server Management Studio (or SSMS for short)

This is not a solution, you should remove it.
Use the reply link type button to reply to comments.
Or improve the question with this information.

Glad to help.
Just remove your solution 1, as it not an answer.
Also have a read of Solution 2 - it explains what I also believe is happening nicely.

nice

This is not a solution, you should remove it.
If you want to want a comment to a cp memeber, use the reply button and put the comment there.

Did you read the link I put in a comment above?
I do not believe tab indexing is your issue.

have a read of this:
http://stackoverflow.com/questions/4209903/asp-net-page-enter-key-causing-post-back
it should give you a few options to do what you want.

http://lmgtfy.com/?q=asp.net+form+disable+enter+submit

Glad to help :)

I found a link that may help you out some more:
http://codetunnel.io/how-to-debug-your-aspnet-projects-running-under-iis/

In visual studio 2013 you could try changing the properties of the web project.
Solution Explorer > right click web project > Properties
Web > Servers > Select Local IIS
In any case fiddle with the server settings

Sinisa, by any chance to you have a reference link where it states the common use of lower case for css class names.
If you know of a pros-cons link that would be good.
As I on the whole use PascalCase for css class naming.
thanks

glad to help
also have a look at
https://jsfiddle.net/5oty8wvb/1/
https://jsfiddle.net/5oty8wvb/2/
to see how the code can be mixed about.
Play around with them to made improvements for code re-use.

Also populating backgrounds array - extra [comma] needs to be removed.
https://jsfiddle.net/5oty8wvb/

Can you supply the javascript code and possibly the generated markup, so we can let you know where you are going wrong.
If you are using rowspan, you will need to remove the td/cells of the the ones added by the rowspan - hope that makes sense.

have a read of:
https://msdn.microsoft.com/en-us/library/ms188385.aspx
ORDER BY Clause (Transact-SQL)
Specifying a conditional order

It should help you out, you should be able swap out the column with the variable @SortOrder.
You maybe required to have the case statement multiple times for each additional column sort.

No problem glad to help.
Hope you have learnt some more today :)

Good to hear.
We got there eventually :)

not the

AS
BEGIN

But the

begin
IF @abc='insert' and ...


The @data table insert and select statement needs changing.
The where clause should be where UnderGroup='Sales A/C'
you have added an extra @, where it is checking if the variable
@UnderGroup is the sales value.

Yeah you are probably right, but after reading it, I started putting them everywhere.
And also because I started using cte more.
For some reason don't like the look of
;with
it just don't look right :)

As i mentioned there is a begin before the if - what is it doing there?

A way of finding out what the values of @abc and @Group_Name are is do a print of them just before the if statement and when you run it should show up in the messages tab (that is if you are using sql server management studio)

But what is the value of @abc and @Group_Name when it gets to the if statement?
For example: when @abc = 'UPDATE' then it will not meet the criteria of the if statement and the insert will not be performed.

Here it is:

"Not ending Transact-SQL statements with a semicolon" has been put in the list of
Features Not Supported in a Future Version of SQL Server
https://msdn.microsoft.com/en-us/library/ms143729(v=sql.120).aspx

I have been recommending to possibly get in the habit of using the semicolon statement terminator for all statements.

Maybe I shouldn't be doing that anymore?

Thanks for that :)
I try to put them in as good practice even though they are not required.
Maybe it is not good practice then :(

I read somewhere that the semicolon is required to terminate all statements in possible future releases of MSSQL server.

Let me see if I can find the link.

okay - how do you know it is not working?

what are the values of @abc and @Group_Name
and the begin for the if is in the wrong place.

Just wandering why you would say "the terminating semicolon is redundant"?

I do not believe the "or" in the if condition is that issue.
I have posted a solution which maybe the cause of the problem.

are they the same value?

okay - that will not work

how many?

execute the following:
select Group_Name from tbl_AccountGroup where UnderGroup='Sales A/C'
what is being returned?

Depends on what you mean by last 10 records.
If you mean the last 10 records that have been inserted into the table, then you will probably have to look in the transaction logs.

But if you want to delete the last 10 records ordered by FirstName, MiddleName or LastName, then that is more straight forward.

if that is what you are doing, then you could also do it like this:
@Group_Name IN ('Capital Account','Current Liabilities','Current Assets','Fixed Assets','Profit & Loss','Revenue Account','Suspense Account','Loan')
OR
@Group_Name IN (
SELECT 'Capital Account'
UNION ALL
SELECT 'Current Liabilities'
UNION ALL
SELECT 'Current Assets'
UNION ALL
SELECT 'Fixed Assets'
UNION ALL
SELECT 'Profit & Loss'
UNION ALL
SELECT 'Revenue Account'
UNION ALL
SELECT 'Suspense Account'
UNION ALL
SELECT 'Loan'
)

But I suppose it can be maintained more easily when placed stored in the @data table.

Hope that helps you out.

But on second thought, it would be better if you create a permanent Group lookup type table. As suggested in solution 1 oops meant solution 2.

For example if a new Group_Name was required, then all you need to do is insert it into the Group lookup table rather than modifying the sql code to add the extra group into the list.

As in your sql code.
Remove delcare, insert and select from @data table.
Add in grp for the select statement, like below:

SELECT 'Capital Account' grp
UNION ALL
SELECT 'Current Liabilities'
UNION ALL
SELECT 'Current Assets'
UNION ALL
SELECT 'Fixed Assets'
UNION ALL
SELECT 'Profit & Loss'
UNION ALL
SELECT 'Revenue Account'
UNION ALL
SELECT 'Suspense Account'
UNION ALL
SELECT 'Loan';


If that is all you need to do, then you do not need to insert into a temp variable table. Unless you are using the @data TABLE in multiple places.

Just do the select with union all and give the first column an alias of grp.
SELECT 'Capital Account' grp
UNION ALL
...

Can you give an example on how you would like to use the list.

On a side note: possibly get in the habit of using the semicolon statement terminator for all statements.

"Not ending Transact-SQL statements with a semicolon" has been put in the list of
Features Not Supported in a Future Version of SQL Server
https://msdn.microsoft.com/en-us/library/ms143729(v=sql.120).aspx

Not saying it is going to happen any time soon though.

Did you find the link from d@nish?

i suggest you remove it unless any others mark you down - i will compensate it a little by giving it a few extra stars

that is harsh you getting mark down for this solution

Thanks for that, but I understand what is happening but the op does not.
I would also give links to DateDiff and GetDate.
And probably explain in pseudocode code what is happening, that would be a improved solution and I would give you a 5star for that :)

It would be good if you could do an In Long version of your solution

these are all 3rd party solution - the op asked for non 3rd party tools.....

It sticks in my head as the first time I saw it, I was using 2008 to try it out, with no luck :)

Just a small point, the CONCAT function becomes available in SQL Server 2012+

Good that is good :)

Looks correct to me.
It could be a browser cache issue.
You may have to perform a hard-refresh
ctrl+F5 or ctrl+R
http://refreshyourcache.com/en/cache/

Did you change the function name to submitChangej?

This is not a solution, you should remove it.
I have also put up another solution using PATINDEX, have a read.

I was just wondering would there be a major benefit in having an index on Match_Flag if only two possible values of 'Y' and 'N' exist.
I would have suggested putting a clustered index on columns Store_Range_Grp_Id, Range_Event_Id.

As I said, just wondering that is all...

How did you try to add the cascade?

You should be able to remove the Foreign Key constraint and then add it back with the on delete cascade or on update cascade

Have a read of
https://msdn.microsoft.com/en-us/library/ms175493.aspx

which in turn you should read
https://msdn.microsoft.com/en-us/library/ms189579.aspx
and then
https://msdn.microsoft.com/en-us/library/ms189049.aspx

maybe try putting the column name in square brackets like so [E-Run Time], it may help.

Have a read of:
https://technet.microsoft.com/en-us/library/ms176027(v=sql.105).aspx

have a read of these:
sp_rename (Transact-SQL) - https://msdn.microsoft.com/en-GB/library/ms188351(v=sql.105).aspx
How to: Rename Tables (Visual Database Tools) - https://msdn.microsoft.com/en-us/library/aa337520(v=sql.105).aspx
they should help you out

Top two links:
http://lmgtfy.com/?q=mssql+rename+table

maybe have a read of
http://www.jqwidgets.com/jquery-widgets-documentation/documentation/jqxtreegrid/jquery-treegrid-getting-started.htm?search=
it may help you out.

check out this fiddle: https://jsfiddle.net/5nq1kzxf/
it appears to work fine
add in the css styling and probably remove
<script src="//code.jquery.com/ui/1.11.4/jquery-ui.js"></script>

why do you consider this to be a proper question?
if you have to link off to another site to get the full details of the question

You may be interested in or maybe not - but have a read of:
Restore a SQL Server Database to a Point in Time (Full Recovery Model)
https://msdn.microsoft.com/en-us/library/ms179451.aspx

It should be possible to do it with an update on a recursive cte.
Or an update on lead/lag - not sure on this one.
But a simulated lead/lag on an join update should work.

In all the above possibilities the ordering of the records need to be defined.
Can you define the ordering of the records.

Also in your example, shouldn't
Investments 240 ahnc Investments
Investments 241 hnnc Investments
be
Investments 240 ahnc
Investments 241 hnnc Investments

As if comparing previous with current,
Investments (240) would be compared with Nokia (610) - no match so Parent would be empty.

Please clarify these points.
Thanks

thanks :)

okay if that is the case.
Add an additional column, something like this:
year(dateadd(M,-6,ac1.RequestedOn)) FiscalYear

What is the fiscal year?
Can it be derived from AdvancePayment.RequestedOn?

you are welcome, glad to be of help.

thanks, and also thanks for testing :)

Thanks for the reasoning.
Similar to the having, adding additional conditions to the where clause can do the same.

My brain is just wired up a bit differently :)

Using the "not in" may not be an optimal way of figuring it out.
Have you considered using a left outer join as in solution 1?

Why do you use group by?
I would say the following would be easier to understand what is going on:
SELECT distinct WorkNum FROM @TBL where ratecodes = 'toys'
Just wondering that is all...

similar as in solution 2

maybe try:
onclick="OpenPage();return false;"
see if that works

I assume it has something to do with the css selector:
input:not(:checked) ~ textarea

Have a read of these, they may help you out:
https://developer.mozilla.org/en-US/docs/Web/Guide/CSS/Getting_started/Selectors
https://css-tricks.com/almanac/selectors/c/checked/

you can fiddle with the @Today.
SET @Today = DATEADD(month, -12, GETDATE())

have a read of
http://www.w3schools.com/jsref/dom_obj_event.asp
https://developer.mozilla.org/en-US/docs/Web/Events

for a possible list of events possible

That jsfiddle was to show that label and checkbox can be hidden in the same way as your code does with the submit button.

What you need to do is add an event or something to the input test and trigger the submitChange function.

Here is an update jsfiddle:
http://jsfiddle.net/zg2kbe01/1/
It should get you the idea of how it can be done
An onblur has been added to the input textbox.
When a blur event occurs on the input textbox then the submitChange is called.
This in turn validates the input text box values and will show or hide the Container accordingly.

Hope that gets you on your way.

I have created a simple jsfiddle so you can see that show and hide works for checkbox and label.
http://jsfiddle.net/zg2kbe01/
Hope that helps you out

you can use style.display on those elements you want to display, block and none - as has been implemented with inputSubmit

If I get what you are asking.
You could get submitChange to be called everytime one of the input textbox or checkbox gets changed/modified.

also mark it as solved to remove from pool of unanswered questions.

glad to help

okay that is good, you only require one or the other, not both.

okay on that fix.
Which one of the 3 did you try to get the submitChange() to get executed after page load?

Just had another look a your javascript
inputlastName is missing value

which one did you try?

agreed +5

More info is require.
I am not sure how office 365 and javascript will be applied.

Also use the 'Improve question' link to update your question.

Where is the inbox mail?
You need to supply more information, if you are going to get any help.

Have a read of DELETE (Transact-SQL):
https://msdn.microsoft.com/en-us/library/ms189835.aspx
Using joins and subqueries to data in one table to delete rows in another table

Should help you out on how to use joins with delete

As F-ES Sitecore has suggested, supply your stored proc so we may be able to help more.

But if you have not check it out already, maybe tsql aggregate functions with over may help.
Have a read of:
https://msdn.microsoft.com/en-GB/library/ms173454.aspx
https://msdn.microsoft.com/en-GB/library/ms189461.aspx

If the min(dos) ordering is not correct with servicecode.
You need to figure out what ordering is required and put it in the row_number() over(...) somehow.
I will update the solution to give you an idea.

How about situation when * does not exist for the name?
This is the one which I can see not easily definable.

Also the characters before and/or after name are not consistent (include . and " from your sample data).

The solutions has been update with a couple of sql(s) which should work.

It can be performed in TSQL (using loops and the like) but, I would not say it can be done in one sql statement.

From looking at the summary records, it will be not be straight forward.

Inspecting the first record, I assume they are split like so:
asdffgggggg Anand *
edkkofffmfmmfmfm Bala
sdkdodkekeke Chandra
dkkdkd "vinoth"*

As I can see, there are no easily definable rules to split the mini-records that do not have the * after the name.

If the real data is not like the sample data supplied and it has a split rule that can be used to get the summary separated data. Then it may be possible to get the result within one sql query.

Same question:
Can summary be split with defined rules?

okay - sorry about that, thinking of asp.net

You could try a client side way of doing it.
Check out this link
http://highcharttable.org/
Have not used it myself, but seems like a viable solution.

From what I can see from your sample data, your main issue is initially to separate the summary column into 4 bits of information.
If there is a consistent way to define how to separate the data, then it should be quite straight forward to proceed to the next step.
But it does not appear as though these bits of information can be separated with any definable rules. Unless you take into consideration of the name, but then that will get very messy.

So the question is:
Can summary be split with defined rules?

I am not sure who gave a bad rating, the reason is, is you should not put comment as solution.
I advise you to remove this solution and put it in a comment to solution 1 using the "Have a Question or Comment?" button.

But to answer your comment, it will probably be best to use google.
I performed a search of "simple javascript quiz tutorial" and one of the top links is:
http://code.tutsplus.com/tutorials/build-a-spiffy-quiz-engine--net-20185
Hope that helps you out.

Why do you what it to be done in javascript?

css should do the trick and would be the correct way of doing it.
Check out:
https://developer.mozilla.org/en-US/docs/Web/CSS/background-image

You should reply to the comment so the comment originator (being myself this time) will get a notification.

As I mentioned please supply the generated markup for the img tag.
Use the "Improve question" link/button to update your question.
Also supply the javascript code, the c# code should not be required, if the images are being uploaded as you have stated.

Can you supply the generated markup for the img tag.
Also where are the images stored on the site?

I assume it has something to do with it img src not pointing to the correct path.

Have a read of this, it may help:
https://css-tricks.com/quick-reminder-about-file-paths/

The HTML and jQuery appear to be okay - have created a fiddle and it is checking and unchecking all as expected
http://jsfiddle.net/eyLey1v7/ - let me know if I am missing something...

Just a small point on the jQuery, rather than looping through #dtsResult, loop #dtsResultBody instead. Reason being #CheckAllRes will not get checked or unchecked again.

As I said I am not the OP.
Was just interested to know the solution to the question of the OP, that is all.
Thanks :)

Thanks for the reply - this is not my question.
I was just interested in what the solution could be, but reading the document you pointed to did not answer it for me.

From the sub-queries the script is checking for and UserId=7
Also deviceid in (25,30) and deviceid in (26,31) have been specified.
Do these relate to a "punch-in"/"punch-out"?
In the sample data, there is a DeviceId of 29, which is not in the query.
I assume in the output data, you would like to have the UserId.

Please update your question to make it more clear on your requirements, so we may be able to help.

Can you specify where in the documentation you are referring, to answer this question.
Thanks

It may be a good idea to save the date of birth instead of a fixed age.
The age of the user can be derived from the dob to a given date.

have a read of this:
http://stackoverflow.com/questions/10877407/t-sql-how-to-create-tables-dynamically-in-stored-procedures
it may help

A simple select search should suffice.
https://msdn.microsoft.com/en-us/library/ms189499.aspx

But it depends on the search criteria.
Can you specify how the 4 records are derived from the data in #tmpList.

I am just interested to know, is this homework or the like?
As these are rudimentary mistakes.
In any case solutions 1 and 2 should answer your question.

thanks :)

If you are asking about getting the third highest...
Solution 1 has an example.
You could do something like this
select top 1 salary from (select top 3 salary from employee order by salary desc) order by salary.
Not tested, but you should get logic behind it.
have a look at
http://blog.sqlauthority.com/2007/04/27/sql-server-query-to-retrieve-the-nth-maximum-value/

I am quite sure there are other ways of doing it too.
Do a google search of
"tsql select nth record"
http://lmgtfy.com/?q=tsql+select+nth+record
should get you more examples.

Hope that helps out.

not sure, never done that before :)
maybe hover over the solution and it may show up extra links/buttons etc

you have everything you need to figure it out.
okay - try this
alert(jQuery.parseJSON(data).position);

this is a different question.
But what are you trying to alert?

please also mark as solved

okay that is good - learn to debug and happy coding :)

okay
so alert(data) gets you that, it is probably a string

so try
dataToTable($('#routes'), jQuery.parseJSON(data), 'route');

As you can see from the fiddle the dataToTable is working as expected when the data is sent in correctly.
I assume the ajax call is returning something different from what is expected.
It may be getting it back as an xml object or even a string.
Or it could be sending back a json object wrapped in a d.
Hard to tell as I cannot debut the code.
You will need to debug and figure out what the you are getting in the response data.

But try saying that, try
dataToTable($('#routes'), data.d, 'route');
see if that works

oh well, it is time to debug.
Try a console.log(data) and see what you get.

simulate keydown event javascript
google is your friend:
http://lmgtfy.com/?q=simulate+keydown+event+javascript
http://stackoverflow.com/questions/596481/simulate-javascript-key-events

yes - you may be right :)
but your
(year - row_number() over (partition by name order by year)) as grp
was the main part of the solution
just added some extra bits to it, that is all
happy coding

thanks

:) you are the best...

nice - but does not cater for OP continuous 6 years scenario.
When (16, 'Arun', 2005), (17, 'Arun', 2006) is added to the test data, it only returns the first 3 years.
no disrespect :)

This question is more than 2 years old, not a good idea to answer old questions.
Also this question has an accepted solution.
On top of that, it does not appear as though your solution will get what the op asked for.

cool, thanks

+5 for the c# and vb.net - neat :)
is that in-built in the wysiwyg editor?

Am I missing something, what is a tap in this context?

more than 2 years old :)

this question is more than 2 years old
Also what is the solution you are giving, how does it relate to the question?

Update you question with this bit of information - use the "Improve question" Link.
Can you also give more information on why the following should not be returned
aId Bid B.Name
101 201 A
And clarify what you mean by:
b'Coz it have 180 in another row

Include more sample data if this helps with the question

have a read of following link
https://msdn.microsoft.com/en-us/library/ms345415(v=sql.110).aspx

You could try a dotnet decompiler of some sort.
With a little googling - check out this link it may help:
http://stackoverflow.com/questions/2646707/something-better-than-net-reflector

Interesting - at first, I would have said it was not possible in css.
But with a bit of googling I found it can possibly done in css3.
Check out these links:
http://stackoverflow.com/questions/16912023/css3-transition-click-event
http://stackoverflow.com/questions/11166580/css3-transitions-is-there-an-on-click-option-without-using-jquery
http://jsfiddle.net/nMNJE/
and another one
http://vanseodesign.com/css/click-events/

Now this one is a 5 year old question and it has a marked solution as well.

You are answering a 4 year old question.
That is nice and all, but you may get down voted, even though you have given a good solution.
It maybe a good idea to delete you answer.

nice :)

What have you tried so far?
If you have not tried anything yet, then please have a read of
http://api.jquery.com/jquery.ajax/

Any issues with that implementation, then update your question and I am sure you will get help.

Having a quick look, please fix your html first, it is not well formed.
For a start div tag is not allowed to be a direct child of tr tag.
The opening and closing of div tags are also misplaced.
In the table tag, when implementing css use the style attribute.

Not sure, it is hard to say.
Here are a couple of suggestions you could try.
Firstly, figure out if the bind javascript is being executed at all, try debug or the alert/console.log method (put just before the binding).
If it is not being executed, then as you have know, there is an issue with the Master/Content page (probably some other javascript being used in the Master page, or possibly a lack of javascript library).
In any case you need to figure out what the issue is.
What you could do is create a content page with no code-behind and minimal textbox and search textbox to use the Master page (or a copy of the Master page).
If it works then, the problem exists in the original content page, but if it does not, then assume it is in the Master page.
In either case, the next step would be to add/remove components from the offending page (be it content or master) and test on each iteration change to see if it works in the web browser.
Ensure you do a hard-refresh in the web browser, so you hopefully know what is being tested is what you have changed.
http://refreshyourcache.com/en/cache/
http://wiki.scratch.mit.edu/wiki/Hard_Refresh
I believe in most windows web browsers, Ctrl+R will work for a hard-refresh.
Hope that helps out :)

That looks okay to me.
It may not be a javascript issue, it could be an issue with the aspx markup or something.
Try and debug as "F-ES Sitecore" has suggested - he knows what he is talking about.
Or you could try using alert or console.log for a quick test to check if the javascript code is doing what you expect.
Here is a quick knocked up fiddle for a simple test http://jsfiddle.net/7kfzwcns/

Okay if that is the case, I believe the input data may be incorrect.
I have written a CTE for the child-parent relationship but there are quite a few duplicates and the recursion does not stop, so I had to put a limit in.

You should use the 'Reply', so the user who wrote the comment will get a notification.

Just to confirm is the parent, child relationship between DetailComponent and ParentId?
Also can you check you data - is the
union all SELECT 'R222-54','52342-00',6
correct?

Just to clarify, are you using "SQL-server-2008R2" and not "SQL Server 2012".
The only reason I ask is that the identity re-seed (jump issue) is a built in feature to "SQL Server 2012".
If you are on "SQL Server 2012", then check out this link:
http://www.codeproject.com/Tips/668042/SQL-Server-Auto-Identity-Column-Value-Jump-Is

:)

thanks :)

:) thanks

okay I will try :)
have another read, I have updated solution with comments.
hopefully it should be more clearer :)

:)

does it matter what order the positive and negative are in?