Visual Basic

gridView.Columns("yadayadayada").HeaderText = "UseTheForce"

Keywords: KeywordID [PK], Keyword
Items: ItemID [PK], ...
ItemKeywords: ItemID [PK, FK], KeywordID [PK, FK]

SELECT
    B.ItemID,
    Count(1) As MatchedKeywordCount
FROM
    ItemKeywords As A
    INNER JOIN ItemKeywords As B
    ON A.KeywordID = B.KeywordID
WHERE
    A.ItemID = @ItemToMatch
And
    B.ItemID != @ItemToMatch
GROUP BY
    B.ItemID
ORDER BY
    MatchedKeywordCount DESC
;

SELECT
    ...
FROM
    Items
WHERE
    (iKeywords & @KeywordsToMatch) != 0
;

WITH N0 (X) As -- 2 rows
(
    SELECT 1
    UNION ALL
    SELECT 1
),
N1 (X) As -- 4 rows
(
    SELECT 1
    FROM N0 A CROSS JOIN N0 B
),
N2 (X) As -- 16 rows
(
    SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) - 1
    FROM N1 A CROSS JOIN N1 B
),
PowersOfTwo (Value) As
(
    SELECT Power(2, X)
    FROM N2
),
MatchingItems As
(
    SELECT
        I.ItemID,
        I.iKeywords & @KeywordsToMatch As MatchedKeywords
    FROM
        Items As I
    WHERE
        (I.iKeywords & @KeywordsToMatch) != 0
)
SELECT
    I.ItemID,
    Count(1) As MatchedKeywordCount
FROM
    MatchingItems As I
    INNER JOIN PowersOfTwo As P
    ON (I.MatchedKeywords & P.Value) != 0
GROUP BY
    I.ItemID
;

Member 10279246 wrote:

external exe in a frame in vb.net

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

Member 10279246 wrote:

Here this fellow explain how to run winword under a label.. But it is not working.

Member 10192835 wrote:

pls do needfull and send me the solution urgently,

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

Member 10265228 wrote:

I posted a similar query of the Flexera InstallShield forum. I also sent an email to Flexera support. Sadly, over a week and there has no response from either.

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]