Click here to Skip to main content
15,908,274 members
Home / Discussions / Database
   

Database

 
GeneralRe: Just trying to get the count that meets the criteria Pin
jkirkerx5-Sep-22 8:41
professionaljkirkerx5-Sep-22 8:41 
GeneralRe: Just trying to get the count that meets the criteria Pin
CHill605-Sep-22 21:05
mveCHill605-Sep-22 21:05 
GeneralRe: Just trying to get the count that meets the criteria Pin
CHill605-Sep-22 21:07
mveCHill605-Sep-22 21:07 
GeneralRe: Just trying to get the count that meets the criteria Pin
jkirkerx6-Sep-22 5:37
professionaljkirkerx6-Sep-22 5:37 
GeneralRe: Just trying to get the count that meets the criteria Pin
Richard Deeming6-Sep-22 21:23
mveRichard Deeming6-Sep-22 21:23 
GeneralRe: Just trying to get the count that meets the criteria Pin
jkirkerx7-Sep-22 6:22
professionaljkirkerx7-Sep-22 6:22 
GeneralRe: Just trying to get the count that meets the criteria Pin
CHill607-Sep-22 23:59
mveCHill607-Sep-22 23:59 
QuestionMSSQL select values in one row by group Pin
Sergey Makarov 20222-Sep-22 5:45
Sergey Makarov 20222-Sep-22 5:45 
Hey all,

there is a MSSQL table with such data,

categoryName        specificationValue      unitName 

Display             15.6                    inch
Display             LED, HD, Anti-glare     NULL
Processor           CORE I3                 NULL
Processor           1005G1                  NULL
Processor           1.2 UP TO 3.4           GHz
Graphics Card       INTEL                   NULL
Graphics Card       Intel UHD Graphics      NULL
System Memory       8                       GB
System Memory       DDR4                    NULL
Hard Disk           256   PCIe® NVMe™ SSD   GB 
Operating System    Windows 10 Home         NULL
Operating System    64                      bit
Optical Drive       DVD                     NULL
Physical            1.78                    kg


I need to get the following line (is it even possible?)
15.6inch LED, HD, Anti-glare | CORE I3 1005G1 1.2 UP TO 3.4 | INTEL Intel UHD Graphics | 8 GB DDR4 | Windows 10 Home 64bit | DVD | 1.78kg


To be honest, I don't really understand how to do this
need your support
thanks!
AnswerRe: MSSQL select values in one row by group Pin
OriginalGriff2-Sep-22 5:47
mveOriginalGriff2-Sep-22 5:47 
GeneralRe: MSSQL select values in one row by group Pin
Sergey Makarov 20222-Sep-22 5:49
Sergey Makarov 20222-Sep-22 5:49 
QuestionAzure Synapse Data Flow Linked Data Set table not populating Pin
j11codep2-Sep-22 2:38
j11codep2-Sep-22 2:38 
GeneralAnyone here use Snowflake Pin
Mike Ahrens30-Aug-22 9:37
professionalMike Ahrens30-Aug-22 9:37 
GeneralRe: Anyone here use Snowflake Pin
PIEBALDconsult30-Aug-22 12:57
mvePIEBALDconsult30-Aug-22 12:57 
GeneralRe: Anyone here use Snowflake Pin
Mycroft Holmes30-Aug-22 12:59
professionalMycroft Holmes30-Aug-22 12:59 
GeneralRe: Anyone here use Snowflake Pin
PIEBALDconsult30-Aug-22 13:22
mvePIEBALDconsult30-Aug-22 13:22 
GeneralRe: Anyone here use Snowflake Pin
CHill601-Sep-22 3:25
mveCHill601-Sep-22 3:25 
GeneralRe: Anyone here use Snowflake Pin
CHill601-Sep-22 3:23
mveCHill601-Sep-22 3:23 
RantRe: Anyone here use Snowflake Pin
Eddy Vluggen1-Sep-22 3:49
professionalEddy Vluggen1-Sep-22 3:49 
GeneralRe: Anyone here use Snowflake Pin
Mike Ahrens1-Sep-22 10:34
professionalMike Ahrens1-Sep-22 10:34 
JokeRe: Anyone here use Snowflake Pin
Eddy Vluggen1-Sep-22 10:40
professionalEddy Vluggen1-Sep-22 10:40 
GeneralRe: Anyone here use Snowflake Pin
Mike Ahrens1-Sep-22 10:43
professionalMike Ahrens1-Sep-22 10:43 
QuestionRe: Anyone here use Snowflake Pin
Eddy Vluggen1-Sep-22 10:54
professionalEddy Vluggen1-Sep-22 10:54 
GeneralRe: Anyone here use Snowflake Pin
Eddy Vluggen1-Sep-22 10:55
professionalEddy Vluggen1-Sep-22 10:55 
QuestionHow to write a recursive SQL query on a self-referencing table Pin
Code4Ever29-Aug-22 8:13
Code4Ever29-Aug-22 8:13 
AnswerRe: How to write a recursive SQL query on a self-referencing table Pin
Richard Deeming29-Aug-22 21:35
mveRichard Deeming29-Aug-22 21:35 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.