For those of us used to making data-marts

USE [Documents]

GO

/****** Object: StoredProcedure [dbo].[usp_GetTopN_MembershipType] Script Date: 9/10/2013 8:12:48 AM ******/

-- =============================================

-- Name:use_GetTopN_MembershipType

-- Description:Gets some number of...

I'd like to do the same thing, but have not had any luck either, I'll follow this thread along to see if anyone has an answer to this - good...

In the Color property of your text box, not in the Format property.

Please add your expression to the Color property of the text box, something like this

...

Hi Steve - Kinda of a dirty trick changing the question...

The question posed at the front page sets mychar to varchar(10) which would fail the batch insert so 0 is...

This seems so absurd that these attitudes would be fostered and expressed in this century. I think our world is better for the many technical contributions and perspectives, regardless of...

I got a syntax error from the text on the second example.

Change the line

SELECT @mStrColumns = COALESCE(@mStrColumns + ', ', '') + '[' + CAST(SC.[NAME] AS VARCHAR(100) )...

I see the folks at the top of the QOD (Gail, Steve etc) are listed as SSC Champions... but in their individual pages it's as you noted....

Not to oversimplify, but once the newest file is identified one option is to use script to copy it to a predetermined name like workfile.csv. Then when done, dispose or...

Hi Jerry,

I appreciate this article not just for the technical elements but for the deductive reasoning that identifies the problem from the noise. This is a very good guide on...

Likewise I appreciate Scott's comments. I see a lot of value in Derik's approach, this looks like 'diced onions' to me - thanks all 🙂

Nice work Hilda - I have fought that dragon too with embedded dates in large text fields.... I like your solution. Since I'm also a dot.net guy my approach is...

Looks like the PIO's are not loaded - have you installed the Primary Interop Assemblies?

I was looking at a similar problem and that is a smart solution Divya - thank you 🙂

Check the stats on the table.

Look at execution plan for bootlenecks/scans etc

Veryify order of Where parameters works to effectively

Check the indexes for existence and fragmentation.

Definitely pre calc the date comparision.

If...

While easy for execs is a nice term, it doesn't address the real issue which is always - 'what makes that number and where did it come from?'. You...