How does that help?

I know that I...

Or you could avoid the need for a table if you're using them just once.

Select *

from YourTable

WHERE Id in (Select Id from dbo.DelimitedSplit8K(@Parameter, ','))

Notice that I used the...

You can use a Transform Data Task with your DB Server as the Source and an Excel Connection as your Destination.

To make it read-only, you might need a script task....

Why don't you create the DB on the cloud and restore it from a backup (which might be compressed if you're on 2008R2+). It seems safer than using mdf and...

There's no need for window functions, they won't work better than a simple aggregate function.

You don't need to write a complete CASE either. Here are two options to shorten the...

You might want to take a look at cross tabs. It's fairly easy and it just requires copy-paste-replace. 🙂

http://www.sqlservercentral.com/articles/T-SQL/63681/

SELECT

MAX(CASE WHEN ItemNumber = 1 THEN...

Here's what I got from playing a little bit with the information.

SELECT SUBSTRING( Place, CHARINDEX('(', Place ) + 1, CHARINDEX(')', Place ) - CHARINDEX('(', Place ) - 1)

...

And a different way of doing this with the Pattern Splitter.

http://www.sqlservercentral.com/articles/String+Manipulation/94365/

WITH sample_data(val)

AS

(

SELECT '1.9999-Q1'

UNION ...

If those are calculated columns, why do you need them at all?

You certainly don't need a table per month. On the worst scenario, you could use a self join.

So, what's the question again?

Take a look at the DATEADD function.

After you understand how does it work, you could go further by using this date routines: http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/

You don't need the order by CID as there's only one CID on your subquery.

You were overcomplicating your ORDER BY clause.

SELECT u.CID,

STUFF(( SELECT '; ' +CAST(tu.Dept AS VARCHAR(MAX))+' '+CONVERT(VARCHAR(25), tu.CDate,101)

...

Just to be clear on what Sean said.

The current delete is rolled back and the previous ones remain commited.

Maybe something like this?

SELECT ISNULL( w.Word, 'None'),

COUNT(t.String),

ISNULL( SUM((LEN(t.String)-LEN(REPLACE(t.String,w.Word,'')))/LEN(w.Word)), COUNT(t.String))

FROM @word w

RIGHT

JOIN @t t ON String LIKE '%' + Word + '%'

GROUP...