Forum Replies Created
Viewing 15 posts - 1,351 through 1,365 (of 5,109 total)
-
RE: SQL Query Modification Request
Not sure I really understand your goal here I'm afraid. Sample data (as text) and your expected results will be really helpful here.Could you try to elaborate on your logic...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
RE: SQL 2008R2 Uptime
What do you mean what should you do? If you can't control it there's very little you can do. Have they given a reason for not following good update processes?...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
RE: Issue with midnight in stored procedure
We're missing a piece or 3 of the jigsaw here. Yes, that's the SQL that's raising the error, but that is because that variable does have the value NULL. We...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
RE: Calculating duration between two dates which go over months (splitting by month)
alex.richards - Friday, December 14, 2018 5:31 AMThom A - Friday, December 14, 2018 5:28 AMRE: Calculating duration between two dates which go over months (splitting by month)
alex.richards - Friday, December 14, 2018 5:11 AMThom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.ukRE: Calculating duration between two dates which go over months (splitting by month)
alex.richards - Friday, December 14, 2018 3:24 AMThom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.ukRE: Sort comma separated value in SQL Table
PSB - Tuesday, December 4, 2018 10:10 AM
Your database isn't in compatibility mode 120 or lower is it? (although, you'll...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.ukRE: Sort comma separated value in SQL Table
PSB - Tuesday, December 4, 2018 9:41 AMThom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.ukRE: Sort comma separated value in SQL Table
Have a look at delimitedsplit8k_lead and FOR XML PATH. Have a go, and if you don't succeed post what you tried and what the problem was.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.ukRE: How to split comma separated values stored in XML node Without using function- SQL Server 2012
Patchai001 - Monday, December 3, 2018 8:26 AMThom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.ukRE: Writing to multiple XL spreadsheets of the same workbook within same workbook
VoldemarG - Sunday, December 2, 2018 6:32 PM