The Heap™ – Consultancy ©®

Andriy M

05:31

OP vandalised their own question. Should the edit be rolled back?

Another one's changed their question substantially, even though there was already an answer to the original question:

-1

Q: Find a longest sequence that doesn't have duplicates inside

I have database with Id - autoincrement, and Text- varchar. How do i find lowest Id where Text of record is duplicated later. EDIT My database is simple +---+--------+----+----+ | Id| Text |Col1|Col2| +---+--------+----+----+ | 1 | adf |1 |0 | | 2 | qwer |5 |1 | +---+--------+--...

mysql

Ah, never mind, the answerer has posted an update to address the change

dezso

07:01

@AndriyM you forgot to VtC:

Just like that? You want us to do this for you and then you get good marks? Please be fair and try to solve this on your own first. It's all right if you have difficulties that you can't overcome, but if you want us to help you with those specific difficulties, please explain what they are. In other words, please show us what you've attempted so far and where you're stuck. — Andriy M 9 mins ago

@AndriyM I did it (and tried to fix what currently can be fixed)

@TomV their profile contains a big legal warning

dunno if it is mandatory for MS employees or she is like that Oracle guy

Andriy M

@dezso I did. Fixed, thanks. :)

dezso

> The Rob Farley's answer was what i asked originally in question but it wasn't what i really needed.

0

Q: Find a longest sequence that doesn't have duplicates inside

I have database with Id - autoincrement, and Text- varchar. How do i find lowest Id where Text of record is duplicated later. EDIT My database is simple +---+--------+----+----+ | Id| Text |Col1|Col2| +---+--------+----+----+ | 1 | adf |1 |0 | | 2 | qwer |5 |1 | +---+--------+--...

mysql

I am tempted here to roll back, too

did this instead:

If you realized you had a different question, then just roll back to the original state, accept Rob's answer and post this as a new one. Otherwise, your question is a moving target, which might discourage people from answering. — dezso 19 secs ago

ypercubeᵀᴹ

09:20

@MaxVernon or that 'null' != null is neither true nor false. But null ;)

Andriy M

Inappropriate?

Maybe you are helping this person – or maybe you are making them a disservice by indulging their laziness, I don't know. — Andriy M 31 secs ago

Oh great, and now the horse answered as well...

hobs

11:22

dba.stackexchange.com/questions/133527/… anyone with karma want to close with a duplicate question

Andriy M

11:34

@hobs Not sure what you mean. If you provided a DBA.SE link, the question could be closed as a duplicate.

Tom V

11:51

As an aside, learn to type if you want to maximize your chances of success in your chosen career. — Michael Green 2 hours ago

hobs

@AndriyM sorry I posted the duplicate link in the comment in that link

Tom V

:D

hobs

I probably should have just posted it here

33

Q: Microsoft SQL Server Error: 18456

I am getting this error while trying to connect to the sql server. Microsoft SQL Server Error: 18456 Can anybody tell me what the error code means?

sql-server connection error-code

Andriy M

@hobs I did see the link, but the linked question is on SO, not on DBA.SE. Closing as a duplicate cross-site doesn't work.

We'd either need to move the old question over here or the new question over there.

hobs

12:10

Ah, thank you for further clarification, I misunderstood

let me check if I can find one on here, because that is a common question

Tom V

@hobs dba.stackexchange.com/search?q=18456

hobs

Yep, I already was trying to find the most generic response since they didnt include a state

dba.stackexchange.com/questions/120239/… seems about right

Andriy M

13:58

I don't know but to me this seems a bit too much:

0

Q: About linking fields in two tables

I am using SQL Express 2014. I want to make a table with ItemID and ItemName. Then in the second table when I select ItemName, ItemId field should be filled with correct ItemId for that ItemName or when I select ItemId, ItemName for that ItemId should appear. Thanks for help, I am very new to thi...

sql server

I think this is a case where the OP needs to go and read a tutorial.

Andriy M