Found this sample in my collection, probably posted it somewhere before, feel free to play around with it.

😎

USE TEEST;

GO

SET NOCOUNT ON;

/* DDL Audit table

--TRUNCATE TABLE dbo.TBL_TEST_DDL_AUDIT

*/

IF OBJECT_ID(N'dbo.TBL_TEST_DDL_AUDIT') IS NULL

BEGIN

CREATE...

Use DBCC PAGE to get the object I'd, then it is easy to find the table

😎

Eirikur Eiriksson (3/15/2016)

---

hoseam (3/15/2016)

---

I have this query

DECLARE @TheDate DATE

IF @TheDate IS NULL

SET @TheDate = GETDATE()

SET @FileName = 'DailyAgentSales' + CONVERT(CHAR(8) ,@TheDate -1 ,112) + '.csv'

SET @Subject = 'Agent Sales -...

hoseam (3/15/2016)

---

I have this query

DECLARE @TheDate DATE

IF @TheDate IS NULL

SET @TheDate = GETDATE()

SET @FileName = 'DailyAgentSales' + CONVERT(CHAR(8) ,@TheDate -1 ,112) + '.csv'

SET @Subject = 'Agent Sales - ' +...

Brandie Tarvin (3/14/2016)

---

😛

Still not sure if I like Data Tools...

I think you are missing the Calculated Table. If you go to the Data View, Modeling, New Table and enter

DIM_DATE = CALENDAR(DATE(2016,1,1),DATE(2016,12,31)) it will produce a date table for the...

Are you using it as a measure/calculate table?

😎

This should work, I have models using this so I wonder why it doesn't work in your case, your version certainly supports it.

😎

BTW: I normally use a similar function as...

Ed Wagner (3/12/2016)

---

Eirikur Eiriksson (3/11/2016)

---

Very quick on Azure, only caveat...

Baggages?

😎

Can you please post the DDL (create script for the tables), sample data as insert script and the expected results?

😎

Very quick on Azure, only caveat is that it simply...

TomThomson (3/10/2016)

---

Quite interesting. Some of it extremely expressive. Certainly backs up what Gartner recently said...

SQL!$@w$0ME (3/9/2016)

---

When I have an insert and update trigger on the same table, the Insert trigger is triggering the Update trigger to execute since I use UPDATE statement in the...

Trigger

😎