How to DELETE huge record around (2 Lakhs) from a table very fast.
Feb 23, 2014 · The idea behind batching updates and deletes is to increase concurrency by having SQL Server take a limited number of locks for a short period of time and allowing SQL Server to release …
How to show show MM/DD/YYYY 12:00:00 AM
Jun 30, 2009 · For SQL query input parameters a string with the required date/time will work. If an input parameter in a SQL query is a DateTime, it seems automtically convert strings correctly. If an actual …
How to retreive next sunday date from present date.
Oct 14, 2010 · I have created report in which i have to show date in one column and in other immediate sunday date from that date.tell me how to do the same in SSAS reports.
Dynamic Date Parameter in Report Manager
Apr 1, 2009 · I was wondering if there's a way to override the default date parameter of a report to a dynamic value such as Today (), Now (), DateAdd (),... through Report Manager.
Some Dataset fields not available in the Report Designer
Jul 28, 2012 · Within the Report Designer however, the Day2-Day7 columns are not showing as selectable as a formula for a tablix cell. Why on earth are these fields not showing up? Edited …
Function for date sequence - social.msdn.microsoft.com
Dec 31, 2018 · Fantastic, Thanks for quick response .Iam still stuck with older version of sql server 2008.
Spliting Date into week1, week2, week3.......for every month.
Nov 22, 2011 · First of all, the definition of "week" is a non-trivial matter. Does your week start on Mondays or Sundays? If Oct 1 is on a Saturday, what is week 1? Here is a fairly simple-minded …
Unable to execute insert statement by SQL Server Agent - SQL Server …
Jun 26, 2012 · I feel a bit confuse in the SQL Server Agent of SQL Server 2008 R2, please give a hand or comment.
How do you determine DATA age in sql server 2005
Jun 3, 2010 · 1) I want to find out how old of sql data age. We supposed to keep ony 3 years data on sql server 2005 (upgraded from sql2000). I am not sure what sql command to check this, Please advise …
Running Totals with Balance - social.msdn.microsoft.com
Feb 12, 2016 · Since you are using SQL Server 2012, you could use script below to get the output.