The way to add a calculated fields is like this

CREATE TABLE dbo.Table1 (

Col1 ...

, Col2 ...

, .....

, SearchCol AS ISNULL(Col50,...

Have you tried creating a non-clustered index on Col50.

This trigger should give you the desired results.

CREATE TRIGGER [dbo].[Update_ServiceNum]

ON [dbo].[Test]

AFTER INSERT

AS

BEGIN

WITH cteMaxServiceNum AS (

SELECT s.ProjectID, MaxServiceNum =...

This is a script that I use when I need to know how much space each table is using

SET NOCOUNT ON;

CREATE TABLE #temp (

...

You need to wrap your serial/servicedate in another set of brackets

WHERE (

(t1.Serial = '00000000001' AND t1.Servicedate BETWEEN...

Eirikur Eiriksson (11/3/2016)

---

DesNorton (11/3/2016)

---

Shredding xml is not exactly the best perfprming operation in SQL. Rather get the UI to shred the XML and pass you a TVP (table valued...

Shredding xml is not exactly the best perfprming operation in SQL. Rather get the UI to shred the XML and pass you a TVP (table valued parameter).

If you need...

shorton2 (11/1/2016)

---

Probably a better way but this seems to do what I want. Allows the users to feed me an "x" to explicitly clear a field, and if they...

Deleted: Solution would not work

shorton2 (11/1/2016)

---

Probably a better way but this seems to do what I want. Allows the users to feed me an "x" to explicitly clear a field, and if they...

I tend to steer clear of the MERGE statement.

Below is a sample of doing it as separate INSERT/UPDATE statements.

--DROP TABLE #UDFTemp;

CREATE TABLE #UDFTemp (

JobNumber INT...

Without sample data, we can only guess at the outcome.

Try this for your OT calculation

CASE WHEN ( [friday] = 1 and [day] = 'Friday' )

...

Since this is SQL 2012, you could also use TRY_PARSE

SELECT

TRY_PARSE('13.2' AS DECIMAL(18,2) USING 'en-US')

, TRY_PARSE('13,2' AS DECIMAL(18,2) USING 'de-DE')

Are you able to get the source data as quoted values

SELECT ID, txt, REPLACE(val, ',', '.') AS val

FROM (

VALUES (1, '1 Value', '18,2'),

...

Eirikur's solution groups by PaymentComfirmDate.

In order to group by Year/Month, you will need to use something like this, which groups by the 1st of every month.

-- ...

MonthYear = DATEADD(mm, DATEDIFF(mm,...