Category: TSQL

Avoid Over layering in Development of Workflows on Existing Form Extension version – Dynamics 365 for finance and operations

Hi all,  My fellow Sohail Shaikh wrote an excellent blog Post, I used it in my customization to avoid overlay methods in some of out of the box table. http://d365technext.blogspot.com/2018/07/avoid-over-layering-in-development-of.html     That article...

float value conversion in string SSRS expression and decimal points SSRS dynamics ax 2012 R3.

float value conversion in string SSRS expression and decimal points SSRS dynamics ax 2012 R3.

    Today I have to record very small tip. During development of on SSRS report for Dynamics Ax 2012 R3, End user wants a row at the report footer for  analysis. he wants...

describe table tsql

describe table tsql

Currently I was searching describe  like function, which used in Oracle PLSQL to get the detail of table.  I found equvilent function in TSQL “sp_help”. you can used it as sp_help <table_name>   i.e...

Delete with identity reset

Delete with identity reset

I am dropping the rows but insertion start with next to last max identity . Something was missing in my knowledge. To reset Identity i have use one extra statement, other option is use...

How to convert date to interger In TSQL

How to convert date to interger In TSQL

During my assignment I have to generate Integer value from datetime filed for Date Dimension . I found excellent  id this way.     CAST(CONVERT(varchar(8),StartDATE,112) AS int) DateDateKey,   The whole Query is  as follow.  ...

How to get Tables list in database TSQL

How to get Tables list in database TSQL

  Main object is sys.tables. you can get all information about tables by query on sys.tables.   User databasename Select * from sys.tables;.     SELECT SCHEMA_NAME(schema_id) AS table_schema_name, name AS table_Name FROM  sys.tables;...