Bookmark Lookup

Technical Article

RE: SQL help on selecting records based on content and their neighbors content

  • Reply

Rob, your join is not considering the page number. you should probably include the page in the join.Michele, your final query pulls all the records of the matching page.. but Gary only needs the page with the sequence.My solution is :Select W.* from #wordmetadata  W Join ( Select w1.page,w1.wsequence as seq1,w2.wsequence as seq2,w3.wsequence as seq3 […]

2005-04-26

Blogs

Daily Coping 3 Feb 2023

By

Today’s coping tip is to ask other people about things they’ve enjoyed recently I...

Daily Coping 2 Feb 2023

By

Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...

Deadline for Microsoft MVP contributions is 20 March 2023

By

Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...

Read the latest Blogs

Forums

Permissions Changes Not Doing Anything

By EsquireDeveloper

Hi friends, So I have a Login to a server that is a windows...

Re-creating AG after server loss

By izinger

We recently had to rebuild servers that were configured with AG. I built everything...

Cannot run DynamicSQL Statement to merge table with JSON

By Weegee71

Hi there I have a problem with a dynamicSQL Statement. In this code, I...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers