Viewing 15 posts - 811 through 825 (of 8,731 total)
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
Jeff Moden - Tuesday, November 21, 2017 9:10 PMHmmm... I haven't tried it but perhaps a BIGINT Sequence would work here.
This might...
November 22, 2017 at 7:41 am
Viewing 15 posts - 811 through 825 (of 8,731 total)