Start time will help you determine when it was sent from the vendor app. What you want to do is look at duration to determine if it's your box...

donbuz (1/23/2013)

---

Thank you for this input Craig.

Security matters are definitely a great concern when dealing with user inputs and dynamic SQL.

I doubt the ratio cost/benefice of such an implementation in...

I see you didn't bother to read the link. The data is non-consumable in a test format...

DBA Dom above gave you the basics of the solution. If you want working code, you'll have to give...

... My server just crashed and the business is failing... that's immediate help please type needs. This? Not so much.

As a fast fix, stop using DTS/SSIS for backups...

:doze: CAPS LOCK is not your friend. Periods are.

jackwala (1/23/2013)

---

WHEN SO MANY USERS HIT A TABLE CONCURRENTLY IN MSSQL 2008 R2 ERRORS OCCURED TIME OUT EXPIRED OR ELASPED TIME...

Hey Hector, welcome to the forums.

If you can format your data like you'd see in the first link in my signature, you'll find a number of folks here would be...

Donbuz,

What you'll end up with here is nearly pure dynamic SQL. True search engine mechanics will have to have an interpreter turn 'english' style engine mechanics into a usable...

kenneth.bucci (1/18/2013)

---

Yes that is what I am saying @Issues is a SQL Paramerter with multiple delimited values separated with a comma. SPL.IssCode contains a different set of multiple delimited values...

The APPLICATIONS table relates to the APPL_STATUSES table by the APPLICATIONS_ID. Whenever a status of an application changes a record is written in APPL_STATUSES along with the status and...

*facepalm* sorry about the earlier code. Try this again:

Alternatively:

SELECT

*,

CASE WHEN column2 <> 'AP' THEN 1 ELSE 0 END AS APtest,

CASE WHEN column3 <> 'U' THEN 1 ELSE 0 END...

EDIT: Scratch this, bad code. Sorry about that.

Was ill for a week, miss anything of import?

kaplan71 (1/11/2013)

---

I am hoping to set up a maintenance plan that will check the integrity of one of our databases. The data within the database is static, and does not...

jasona.work (1/11/2013)

---

Evil Kraig F (1/11/2013)

---

Same here. Heck, I've got one that's completely written in...