call.copse (11/1/2016)

---

It seems very easy to assume others will obviously understand x, y and z technology due to their experience and general intelligence. Sadly I often do this and feel...

Suth (10/28/2016)

---

Hi,

I'm currently trying delete data from a large database with the below code... But its taking quite a long time to delete 1000...

I had to change desks recently (first time in 6 years), besides the usual office supplies found these in my desk drawer:

plastic spoon and knife (no fork here)

SQL Server 2012...

you can do a JOIN in an UPDATE statement, and I think in this case you'd want to use a subquery to figure out the counts first:

UPDATE t2 SET

...

from the database side you can see if there's still a lock on the object:

SELECT s.host_name, s.login_name, s.status,

DB_NAME(l.resource_database_id) AS database_name,

OBJECT_SCHEMA_NAME(l.resource_associated_entity_id, l.resource_database_id)...

yes, that's the one thing I still miss from my Oracle days, was how easy TO_CHAR and TO_DATE worked for date datatype conversions

I agree that FORMAT is terrible for performance, but since the desired end result is INT for all these ID columns, why not just change them all to integer math...

Microsoft doesn't allow DB Mail for express edition:

https://msdn.microsoft.com/en-us/library/cc645993%28v=sql.120%29.aspx?f=255&MSPPError=-2147217396

The article you linked to was from 2013 so maybe that workaround was broken in 2014 version.

There are other alternatives possible though, like...

Miles Neale (10/12/2012)

---

Meetings can be good. However, they need to be short, to the point, make decisions, and not be rambling sessions where everyone gets their say three or...

It's probably best to start a new topic in the forums if the question is different. At this point I think we're into data cleansing (determining mismatched CHECK_IN and...

philand3 (10/26/2016)

---

Hello Chris, Thanks i did coding in ASP.NET itself.

By the way i am trying to bring query with the last clock_in where no clock_out for the same details...

it looks like your problem lies around here:

DECLARE @TEMP1 NVARCHAR(MAX) = 'SELECT colsUnpivot FROM #TEMP'

--PRINT @TEMP

SET @query

=...

scarr030 (10/25/2016)

---

...pulling (in short) any record that had a result_text > '7.9%'. The field 'result_text' is a varchar field. It was pulling anyone between 8.0 and 9.9, but excluding anyone...

would it make sense to calculate the overtime in a CASE statement eliminating the negatives before they get to your sum then? Something like:

CASE WHEN Hoursworked > Dutyhours THEN...

philand3 (10/25/2016)

---

Hello Chris,

Thanks for your feedback.

With your query i am trying to bring two more column. One from database which is dutyhours and another one is OT which computed from...