|
Canada-0-COSMETICS Azienda Directories
|
Azienda News:
- MSDN
MSDN
- MSDN
MSDN
- MSDN
MSDN
- MSDN
MSDN
- Object moved - social. msdn. microsoft. com
Object moved Object moved to here
- Calculate Elapsed Time Between Dates Excluding Weekends
You could use a calendar table Pull all dates between the start and end date, count whole days and multiply it by (24 * 60), and add the difference in min for the start date related to 00:00 next day, and add the difference in minute for the end date related to 00:00 same date declare @x int; declare @sd datetime, @ed datetime;
- Change Domain Name - social. msdn. microsoft. com
this technet article by Keith is really detailed and informative, this does not show how to change domain name but is a good start
- MDX nonempty and not 0 - social. msdn. microsoft. com
How do I find only the rows in MDX (for a Power BI import, if that makes a difference) where I have multiple columns and I need to remove those which are "useless", where "useless" is defined as BOTH of the columns being either null or 0?
- Possible to automatically disable user account after period of inactivity?
I have a security requirement to disable a user account after a specific period of inactivity (e g if user does not login for 45 days, disable the account)
- Calculation using data from SQL Database
I need to retrieve data from one table, cross reference it to other table, assign values to variables and use them in calculation
|
|