Jason Leiser

Lead SQL Developer, Hack Golfer

[Jason Leiser @jasonleiser]

@Pittfurg Same thing happened to my dog about 6 months ago, diagnosed with SARDs, he was really depressed and scared for a while because it was so sudden, he still manages ok as he's learned the layout of the house more or less...still hate it for him though, he just turned 8

[CC Sabathia @CC_Sabathia]

…I still can’t get a follow though cuz 🤔🤣

[Jason Leiser @jasonleiser]

I counted [56] #MTNDEWMAJORMELON bottles in the @MountainDew ad. And for a million dollars, you should, too. How’d I do, Dew? #MyPromotionEntry Rules: https://t.co/mDfXlrUYlM

[Jason Leiser @jasonleiser]

@bertwagner Cast 1/31/1900 and u get 30...days since 1-1/1900 , I should check before I hit send from phone

[Jason Leiser @jasonleiser]

@bertwagner It doesnt work for datetime2 datatype so I can’t use the shorthand

[Jason Leiser @jasonleiser]

@bertwagner I think it’s because the default for date time datatype is 1-1-1900; I believe to do the math,sql converts it to an INT, if u cast(getdate() as int), and cast(cast(‘1/1/1900’ as datetime) as int) you’ll get 30

[Jason Leiser @jasonleiser]

System versioned tables, can you change a column value on DELETE?I want to know who deleted a record from an App but I don't want to have to do an UPDATE and then DELETE which will write 2 records instead of 1 to history.I don't think it's possible but wanted to check.#sqlhelp

[Jason Leiser @jasonleiser]

@SQLSoldier @AdamMachanic As someone who has recently started using System Versioned tables and will need to convert data back to EST for users, this is discouraging. Great Post!

[Jason Leiser @jasonleiser]

Can you get the current SQL file name using T-SQL? Example, I'm in script1.sql, as shown in SSMS, and I would like to retrieve "script1.sql" and log it into a table. DBAs run scripts manually and I'd like to add step to release scripts for logging. #sqlhelp

[Jason Leiser @jasonleiser]

@AdamMachanic It didn't do constant scan as u stated; I was able to get it to work based on your idea earlier. Thanks #sqlhelp

[Jason Leiser @jasonleiser]

@AdamMachanic Sometimes value I don't want is NULL or something else and I tried x=value I want,that didn't seem to work;does give alt. For me to try

[Jason Leiser @jasonleiser]

@AdamMachanic I added a extra parameter and where clause to the function so when it opens it up and i don't want it to,it just does a constant scan.thanks

[Jason Leiser @jasonleiser]

@SQLSoldier inline table value function...yeah, i probably need more characters, I'll link back if I post to forum. thanks,

[Jason Leiser @jasonleiser]

is there a way to call this similar to RETURNS NULL is used for Scalar,don't optimizer consider them when NULL is passed? 2/2 #sqlhlp

[Jason Leiser @jasonleiser]

I have a query that calls 20+ ITVF using OUTER APPLY in 1 query, most of the time, less than 5 functions will be executed 1/2 #sqlhelp

[Jason Leiser @jasonleiser]

My idea it to store the code in a table to exec dyn based on a date range but I don't love this idea.Thoughts?Thanks;3of3 #sqlhelp

[Jason Leiser @jasonleiser]

based on a previous version. So if you run process today or in 2 years, you would exec the code as it looked 2 years ago; 2of3 #sqlhelp

[Jason Leiser @jasonleiser]

Want to be able to run a proc based on a dated version of bus. logic that will change and will need to be able to get results; 1of3 #sqlhelp

[Jason Leiser @jasonleiser]

Can I change the default value of ROW END for temporal tables to not be year 9999;breaks with functions such as dateadd prefer 2999 #sqlhelp

[Jason Leiser @jasonleiser]

@martinhallgolf penalized for misplacing the ball an inch,what about when player moves marker for other player,hard to belive marker & ball put back exactly