DuncEduardo (5/11/2016)

---

Hi,

Simple little requirement.

Need to display first date of each of the 12 months prior to current date, i.e. "Last Twelve Months" for reporting purposes.

i.e. today is 10th May 2016...

Check this: https://connect.microsoft.com/SQLServer/feedback/details/737341/sql-server-2012-openrowset-on-msdb-dbo-sp-help-job-throws-error

It includes a workaround posted in here: https://blogs.msdn.microsoft.com/sqlagent/2012/07/12/workaround-sql-server-2012-openrowset-on-sp_help_job-throws-the-metadata-could-not-be-determined/

Lynn Pettis (5/10/2016)

---

Eirikur Eiriksson (5/10/2016)

---

Michael L John (5/10/2016)

---

Lynn Pettis (5/10/2016)

---

Red Letter Day! Silver Spoon posted a helpful response to a question. Of course, it could just be a...

Use COALESCE()

...

Set TestDate = COALESCE( @TestDate, @TestDate2, @TestDate3)

...

Did you read the article that Drew referenced?

Try this to get the rows causing errors.

SELECT

a.systemname AS HostName,

left(a.deviceid,1) AS DriveName,

a.drivesize,

a.freespace

FROM [dbo].[DriveStatus]...

Chocolate

You could use the DelimitedSplit shared in this article: http://www.sqlservercentral.com/articles/Tally+Table/72993/

DECLARE @IDList NVARCHAR (1000) = '1|2|3|4|5'

DECLARE @NameList NVARCHAR (1000) = 'AAA|BBB|CCC|DDD|EEE'

DECLARE @Delimiter VARCHAR (1) = '|'

DECLARE @Operation VARCHAR (10) = 'INSERT'...

Try this:

CREATE VIEW ViewName

AS

SELECT [student#]

,[class_position]

,case when [class_position] > 0 then CONVERT(int, [Class_Rank]) else CONVERT(int, [Class_Seq]) end as [List]

FROM School

Is the data type an integer?

Check the following article http://www.sqlservercentral.com/articles/T-SQL/63681/

Also, remember that you have other aggregate functions like MAX and not only what it's used in the article.

Something shorter, not sure if that means better. 😀

SELECT current_value=some_bigint,

next_place_value=POWER(10,CAST(LOG10(some_bigint) AS INT)+1),

next_place_value=POWER(10,LEN(some_bigint))

FROM #bigints;

You'll be missing any holidays. To prevent that, you'll need to create a calendar table or at least a holidays table.

There seems to be a SQL User Group in Toronto, but I'm not sure how active they are.

http://toronto.sqlpass.org/

Hunt