ThomasRushton (5/13/2016)

---

Sean Lange (5/13/2016)

---

I imagine this thread was started here because the majority of the spam seems to be in this...

Hmm, maybe they could utilize the point system for this.

Add up the point total of everyone who reports a posting. If the point total is greater than some threshold,...

Eric M Russell (5/12/2016)

---

There are certain keywords like "testosterone", "distressed furniture", and "butt cream" that seem to be a recurring theme for the spammers, but are highly unlikely to naturally...

The old-school way of doing this would involve nested queries and joining back to your table multiple times.

Windowed functions make this so much easier:

SELECT

[ID] = Coalesce(X.[Tech],'')+ Coalesce('-'+convert(nvarchar(30),max(X.[DOS]),120),''),

X.[Tech],

[DOS] =...

I might be missing something, but couldn't this be done in a single query like so?

SELECT

*

FROM

#Employee Employee

FULL OUTER JOIN

#Class Class

ON

IsNull(Employee.[Emp_no.], '') = IsNull(Class.[Emp_no.], '')

ANDIsNull(Employee.Org_Code, '') = IsNull(Class.Org_Code, '')...

Yea, very strange. I'm curious as to why it's an issue suddenly now?

Automatic suppression of posts reported as spam by a certain threshold number of users might help mitigate...

Reported as spam.

Or, if you don't like the PIVOT clause, you could do something like this:

SELECT

Product,

Max(CASE Metric WHEN 'BHP' THEN MetricValue ELSE Null END) AS BHP,

Max(CASE Metric WHEN 'Torque' THEN...

The file system task does not support using wildcards, as it is designed to work with a specific file.

To work around this, you would typically use a ForEach loop. ...

I also have a daily job failure summary, that lists all job failures in the last 24 hours. This helps catch any jobs that failed without properly configured notification...

I created a secondary mail profile connected to a GMail account, and used that profile to send an email notification about any email errors that have occurred.

If you absolutely must have users dynamically adding 'fields' in a UI form, perhaps you would consider storing them in an attribute table rather than dynamically changing your table's structure?

Instead...

Apparently I didn't. :Whistling:

Wow Microsoft. Really?

If for some reason the data provider cannot add a sequence number to the data, you can use a Scrpt Component configured as a (synchronous) transform in your data flow...

I fully agree with others that this is a bad thing, and should not be done. Killing off a process can be dangerous and lead to headaches. If...