WayneS (6/29/2010)Out of curiousity, did you use the first solution as it's written, or did you follow the recommendation to build your very own tally table with a clustered index...

Thanks for everyone's contributions. I wasn't the one asking the questions, but I learned a lot from the post.

Wayne's solution above is by far the most efficient of the...

Here is the split function with a single query doing all the splitting. It uses a recursive common table expression to split the string:

create function fn_Split

(

@String varchar(max)

,@Delimiter char(1)

)

returns table

as

return

with...

Hi Vasu

There are several solutions to your problem. I assume that a primary key/unique constraint exists on cust_id and date_completed. I refer to the two tables as main...

This article came at exactly the right time. I've been struggling to improve the performance of a rather complex search query, but without success. The query was using...

If I understand you correctly the values stored in the "name" column of the @tblCustName table may contain single quotes. Replace all the single quotes in then "name" values...

If the manager says, "I want all the employees who joined in year 2009 until 06-Feb-2009." In SQL, this is a very simple query - Date of Joining >= (greater...

No, the path is set with an "Execute SQL Task". The variable is set to the correct path and the path is valid. It appears that the ConnectionString...

This doesn't make any sense to me, but it solved the problem.

Just some background on what the stored proc in the task does: It does validations against data in...

Hi Tom

I've copied the T-SQL which the task generated from the profiler and ran it in SSMS. It is running fine in SSMS.

Gideon

Another way to keep the log database "small":

When I log workflow activity I normally decide how long the log data will be stored. Say I have a limit of...