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

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

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)    a...
Read more

Installation of Microsoft Visual C++ Runtime failed. Exit code: 5100. Result: Asia in Microsoft Dynamics CRM 2011

-
If you face an error about Installation of one or more missing prerequisite components while installing Microsft Dynamics CRM 2011 server (i met some consultants who get same error while installing CRM for Outlook Client).it is related with version of Microsoft Visual C++ Redistributable package running on the server. Here is the story of me; I wanted to try install Microsoft Dynamics CRM 2011 into Microsoft Windows 2008 R2 x64 Enterprise server which has already Microsoft SQL Server 2012 Developer Edition. I got an error during installing prerequisite. I checked logs from "C:\Users\Administrator\AppData\Roaming\Microsoft\MSCRM\Logs\crm50svrsetup.log" and found; 11:18:45| Info| CmdLine: <"D:\Redist\VcRedist\vcredist_x64.exe" /q /norestart> 11:18:45| Info| WorkingDir: 11:18:53| Info| Installation of Microsoft Visual C++ Runtime failed. Exit code: 5100. Result: Asia 11:18:58| Error| Installation of one or more missing prerequisite c...
Read more