I'll repeat it, no one has access to the SQL Server code except for people at Microsoft.

If you liked the Eirikur's example, here's a variation to show the difference between...

Make sure you have the correct number of BEGIN and END.

Without details, that's the only thing I could find.

EDIT: Also check your variables declaration.

levenyu (9/23/2016)

---

Luis,

Thank you for the reply.

There is no issue with using word Length in there, it was that (-1) value of the @Length variable, which has caused wrong results to...

Actually, the formula is working as intended. The problem is that I was testing the formula with different values for the length and forgot to set it back when copying...

Use this at the beginning of your code:

SET DATEFORMAT DMY;

You probably have your server configured incorrectly, using the U.S. defaults.

The other solution should work fine if you make the join an outer join. Depending...

Smendle (9/23/2016)

---

I would love to get an official response from someone in the know on source code...

1. Is a passed parameter treated as a variable once inside the stored...

Here's an example on how to do it.

--Create the sample data

CREATE TABLE Table1( n int);

CREATE TABLE Table2( n int);

WITH

cteTally(n) AS(

SELECT TOP 1000 ROW_NUMBER() OVER(ORDER BY...

Hell NO!!!:crazy:

What kind of tool wrote that code?

That's only a snippet. It's missing the SELECT.

There's no way I'm going through all that code. Format it if you expect any help.

All the results from a CASE expression should...

Smendle (9/22/2016)

---

🙂

thanks for all the replies I am smiling now because of you guys(or gals)!

This is also why simple questions don't always have simple answers esp. for SQL.

So my question...

No, I won't. That's why I mentioned it. 🙁

Smendle (9/22/2016)

---

i could be confusing this with a .NET programming environment but doesn't that initialize the...

drew.allen (9/22/2016)

---

The...

I would, at least, put the DW schema on its own database. That way you can backup just that data. I'm not sure how long do you keep the data...