Forum Replies Created
Viewing 15 posts - 406 through 420 (of 506 total)
-
RE: Missing months group by
WITH calendarMonths(FirstOfMonth)
AS
(SELECT DateAdd(mm, number, '20170101') FROM master.dbo.spt_values sv WHERE type='P')
SELECT
calendarMonths.FirstOfMonth
FROM calendarMonths;
-
RE: Import wizard: change InputColumnWidth ?
You are correct. Try opening the package in SSDT. There are more options there.
-
RE: Import wizard: change InputColumnWidth ?
Column widths and data types can be changed by clicking the Edit Mapping button
-
RE: SQL: HOW to concatenate two fields using trigger,
Use a computed column instead.
CREATE TABLE dbo.S1 (WORKERORDERID varchar(10), SOURCEWOID varchar(10));
INSERT dbo.S1
(WORKERORDERID, SOURCEWOID)
VALUES
( '10', '1' )
, ( '11', '2' )
, ( '12', '1' );
SELECT
... -
RE: date format needed: 06/15/2017 12:00:00 AM
SELECT Cast(MyDatetime, as date) FROM MyTable; -
RE: Show result values based on paramter value
WHERE Percentage=@percentage or WeekPercentage=@percnetage
-
RE: Another Heap Question for Rotating Data
Choosing what to cluster on is not trivial. You must determine which column would be the best candidate based on what you search on and join on. -
RE: Rolling 6 Months
Please post DDL, inserts, expected result and what you've tried so far.
Thanks. -
RE: calculate percentile
Is this what you need?
CREATE TABLE #Percentagecalculation
(
Currentdate numeric(18, 10)
,PriorDate numeric(18, 10)
,[7DayAvg] int
,[14dayavg] int
,[Date-2] numeric(18, 10)
);
INSERT INTO #Percentagecalculation
VALUES
(607, 480, 524,... -
RE: Question regarding date logic
Try something like:
DECLARE @PatientEvaluation table
(
[Evaluation_Id] [numeric](20, 0) NULL,
[EvaluationDate] [nvarchar](3000) NULL,
[EvaluationType] [tinyint] NULL,
[Evaluation_RN_Date] [nvarchar](3000) NULL
) ;
INSERT INTO... -
RE: calculate percentile
Please post DDL and inserts, what you've tried so far and expected result (requirements). Also check BOL first.
-
RE: CASE statement in WHERE clause
Please post DDL and inserts.
-
RE: Get total count before getting a subset from numbered results
Try:
;
WITH LotsOfData
AS (
SELECT
Checksum(NewId()) RandomID
, Row_Number() OVER (ORDER BY Checksum(NewId())) RowNum
, Count(*) OVER (PARTITION BY ( SELECT NULL )) Countx
FROM
( VALUES (... -
RE: Unable to get proper counts using sql query
SELECT
A.Custom2 as State,
BCNT = SUM(case when A.Defecttype = 'BUG' and A.ProjectName = 'Billing' ' and A.Status <> 'Closed' then 1 else 0...
Viewing 15 posts - 406 through 420 (of 506 total)