Viewing 15 posts - 136 through 150 (of 628 total)
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....
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 18, 2011 at 12:26 pm
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...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 18, 2011 at 12:18 pm
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...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 18, 2011 at 11:37 am
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.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 18, 2011 at 10:18 am
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
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 18, 2011 at 10:00 am
removed for post below
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 18, 2011 at 9:55 am
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. ...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 18, 2011 at 9:52 am
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...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 18, 2011 at 9:30 am
Given your example
Policy-----Currency-----Amount------Row_Number() as GroupID
A---------USD---------10------------1
A---------USD---------10------------1
A---------USD---------10------------1
A---------GBP----------10-----------2
A---------JPY----------10-----------3
B---------USD----------10-----------1
B---------GBP----------10-----------2
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...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 18, 2011 at 9:18 am
could you add a sample outcome. It may be due to monday but I am not sure I follow what you are looking for.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 18, 2011 at 8:44 am
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...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 18, 2011 at 8:38 am
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...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 15, 2011 at 2:50 pm
mtassin (4/15/2011)
UMG Developer (4/14/2011)
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...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 15, 2011 at 1:56 pm
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...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 15, 2011 at 10:46 am
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...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 15, 2011 at 10:30 am
Viewing 15 posts - 136 through 150 (of 628 total)