Tweet Archive for May 2017

“You cannot receive against unauthorised purchase orders.”: azrcrv.co.uk/olUEwy #MSDYNGP #MSDYNERP #MSDYNCOMM

6:57pm May 31 2017 —

Find Column In SQL Using INFORMATION_SCHEMA: azrcrv.co.uk/v9US5F #SQLServer #MSSQL

12:22pm May 30 2017 —

Notepad++ Change Log Always Open: azrcrv.co.uk/LMpcKS #MSDYNGP #MSDYNERP #MSDYNCOMM

7:26pm May 29 2017 —

@premierinn that’s a change from the last few years where the allowance could be used for meal deal. Done it all over the country for years.

in reply to premierinn — 5:54pm May 24 2017 —

@premierinn No longer simple. Can’t use allowance (inc alcohol) to get the meal deal?

5:24pm May 24 2017 —

Deploy SQL View to All Databases: azrcrv.co.uk/Ok7yd #MSDYNGP #MSDYNERP #MSDYNCOMM

6:44pm May 22 2017 —

For #WorldWhiskyDay, I’ve been drinking the @12distilleries #Talisker 10 Year Old.

10:18pm May 20 2017 —

@glenmoraygcoull #Serendipity. I’d forgotten that @GlenMorayDist, @ardbeg_com and @TheGlenmorangie had been the same company.

in reply to glenmoraygcoull — 10:15pm May 20 2017 —

@TullamoreDEWUK Thanks. Methinks I must get a distillery tour of Ireland planned.

in reply to TullamoreDEWUK — 8:09pm May 19 2017 —

@steveendow I love the Format command for date formatting, but have so many clients on SQL 2008 I can’t often use it.

in reply to steveendow — 6:17pm May 19 2017 —

@TullamoreDEWUK What’s the colour code?

in reply to TullamoreDEWUK — 6:15pm May 19 2017 —

SQL View to Return Budgets By Month: azrcrv.co.uk/NZdqR4 #MSDYNGP #MSDYNERP #MSDYNCOMM

6:11pm May 19 2017 —

Stored Procedure To Get Next Purchase Receipt Number: azrcrv.co.uk/t4GV6r #MSDYNGP #MSDYNERP #MSDYNCOMM

5:22pm May 18 2017 —

@GP_Beat @steveendow I always forget about the PSTL one.

in reply to GP_Beat — 10:17pm May 17 2017 —

@steveendow lol, sounds good to me. I could probably include #Islay and #Orkney in that one.

in reply to steveendow — 10:17pm May 17 2017 —

Always

10:03pm May 17 2017 —

@steveendow Try running it for a client with 100,000+ Items :/

in reply to steveendow — 10:02pm May 17 2017 —

Seems @steveendow really did like my multi-db query: Very impressive SQL script for running multi-compa… dynamicsgpland.blogspot.com/2017/05/very-i… #MSDYNGP

10:02pm May 17 2017 —

@TimWappat @steveendow Helps with lots of things 🙂

in reply to TimWappat — 6:07pm May 17 2017 —

Microsoft Dynamics GP 2016 R2 Financial Dashboard Error: azrcrv.co.uk/8WVp2V #MSDYNGP #MSDYNERP #MSDYNCOMM

11:24am May 17 2017 —