Are you sure that you created the SP and not just saved the script?

You're missing the CREATE PROCEDURE statement.

You could create a cte with all the dates and check for the ones you're missing.

Here's an example but you might want to change the code to include more values...

Help! I was asked by my DBA to optimize the following query because it has a high cost.

DELETE MySchema.Facttable

WHERE datecol = @Date;

It's part of a stored...

Have you tried removing the CONCAT function from the GROUP BY and HAVING clauses? Just use the columns directly on group by and remove them from having.

Smalldatetime doesn't store or uses seconds. It always rounds to minutes.

Reference: http://msdn.microsoft.com/en-us/library/ms182418(v=sql.110).aspx

That's why your dates should be stored as date data types (date, time, datetime, smaldatetime, datetime2). Otherwise, you'll get on complex calculations like this:

Declare @pera int = 201310,

...

I'm really worried on what you might be learning on that site. You're using the old-join style which might seem fine for inner joins but it'll became more confusing with...

If you try this, I'd suggest to use one of the alternative methods posted in the discussion of the article.

I hope that this is part of a data cleansing process because it's complicated and won't be great for performance.

Here's a possible solution. Be sure to understand it. It uses...

Performance problems can be caused by many things and we don't have enough information. Please read the following article to be able to post what we need to help you.

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Why not? It never states that...

You can find some reference here:

http://msdn.microsoft.com/en-US/library/ms143515(v=sql.90).aspx

SQL Server doesn't order based on unicode values. The collation defines order to a certain point. Why do you need to understand the order of non-alphanumeric characters?

Maybe you could use...

Yes, you can do it with dynamic sql. The question is why would you do that.

Altering the schema to fit an xml file is wrong and should be done the...

I could help you get the desired result in SQL Server, however, that might not work for you. You could try on a forum based on MariaDB which is what...