Click here to Skip to main content
15,499,723 members
Home / Discussions / Database
   

Database

 
GeneralRe: Just trying to get the count that meets the criteria Pin
jkirkerx5-Sep-22 9:41
professionaljkirkerx5-Sep-22 9:41 
GeneralRe: Just trying to get the count that meets the criteria Pin
CHill605-Sep-22 22:05
mveCHill605-Sep-22 22:05 
GeneralRe: Just trying to get the count that meets the criteria Pin
CHill605-Sep-22 22:07
mveCHill605-Sep-22 22:07 
GeneralRe: Just trying to get the count that meets the criteria Pin
jkirkerx6-Sep-22 6:37
professionaljkirkerx6-Sep-22 6:37 
GeneralRe: Just trying to get the count that meets the criteria Pin
Richard Deeming6-Sep-22 22:23
mveRichard Deeming6-Sep-22 22:23 
GeneralRe: Just trying to get the count that meets the criteria Pin
jkirkerx7-Sep-22 7:22
professionaljkirkerx7-Sep-22 7:22 
GeneralRe: Just trying to get the count that meets the criteria Pin
CHill608-Sep-22 0:59
mveCHill608-Sep-22 0:59 
QuestionMSSQL select values in one row by group Pin
Sergey Makarov 20222-Sep-22 6:45
MemberSergey Makarov 20222-Sep-22 6: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 6:47
mveOriginalGriff2-Sep-22 6:47 
GeneralRe: MSSQL select values in one row by group Pin
Sergey Makarov 20222-Sep-22 6:49
MemberSergey Makarov 20222-Sep-22 6:49 
QuestionAzure Synapse Data Flow Linked Data Set table not populating Pin
j11codep2-Sep-22 3:38
Memberj11codep2-Sep-22 3:38 
GeneralAnyone here use Snowflake Pin
Mike Ahrens30-Aug-22 10:37
professionalMike Ahrens30-Aug-22 10:37 
GeneralRe: Anyone here use Snowflake Pin
PIEBALDconsult30-Aug-22 13:57
professionalPIEBALDconsult30-Aug-22 13:57 
GeneralRe: Anyone here use Snowflake Pin
Mycroft Holmes30-Aug-22 13:59
professionalMycroft Holmes30-Aug-22 13:59 
GeneralRe: Anyone here use Snowflake Pin
PIEBALDconsult30-Aug-22 14:22
professionalPIEBALDconsult30-Aug-22 14:22 
GeneralRe: Anyone here use Snowflake Pin
CHill601-Sep-22 4:25
mveCHill601-Sep-22 4:25 
GeneralRe: Anyone here use Snowflake Pin
CHill601-Sep-22 4:23
mveCHill601-Sep-22 4:23 
RantRe: Anyone here use Snowflake Pin
Eddy Vluggen1-Sep-22 4:49
professionalEddy Vluggen1-Sep-22 4:49 
GeneralRe: Anyone here use Snowflake Pin
Mike Ahrens1-Sep-22 11:34
professionalMike Ahrens1-Sep-22 11:34 
JokeRe: Anyone here use Snowflake Pin
Eddy Vluggen1-Sep-22 11:40
professionalEddy Vluggen1-Sep-22 11:40 
GeneralRe: Anyone here use Snowflake Pin
Mike Ahrens1-Sep-22 11:43
professionalMike Ahrens1-Sep-22 11:43 
QuestionRe: Anyone here use Snowflake Pin
Eddy Vluggen1-Sep-22 11:54
professionalEddy Vluggen1-Sep-22 11:54 
GeneralRe: Anyone here use Snowflake Pin
Eddy Vluggen1-Sep-22 11:55
professionalEddy Vluggen1-Sep-22 11:55 
QuestionHow to write a recursive SQL query on a self-referencing table Pin
Code4Ever29-Aug-22 9:13
MemberCode4Ever29-Aug-22 9:13 
AnswerRe: How to write a recursive SQL query on a self-referencing table Pin
Richard Deeming29-Aug-22 22:35
mveRichard Deeming29-Aug-22 22: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.