Viewing 15 posts - 811 through 825 (of 8,731 total)
Just a different option, for the fun:
DECLARE @Sample TABLE(
patients_ID int,
treatment_ID int
);
INSERT INTO @Sample
VALUES
(1, 111),
(1, 222),
(1, 333),
November 30, 2017 at 2:12 pm
SELECT SCHEMA_NAME(so.schema_id) AS schema_name
,OBJECT_NAME(p.object_id) AS object_name
,p.partition_number
...
November 30, 2017 at 12:36 pm
Something like this, will insert all Saturdays for 2018, but I´m sure you have something else in the table.
CREATE TABLE #Calendar(cal_id int IDENTITY, cal_date date);
November 30, 2017 at 10:23 am
November 30, 2017 at 9:43 am
CustomData =...
November 30, 2017 at 9:32 am
November 30, 2017 at 9:23 am
I am trying to add sequential dates to a table in 2008. By sequential...
November 30, 2017 at 9:19 am
I believe the wording on the correct answer is misleading. In my opinion, it should say: "The value of level0type is invalid".
Maybe it's just me.
November 30, 2017 at 7:27 am
November 30, 2017 at 6:38 am
This seems like homework and MySQL.
Is any of those assumptions correct?
November 28, 2017 at 12:19 pm
Would these formulas give the correct results?
DECLARE @test-2 TABLE (
[Date] DATE,
[Weeknumber] AS DATEPART(wk, DATEADD(wk, -1, [Date])),
[DayName] AS DATENAME( DW, [Date]),
November 28, 2017 at 10:18 am
we have a table valued function fn_ProductType which accepts a ProductID and Order Date as...
November 28, 2017 at 9:45 am
November 22, 2017 at 9:02 am
Did you try it by naming the columns in the SELECT list instead...
November 22, 2017 at 8:47 am
Viewing 15 posts - 811 through 825 (of 8,731 total)