Lynn Pettis (9/6/2016)

---

Sean Grebey (9/6/2016)

---

Trying to use these function which everything I read says 2012 forward inn SSMS 2014 and both of them toss me errors that they are not...

Ah I see I am trying to use a local path and run it from the server...thanks

@@ROWCOUNT did it thanks for the help guys

Thanks

TheSQLGuru (3/11/2016)

---

UNION will get you multiple rows if the primary one hits and the alternate does also.

At first blush I can't think of a way to do this in a...

Union maybe?

Thanks for the help guys.

Lol I feel like it was an easy question but I'm also a programmer...

Thank you

CELKO (3/30/2015)

---

>> I have a list of paired row IDs in a Fake_Tape_1, e.g. <<

I hope not! Lists are not part of SQL or RDBMS. Rows are identified by a...

Here is the actual T-SQL I think this will work:

INSERT INTO [notes]

([projectID]

...

The SQL Browser Service was off that seems to have been the issue thank you!

Thanks guys!

Thanks for the replies. Out of curiosity, this is the approach I took. Is there an issue with it?

select ROUND(sum(ContractValue),2) ContractValue, MONTH(ContractDate), YEAR(ContractDate)

From Reporting.dbo.PrgSum

Group by YEAR(ContractDate), MONTH(ContractDate)

I was asking because from what I understand if there is a clustered index non-clustered indexes use the clustered key, otherwise it uses the rowID (file number, page number and...