That would really be more of a Subversion question than a SQL Server question. There is no reason that it would be impossible to deploy to SQL Server through...

You would be more likely to get relevant help on Microsoft Access if you're in the forum for Access ... http://www.sqlservercentral.com/Forums/Forum131-1.aspx. Good luck.

There is an easy and efficient method to do this using "FOR XML PATH". Do a search on XML path concatenation and you should find some good examples.

Try a google search on "dynamically create files in ssis" and you'll get a lot of information complete with code examples.

I vaguely remember something about there being issues with this kind of query not returning any values for fields in which the value is actually an array (i.e. potential multiples...

Try this ...

where (CLREFER.ZIP = @ZIP or @ZIP = '')

and MWAPPTS.ADATE between @FIRSTDATE and @LASTDATE

I don't work with Reporting Services much, so I don't know if the @ZIP = ''...

Using a coalesce in a joining or filtering condition is almost always a bad idea. You're going to end up with a full scan on the table in question....

You can find out some info on your proc through the DMV sys.dm_exec_procedure_stats. The cached_time field would give you an idea of when it was changed because it would...

Some things you might want to consider:

You could use an int and add leading zeros at the presentation layer. Generally, this would be done within the application that is...

Understand that the number of times the function is going to be called is dependent on whether or not it's correlated with the outer query (and some other more complex...

You can join on sys.schemas ...

SELECT s.name + '.' + o.name

FROM sys.objects o

JOIN sys.schemas s

ON s.schema_id = o.schema_id

WHERE o.type = 'U'

AND LEFT(o.name, 3) NOT IN ('sp_', 'xp_', 'ms_', 'dt_')

If the columns you want to return are variable depending on input then your options on the SQL side are either to use dynamic sql or use if blocks to...

I know you're new to this forum ... please see the link in my signature for information about how to post questions with test data included so that people can...

Please don't cross-post as that just wastes people's time. The original thread can be found here.

LEN is used for such a task, CAST and CONVERT are not. Is this a homework assignment?