Eric M Russell (8/24/2015)

---

maxlezious (8/24/2015)

---

Eric M Russell (8/24/2015)

---

maxlezious (8/24/2015)

---

Thanks for your reply!

I currently have a job setup which runs the stored procedure every week and inserts the usage figures in...

Thank you, will change to 'date' datatype as wont be needing time.

Eric M Russell (8/24/2015)

---

maxlezious (8/24/2015)

---

Thanks for your reply!

I currently have a job setup which runs the stored procedure every week and inserts the usage figures in a table. All i...

Thanks for your reply!

I currently have a job setup which runs the stored procedure every week and inserts the usage figures in a table. All i am looking for is...

I have the Microsoft SQL Server 2014 Query Tuning & Optimization and I will lookup on the other books you mentioned - thank you

I have been a silent reader of...

Really hope I become as good as you soon. Would you recommend me any t-sql books or just practicing on daily basis?

Absolute star, i am your fan now. Thank you again 🙂

Chris, I am sorry to bother you again. I am trying to fiddle with the query you gave me to sum up the ajars and motions in same row

For example:

In...

Thank you so much for the updated query Chris. That's is exactly what I was after, really appreciate your time and help with the query.

ChrisM@Work (8/18/2015)

---

Here's a halfway point:

SELECT

a.*,

x.[hours],

Points = COUNT(*) OVER(PARTITION BY a.ActType, x.[hours]) * x.points

FROM #tblActivities a

CROSS APPLY (

SELECT

[hours] = CASE

WHEN a.ActType = 'Motion' THEN DATEPART(HOUR, a.isoTimeStamp)...

Hi, Thank you for your reply. I am expecting the...

Thats exactly what i needed. Thank you so much! 🙂

Thank you for your great advice Lynn, I will create a new stored procedure like you adviced.

Is this correct way to do it

DECLARE @clientname VARCHAR (60)

SELECT DISTINCT @clientname = ClientName

FROM tblClient

WHERE ClientNumber

IN

(SELECT ClientNumber FROM tblSystem WHERE SystemNum = @systemID)

SELECT CASE

...

Thanks for your reply Lynn.

We have this working php code and i am trying to convert this into sql

$db_name = "DB_admin1" ;

$conn = mssql_select_db($db_name) or die('Connection to the Database failed!

')...