You have your case set wrong

It should be

INSERT INTO Criteria (GroupID, CustomFieldID, RelationalOperator, Value)

SELECT g.groupID, cfdn.CustomFieldID,

CASE

...

Can you post some sample data and the expected results?

Actually you can click on Tool --> --> options --> scripting. From here you can set the default to script does not exists, script indexes, foreign keys etc....

Then when...

BCP does not export column names. You would have to use SQLCMD or OSQL to export the column. Keep in mind that if you plan on bulk importing...

You can schedule the method I mentioned to you. It performs a bulk operation and will automatically generate the package for you. The package can then be stored...

You can also use regular expression functions.

regular expressions function

CREATE FUNCTION dbo.regexReplace

(

@source varchar(5000),

@regexp varchar(1000),

@replace varchar(1000),

@globalReplace bit = 0,

@ignoreCase bit = 0

)

RETURNS varchar(1000) AS

BEGIN

DECLARE @hr integer

DECLARE @objRegExp integer

DECLARE @result varchar(5000)

EXECUTE @hr =...

There are multiple ways to accomplish this task. You can use BCP, SQL CMD or SSIS. I would choose SSIS. All you have to do is right-click a...

NP, glad I could help.

Interesting..

True, but not if foreign keys exist. ...

This can be best implemented with either C2 auditing or DML triggers.

It should be mentioned that C2 auditing logs alot of information, maybe for than you need. ...

He said there are aprox. 10,000, now, though records can be inserted and updated.

Just rethinking about the problem here. But another solution would be to use DML triggers. This would fit your requirement and give a near real time replica of...

Man, thanks for having a good sense of humor. I've done very similar things and found that I can't respond to even the simplest of technical posts...

The above post was for everyone chiming in on the post that may not know about NULL calculations in SQL, not for you Jack.

Addtionally, this site has a good article.

http://www.sqlservercentral.com/articles/Advanced+Querying/gotchasqlaggregatefunctionsandnull/1947/