Please do not crosspost. It wastes peoples time and fragment replies.

Original thread with replies can be found here:

http://www.sqlservercentral.com/Forums/Topic1509687-17-1.aspx

SET DATEFIRST 1; -- first day of the week is a Monday

DECLARE @monthINT = 10;

DECLARE @yearINT = 2013;

-- Tally table of 7 rows

WITH CTE_Tally AS

(

SELECT 0 AS Number

UNION ALL

SELECT 1

UNION...

Any package configurations? (if using package deployment model)

Or parameters used to configure connection strings?

Matt Miller (#4) (10/29/2013)

---

If the input file is to simply be inserted into a table, why not use a flat file data source and bulk load it directly into a...

Nice question, thanks.

:cool:...

Phil Parkin (10/30/2013)

---

When you say users details,...

Use a derived column to replace the NULL values with 0.

I haven't done it myself, but I believe it will be possible.

Some examples on APPLY:

SQL Server CROSS APPLY and OUTER APPLY[/url]

If the stored procedure is converted to a function, you could use CROSS APPLY to call the function for each row.

I hope your boss is fully aware...

What is the error? How do you try to put TrxDateNumeric into StartDate?

ps: any reason why you are using NO_LOCK in your query?

Do you want to copy them?

Either write a decent SQL query that retrieves only the values you need and then copy paste it.

Or copy paste everything to Excel and then...

This could be a good start:

Collecting information about your SSIS packages

This post has a solution:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/c6491686-f65c-438a-a2ed-f646e5a5105e/function-to-get-all-special-characters-in-string?forum=transactsql