difference between Numeric and Money Data type in SQL Server
May 14, 2013 · On further evaluation, I found it was because of the Money datatype. So I prepared the simple t-sql below to know the difference with different castings and applied the multiplication & …
poor performance in using UNPIVOT - social.msdn.microsoft.com
Mar 20, 2017 · Question 0 Sign in to vote Hi friend, Small suggestion if you can able to help me
Time based filtering using sql - social.msdn.microsoft.com
Sep 17, 2013 · 1)select the data between 1-1-2013 and 1-10-2013 with time rage between 10 to 16 2)select the data between 1-1-2013 and 1-10-2013 with time range between 20 to 8 next morning
Change CURRENT_TIMESTAMP TO PREVIOUS DAY
Feb 17, 2016 · If it's for the full previous day, you could use something like where gl.ReceiptDate between dateadd (d,-1, cast (getdate () as date)) and cast (getdate () as date) ; aka greater than time …
Creating PDF file using Stored procedure
Jun 16, 2010 · We are programming some Forms application in Blackberry phones and the phones transer the filled data to SQL server (via some services) and we pull out these data from the SQL …
Should I use the this. keyword? - social.msdn.microsoft.com
Oct 24, 2015 · To have an object return itself from a method To declare indexers To declare extension methods To pass parameters between constructors To internally reassign value type (struct) value. …
Use Between in nvarchar field - social.msdn.microsoft.com
Jan 31, 2012 · I am using the select statement below to retrieve some records from a table. The field is nvarchar, which contains a date as MMDDYYYY (don't know why db designer used nvarchar) . What …
How to a append to a column in a SQL query
Dec 12, 2011 · SELECT * FROM [Profile DB]. [dbo]. [UserProfile_Full] WHERE LastUpdate BETWEEN CAST (StartDate AS DATE) AND CAST (EndDate AS DATE) ORDER BY UserID There is no need …
Find Open Slots in Schedule Excluding Non-Work Days
Jan 30, 2019 · WHILE @StartDt < @EndDt BEGIN INSERT INTO dbo.WorkDays (WdDate, WdIsWorkDay) VALUES (@StartDt, CASE WHEN DATEPART (DW, @StartDt) BETWEEN 2 AND 6 …
deprecated_string_conv_gen: conversion from a string literal to pointer ...
Sep 5, 2019 · Remember, there is a difference between being able to do something and it being a good idea to do something. If you cast away the const, you are removing the thing which says to the …