• Stephen W. Thomas
  • Azure Integration Gurus
BizTalkGurus
  • Home
  • Blogs
    • Stephen’s BizTalk and Integration Blog
    • BizTalk Community Blogs via Syndication
  • Forums
  • Downloads
  • Videos
  • Training
    • Online Training
    • Classroom Training
Select Page

Get all rows for today in SQL

by community-syndication | Mar 20, 2009 | BizTalk Community Blogs via Syndication

I wanted to get all of the rows that were time stamped today from a table that has a datetime column.

Here is the query that I used:

SELECT COUNT(*) AS [Today's File Count] FROM dbo.Envelope WHERE (CONVERT(varchar, entry, 101) = CONVERT(varchar, GETDATE(), 101))

  • Facebook
  • Twitter
  • Google+
  • Gmail
  • LinkedIn

Search this Site:


Recent Posts

  • Logic App Consumption deployment: The secret of KeyVault parameter cannot be retrieved. Http status code: ‘Forbidden’. Error message: ‘Access denied to first party service
  • BizTalk Server Visual Studio project: attempted re-targeting of the project has been canceled.
  • BizTalk Oracle Adapter error: The assembly required for type mapping not found.
  • PowerShell script to identify all SQL V1 actions and triggers inside Logic Apps Consumption
  • Friday (funny) Fact: There is no size limit for the Logic App parameter name

Tweets by AzureIntGurus

Recent Topics

  • Evaluating on the amount of items returned in a message
  • Send and Receive ports problem
  • How to config/costom a WS Security to SOAP header
  • Email attachments – POP3 adapter
  • Calling ASP page from Biztalk Orchestration

  • Home
  • Blogs
  • Forums
  • Downloads
  • Videos
  • Training
  • Facebook
  • X
  • RSS
@BizTalkgurus.com