Viewing 15 posts - 16 through 30 (of 897 total)
May 15, 2017 at 1:24 am
You can make it simpler by declaring variables to hold the date valuesDECLARE @Date DATE
DECLARE @StartDate DATE
DECLARE @EndDate DATE
SET @Date = GETDATE()
May 8, 2017 at 12:20 am
Insert @T (data) values ('A')
Insert @T (data) values ('a')
Insert @T...
March 30, 2017 at 10:05 pm
This might help..
http://stackoverflow.com/questions/24209826/why-is-latin1-general-cs-as-not-case-sensitive
March 29, 2017 at 5:56 am
March 27, 2017 at 2:55 am
If the following assumptions are true, the code below should help
1. You have only 2 rows per ServerName, DBName combination
2. Rank1 = 1 always for the record...
March 23, 2017 at 3:25 am
ALTER
March 23, 2017 at 12:47 am
March 23, 2017 at 12:34 am
I think such requests should be handled in front-end
But, the below code should helpSELECT TOP 100 PERCENT
CASE WHEN...
March 17, 2017 at 4:24 am
Here is another solution using CROSS-TABS.
Thanks for the sample data Thom.
CREATE TABLE #Sample (ID VARCHAR(10),
[Name] VARCHAR(10),
[Value] VARCHAR(10));
GO
INSERT INTO...
February 22, 2017 at 2:53 am
Viewing 15 posts - 16 through 30 (of 897 total)