Caz, (not trying to be arrogant, but to help you completely understand) please keep in mind that it is not a "parsing" issue. It is a data/design issue. In...

I'm sorry, maybe I was not clear... The default collation for SQL Server is not case-sensitive. I believe we are saying the same thing 🙂

Thanks,

Jared

I want to make note here that collation may not the issue. Collation allows you to filter on case, not insert and return it.

Collated ex: SELECT * FROM...

It should be important for you to know which require an inner join and which require left join. Using a left join on all tables may give you undesired...

Hi,

It will be important for you to show us the stored procedure so we can see how this table is being populated. Is it possible that this SP is...

bitbucket-25253 (6/20/2011)

---

Here is a possible way of achieving what you need.

alter PROCEDURE [dbo].[GetMapLocationsByState]

@LocationState nvarchar(2)= NULL

,@Director...

Check out this link: http://www.sqlservercentral.com/Forums/Topic291798-148-1.aspx

You do not need Enterprise or DataCenter to use bcp or SSIS. These are available in standard edition as well. Is the goal to script this so that it...

What about for the Director? I was thinking something like this:

ALTER PROCEDURE [dbo].[GetMapLocationsByState]

@LocationState nvarchar(2), @Director nvarchar(100)

AS

BEGIN

SET NOCOUNT...

Will you be allowing them 2 fields to fill in or just 1? i.e. Will the procedure take 2 parameters and return results based on that? I would take 2...

Thank you everyone for your comments. The ultimate goal here was to generate a number within a specific range that is unique. This range could reset once the...

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

---

opc.three (4/28/2011)

---

jared-709193 (4/28/2011)

---

The problem right now with using BCP right now is that the Perl script validates data by what errors occur during insertion. These defunct rows are...

The problem right now with using BCP right now is that the Perl script validates data by what errors occur during insertion. These defunct rows are written to a...

Thanks for the response. Unfortunately, for the short term BCP is not doable. The only issue is the CPU usage being so high. This is a staging server and...

Great! Thanks!

Jay