get only date from Current Date in SQL

-
Hi,

CONVERT(DATE,GETDATE())

cheers,
P.S:Please do not hesitate to share your comments.

Comments

Post a comment

Popular posts from this blog

Assembly Microsoft.Dynamics.Service.Plugins.dll can not be loaded. Dynamics CRM 365 Engine version 9 - CRM User creation error

-
Image
Hello,

If You face an error while adding new user to the Dynamics CRM 365 onpremise for Version 9.0 stating that
"
Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=9.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: Assembly Microsoft.Dynamics.Service.Plugins.dll can not be loaded.
....
....
....

   <d2p1:value xmlns:d4p1="http://www.w3.org/2001/XMLSchema" i:type="d4p1:string">Microsoft.Crm.CrmException: Assembly Microsoft.Dynamics.Service.Plugins.dll can not be loaded. ---&gt; Microsoft.Crm.CrmException: Assembly Microsoft.Dynamics.Service.Plugins.dll can not be loaded. ---&gt; System.IO.FileLoadException: Could not load file or assembly 'file:///C:\Program Files\Microsoft Dynamics CRM\server\bin\assembly\Microsoft.Dynamics.Service.Plugins.dll' or one of its dependencies. Access is denied.
....
....
....
"

It is about missing permission of asse…
Read more

Exception caught instantiating TERADATA report server extension SQL Reporting Services

-
Hi,

If you face an error in Reporting Services Log File (C:\Program Files\Microsoft SQL Server\MSRSxx_xx.MSSQLSERVER\Reporting Services\LogFiles) such as :



extensionfactory!ReportServer_0-1!ea4!03/26/2013-08:20:15:: e ERROR: Exception caught instantiating TERADATA report server extension: 
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. 
---> System.IO.FileNotFoundException: Could not load file or assembly 'Teradata.Client.Provider, Version=12.0.0.0, Culture=neutral, PublicKeyToken=76b417ee2e04956c' or one of its dependencies. The system cannot find the file specified.
File name: 'Teradata.Client.Provider, Version=12.0.0.0, Culture=neutral, PublicKeyToken=76b417ee2e04956c'
   at System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)
   at System.Reflection.Assembly.I…
Read more

Could not load file or assembly 'System.ServiceModel, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'. The system cannot find the file specified at Configuration class initiation in CrmServiceHelper.cv

-
Hello,

I faced an error when i iniated configuration class of CrmServiceHelper of Microsoft in order to setup Dynamics 365 Customer Engagement (Dynamics CRM online) SDK connection.

The mesage was
"
Could not load file or assembly 'System.ServiceModel, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'. The system cannot find the file specified.
"

Here is the fix:
Open NuGet Package Manageer froom Tools view in Visual Studio and make an online search for
System.ServiceModel.Primitives

finally install it to the project.


enjoy...
Muhammet Atalay


Read more