born2achieve (10/19/2013)

---

Hi Jeff Thanks for your response and great article. But i have a concern that you are using custom year next to the declaration.

SELECT @fromYear='1913-01-01', @toYear='1998-01-01'

I don't want...

Not knowing what changes you made to your code I made a simple change, I moved your CTE pdtmstr into a select into statement to populate a temporary table called...

cdl_9009 (10/18/2013)

---

I think this is close but still isn't working. It is saying no data found but i know there is.

select VENDOR.vendor_name, (ORDERS.ORD_TOTAL_COST + Orders.ord_total_cost)as "Total Amount Owed"

from VENDOR...

The problem with giving you any suggestions at this point is we don't know enough to actually provide you with any viable alternatives. We can't see from here what...

Go down...

Let's make this easier...

What are you trying to accomplish?

declare @Str1 varchar(10) = 'ABBA';

if @Str1 = reverse( @Str1)

print @Str1 + ' is a Palindrome'

else

print @Str1 + ' is not a Palindrome'

set @Str1 = 'ABC';

if...

No recursion needed:

declare @Start int = year(getdate()) - 15;

declare @Upto int = year(getdate()) - 100;

with eTally(n) as (select top(@Start - @Upto + 1) ROW_NUMBER() over (order by (select null)) -...

As long as it is not used in a production environment. The developer edition is meant for use in development, testing, and demonstration of capabilities. Be sure to...

I've have given you suggestion. Install the Developer Edition on your development/test servers so that you have access to same features as you are using in production.

In addition to removing the partitions from the table(s) you will also need to drop the partition schemes and partition functions. As long as those exist you will still...

tony28 (10/17/2013)

---

Lynn Pettis (10/17/2013)

---

Well, the word doc has the DDL but I am not taking the time to convert you Excel sheet to necessary format to load the tables.

You really...

Well, the word doc has the DDL but I am not taking the time to convert you Excel sheet to necessary format to load the tables.

You really need to read...

bugg (10/17/2013)

---

Lynn Pettis (10/17/2013)

---

Not sure, but this may just be a metadata change to the column. Looking at the numeric data type since your precision is not changing, the number...

Please let me know when you decide to post the DDL (CREATE TABLE) statements, sample data (INSERT INTO) for the tables, and expected results based on given inputs to the...