there is not enough information to create a concrete solution. How does the data relate to one another? For eample do they both have the same ID field....

the problem is not with the veiw but rahter the select. When you have more than one table involved you have to tell it how it relates to the...

above the basics no. there is not a really a magic bullet that can be applied to every environment. It unfortunatley requires you to undertand your environment and...

I would alter the SP and add a line like

print or select @SaleCategory

This would allow you to see what is actually making it in to the variable.

sorry looked at it wrong althought there is still an issue with the string being passed. Try

EXEC dbo.GetSales GETDATE(), '''Outer Wear'', ''Mens'', ''Foot Wear'', ''N/A''';

GO

removed for post below

The size difference is expected as xlsx files are more space freindly. To my knowledge you can not open an xlsx file or even import one into SQL. ...

In a side by side it is very similiar. once you setup the new 2008 DB you can identify applications that connect to your DB's. you will...

Given your example

Row_number would not be the tool to use. Data wise there is absolutley no difference that I can tell between

A---------USD---------10------------1

and

A---------USD---------10------------1

since there are identical...

could you add a sample outcome. It may be due to monday but I am not sure I follow what you are looking for.

Are you planning to do an in-place upgrade? if so what I would do is install a version of 2000 on a different box and apply patches to pring it...

I would suggesst looking at what space is available. Can the TemDB be moved to a drive with more free space? What is running that is actually filling...

mtassin (4/15/2011)

---

UMG Developer (4/14/2011)

---

Of course it isn't this year, taxes are due on April 18th...

From: http://www.irs.gov/newsroom/article/0,,id=233910,00.html

Taxpayers will have until Monday, April 18 to file their 2010 tax returns and pay...

The way the type table is defined currently it would be difficult do you have any control over the desing of that table? Rather than have the type stored...

Try removing the variable for ASC/DESC I am guessing this is where it has the issue. I have never tried using a variable for that but that would...