Click here to Skip to main content
15,510,771 members
Home / Discussions / Database
   

Database

 
AnswerRe: Just trying to get the count that meets the criteria Pin
CHill605-Sep-22 3:28
mveCHill605-Sep-22 3:28 
GeneralRe: Just trying to get the count that meets the criteria Pin
jkirkerx5-Sep-22 9:11
professionaljkirkerx5-Sep-22 9:11 
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 
Very helpful Richard

So I guess I meant ISO 8601, but I called it ISO120 which is my bad.
YYYY-MM-DD

So if that's the native format for Date stored in bytes, I guess converting SmalDateTime to 120 to just give me the date and strip off the time isn't that bad.
If it ain't broke don't fix it
Discover my world at jkirkerx.com

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
Sergey Makarov 20222-Sep-22 6:45 
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
Sergey Makarov 20222-Sep-22 6:49 
QuestionAzure Synapse Data Flow Linked Data Set table not populating Pin
j11codep2-Sep-22 3:38
j11codep2-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 

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.