Click here to Skip to main content
15,565,601 members
Home / Discussions / Database
   

Database

 
GeneralRe: Order by several static string values, error "Conversion failed when converting the varchar value 'FX' to data type int" [sort of solved] Pin
jsc4223-Nov-22 0:26
professionaljsc4223-Nov-22 0:26 
GeneralRe: Order by several static string values, error "Conversion failed when converting the varchar value 'FX' to data type int" [sort of solved] Pin
jkirkerx23-Nov-22 7:11
professionaljkirkerx23-Nov-22 7:11 
QuestionCan any body share the schema database for security and share. Pin
Nguyễn Tuấn Anh 9216-Nov-22 6:40
Nguyễn Tuấn Anh 9216-Nov-22 6:40 
AnswerRe: Can any body share the schema database for security and share. Pin
Sam Hobbs6-Nov-22 11:05
Sam Hobbs6-Nov-22 11:05 
AnswerRe: Can any body share the schema database for security and share. Pin
jschell14-Nov-22 7:49
jschell14-Nov-22 7:49 
QuestionHow to avoid duplicate records while using a UNION - SOLVED Pin
Richard Andrew x6428-Oct-22 16:50
professionalRichard Andrew x6428-Oct-22 16:50 
AnswerRe: How to avoid duplicate records while using a UNION - SOLVED Pin
Richard Deeming31-Oct-22 0:01
mveRichard Deeming31-Oct-22 0:01 
GeneralRe: How to avoid duplicate records while using a UNION - SOLVED Pin
Richard Andrew x6431-Oct-22 2:13
professionalRichard Andrew x6431-Oct-22 2:13 
Hi Richard, Thanks for your response. I should have specified that if NULL is returned from either of the subqueries, then the whole record should be ignored. I appreciate your analysis. Thanks!



The difficult we do right away...
...the impossible takes slightly longer.

AnswerRe: How to avoid duplicate records while using a UNION - SOLVED Pin
Andrea Simonassi2-Nov-22 20:55
Andrea Simonassi2-Nov-22 20:55 
AnswerRe: How to avoid duplicate records while using a UNION - SOLVED Pin
PIEBALDconsult6-Nov-22 6:54
professionalPIEBALDconsult6-Nov-22 6:54 
GeneralRe: How to avoid duplicate records while using a UNION - SOLVED Pin
Richard Andrew x646-Nov-22 7:56
professionalRichard Andrew x646-Nov-22 7:56 
QuestionAzure Synapse Where myString like '%Pattern1%Pattern2%' Pin
j11codep3-Oct-22 16:02
j11codep3-Oct-22 16:02 
AnswerRe: Azure Synapse Where myString like '%Pattern1%Pattern2%' Pin
CHill606-Oct-22 2:41
mveCHill606-Oct-22 2:41 
QuestionSimple Unique Identity Value Pin
Richard Andrew x6430-Sep-22 11:30
professionalRichard Andrew x6430-Sep-22 11:30 
AnswerRe: Simple Unique Identity Value Pin
Richard Deeming2-Oct-22 23:04
mveRichard Deeming2-Oct-22 23:04 
GeneralRe: Simple Unique Identity Value Pin
Richard Andrew x646-Oct-22 3:00
professionalRichard Andrew x646-Oct-22 3:00 
AnswerRe: Simple Unique Identity Value Pin
CHill606-Oct-22 2:59
mveCHill606-Oct-22 2:59 
GeneralRe: Simple Unique Identity Value Pin
Richard Andrew x646-Oct-22 3:01
professionalRichard Andrew x646-Oct-22 3:01 
Questionibtogo64.dll error Pin
Dhyanga25-Sep-22 7:06
Dhyanga25-Sep-22 7:06 
AnswerRe: ibtogo64.dll error Pin
Richard MacCutchan25-Sep-22 7:51
mveRichard MacCutchan25-Sep-22 7:51 
GeneralRe: ibtogo64.dll error Pin
Dhyanga25-Sep-22 8:52
Dhyanga25-Sep-22 8:52 
GeneralRe: ibtogo64.dll error Pin
Richard MacCutchan25-Sep-22 9:03
mveRichard MacCutchan25-Sep-22 9:03 
GeneralRe: ibtogo64.dll error Pin
Dhyanga25-Sep-22 9:15
Dhyanga25-Sep-22 9:15 
GeneralRe: ibtogo64.dll error Pin
Richard Deeming25-Sep-22 22:45
mveRichard Deeming25-Sep-22 22:45 
QuestionJust trying to get the count that meets the criteria Pin
jkirkerx4-Sep-22 14:58
professionaljkirkerx4-Sep-22 14:58 

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.