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 perm
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.Refl
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