Select multiple records based on list of Id value in ASP.Net

Question

Hello DharmendrTrust you are good i would love to solve the problem bit by bitDisplay records from multiple tables having same Id in SQL ServerFrom my exampleSession34hj34holds all the value of the posino where  pid 568Now how do i use  these posino where pid568 to select their single and mutiple  id value  with  sessionhj  from cylinder tablePlease help

dharmendr · Accepted Answer

Hi lingersYou have to use below query to select multiple PosiNoSELECT IdPosiNo FROM jobcylinder WHERE PosiNo IN SELECT PosiNo FROM jobcylinder WHERE PId  3956839 AND PosiNo ltgt 3939 ORDER BY unit DESCThen use the result to save in SessionQueryDECLARE jobcylinder AS TABLE Id INTPId INTPosiNo VARCHAR50Colour VARCHAR10Direction VARCHAR10Circumference VARCHAR10Unit VARCHAR10INSERT INTO jobcylinder VALUES559156839393939393939391INSERT INTO jobcylinder VALUES559256839393939393939392INSERT INTO jobcylinder VALUES55935683950108102A13939SILVER3939053939686823393INSERT INTO jobcylinder VALUES55945683950108111A23939MAGENTA3939043939686823394INSERT INTO jobcylinder VALUES559556839501081113A3939DEMI3939033939686823395INSERT INTO jobcylinder VALUES559656839501081114A3

dharmendr · Answer

Refer below querySQLDECLARE jobcylinder AS TABLE Id INTPId INTPosiNo VARCHAR50Colour VARCHAR10Direction VARCHAR10Circumference VARCHAR10Unit VARCHAR10INSERT INTO jobcylinder VALUES559156839393939393939391INSERT INTO jobcylinder VALUES559256839393939393939392INSERT INTO jobcylinder VALUES55935683950108102A13939SILVER3939053939686823393INSERT INTO jobcylinder VALUES55945683950108111A23939MAGENTA3939043939686823394INSERT INTO jobcylinder VALUES559556839501081113A3939DEMI3939033939686823395INSERT INTO jobcylinder VALUES559656839501081114A3939SPOT3939023939686823396INSERT INTO jobcylinder VALUES559756839501081115A3939BLUE3939013939686823397INSERT INTO jobcylinder VALUES559856839501081116A3939BLACK393

Select multiple records based on list of Id value in ASP.Net

Display records from multiple tables having same Id in SQL Server

Company

Explore

Follow us

Contact Us