opc.three (4/27/2011)

---

FreeBCP leverages FreeTDS which is one of the few drivers out there that supports communicating with SQL Server from *x systems...use of it does not imply SQL Server is...

Why do you open yet another thread?

Aren't two enough? (http://www.sqlservercentral.com/Forums/FindPost1098960.aspx and http://www.sqlservercentral.com/Forums/FindPost1098990.aspx)

And if so, how did you manage to install SQL Server???

Is there any specific reason to open a new thread every few hours for the same conceptual issue?

For example http://www.sqlservercentral.com/Forums/FindPost1099849.aspx

or http://www.sqlservercentral.com/Forums/FindPost1098387.aspx

You're just wasting other resources since we might answer in...

my pleasure!

Ninja's_RGR'us (4/27/2011)

---

While we're at it... is there any way (other than a trace) to see all the queries run by a session between 2 dates?

Or plan A.2 Is there a...

I'd use a "slightly" different approach:

Instead of HAVING(COUNT(*)>0) I'd use a CTE and the ROW_NUMBER() OVER(PARTITION BY CHAR_1 ORDER BY <insert_preferred_column> DESC) AS Row approach and query for Row>1.

I'd insert...

Why using a CLR in the first place?

Wouldn't something along those lines do the job, too?

WITH sample_data AS

(

SELECT 0 AS n UNION ALL

SELECT 2 UNION ALL

SELECT 1

), cte AS

(

SELECT ...

Glad I could help 🙂

Glad I could help 😀

I'm not sure if the addtl. subquery to the sourcxe table is required.

Couldn't you just use another condition like

WHEN min(effdate)<=@startdate and max(termdate)<=dateadd(mm,-1,@enddate)...

Would the following script help?

SELECT DEST.TEXT

FROM sys.[dm_exec_connections] SDEC

CROSS APPLY sys.[dm_exec_sql_text](SDEC.[most_recent_sql_handle]) AS DEST

--WHERE SDEC.[most_recent_session_id] = 57

Source: http://www.mssqltips.com/tip.asp?tip=1799

Are you looking for something like this?

SELECT

carriermemid,

CASE WHEN

DATEDIFF(

mm,

CASE...

I don't think that a triangle. It's basically covering the range of values between two categories.

I tried a similar approach in parallel but Lamprey13 did post his solution earlier. And...

Quite possible.

That's one of the reasons I suggested to replace the trigger with a computed column (based on the requirement posted in the other thread). The INSTEAD OF option not...

Query plan and index stats don't seem to indicate an issue with the sproc itself.

Did you try a profiler trace on that specific sproc to verify if the pattern Craig...