Click here to Skip to main content
14,364,150 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.
 
GeneralRe: Deployment Hell Pin
PIEBALDconsult14-Aug-19 5:30
protectorPIEBALDconsult14-Aug-19 5:30 
GeneralRe: Deployment Hell Pin
MadMyche14-Aug-19 2:55
mveMadMyche14-Aug-19 2:55 
GeneralRe: Deployment Hell Pin
W Balboos14-Aug-19 3:13
mveW Balboos14-Aug-19 3:13 
GeneralRe: Deployment Hell Pin
#realJSOP14-Aug-19 4:45
mve#realJSOP14-Aug-19 4:45 
GeneralRe: Deployment Hell Pin
W Balboos14-Aug-19 4:50
mveW Balboos14-Aug-19 4:50 
GeneralRe: Deployment Hell Pin
Sander Rossel14-Aug-19 3:29
professionalSander Rossel14-Aug-19 3:29 
GeneralRe: Deployment Hell Pin
kmoorevs14-Aug-19 7:20
memberkmoorevs14-Aug-19 7:20 
GeneralRe: Deployment Hell Pin
kmoorevs14-Aug-19 6:55
memberkmoorevs14-Aug-19 6:55 
Just for fun! Laugh | :laugh: ('cause I know you're a sql guru)

create function [dbo].[datefromparts]
(
	@year int, @month int, @day int
)
returns date
as
begin
	declare @rtnDate date;

	set @rtnDate = convert(date, ltrim(str(@year)) + '-' + case when @month < 10 then '0' + ltrim(str(@month)) else ltrim(str(@month)) end + '-' + case when @day < 10 then '0' + ltrim(str(@day)) else ltrim(str(@day)) end)

	return @rtnDate

end

Strangely, the datefromparts built-in function comes up in the intellisense in SSMS 2008R2 but then of course fails. Hmmm | :|

Of course, I would never recommend using a scalar function like this anyway, but hey, I learned a new function today...doubt if I'll ever use it. Smile | :)
"Go forth into the source" - Neal Morse

GeneralRe: Deployment Hell Pin
#realJSOP14-Aug-19 7:35
mve#realJSOP14-Aug-19 7:35 
GeneralWSO CCC OTD 2019-08-14 Pin
OriginalGriff13-Aug-19 22:39
protectorOriginalGriff13-Aug-19 22:39 
PraiseRe: WSO CCC OTD 2019-08-14 Pin
PeejayAdams13-Aug-19 23:01
memberPeejayAdams13-Aug-19 23:01 
GeneralRe: WSO CCC OTD 2019-08-14 Pin
OriginalGriff13-Aug-19 23:06
protectorOriginalGriff13-Aug-19 23:06 
GeneralRe: WSO CCC OTD 2019-08-14 Pin
jsc4214-Aug-19 0:46
professionaljsc4214-Aug-19 0:46 
GeneralRe: WSO CCC OTD 2019-08-14 Pin
OriginalGriff14-Aug-19 0:49
protectorOriginalGriff14-Aug-19 0:49 
GeneralRe: WSO CCC OTD 2019-08-14 Pin
jsc4214-Aug-19 3:03
professionaljsc4214-Aug-19 3:03 
GeneralRe: WSO CCC OTD 2019-08-14 Pin
Michael Martin14-Aug-19 2:43
professionalMichael Martin14-Aug-19 2:43 
GeneralRe: WSO CCC OTD 2019-08-14 Pin
OriginalGriff14-Aug-19 2:50
protectorOriginalGriff14-Aug-19 2:50 
GeneralRe: WSO CCC OTD 2019-08-14 Pin
DRHuff14-Aug-19 7:51
memberDRHuff14-Aug-19 7:51 
General20 bits of entangled kitty Pin
BillWoodruff13-Aug-19 22:17
mveBillWoodruff13-Aug-19 22:17 
GeneralRe: 20 bits of entangled kitty Pin
Member 798912213-Aug-19 22:29
memberMember 798912213-Aug-19 22:29 
GeneralRe: 20 bits of entangled kitty Pin
CodeWraith13-Aug-19 23:48
memberCodeWraith13-Aug-19 23:48 
GeneralRe: 20 bits of entangled kitty Pin
MadMyche14-Aug-19 4:42
mveMadMyche14-Aug-19 4:42 
GeneralRe: 20 bits of entangled kitty Pin
David O'Neil14-Aug-19 8:21
professionalDavid O'Neil14-Aug-19 8:21 
GeneralRe: 20 bits of entangled kitty Pin
q1213q14-Aug-19 9:23
memberq1213q14-Aug-19 9:23 
GeneralRe: 20 bits of entangled kitty Pin
Member 798912215-Aug-19 1:04
memberMember 798912215-Aug-19 1:04 

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.