Viewing 15 posts - 2,176 through 2,190 (of 2,452 total)
What is the relationship (link) between your two tables?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 3, 2011 at 11:08 am
Gianluca Sartori (10/3/2011)
J Livingston SQL (10/3/2011)
select convert(varchar,getdate(), 120) + ' ' + CASE WHEN DATEPART(hour,GETDATE()) > 12 THEN 'PM' ELSE 'AM' END
Please note that the "hour"...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 3, 2011 at 8:21 am
select convert(varchar,getdate(), 120) + ' ' + CASE WHEN DATEPART(hour,GETDATE()) > 12 THEN 'PM' ELSE 'AM' END
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 3, 2011 at 7:06 am
this may help
SELECT MP.pname AS Phone_Name,
MP.pnumber ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 3, 2011 at 6:46 am
Jeff Moden (10/2/2011)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 2, 2011 at 11:34 am
Not really clear on your question....???
can you please provide script that will create and insert data that represents the problem you have..(see link in my sig if not clear)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 1, 2011 at 12:01 pm
long time since I migrated Access to SQL...so not really sure what SSMA actually does in the "conversion"
for data types : http://msdn.microsoft.com/en-us/library/ms187752.aspx
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 1, 2011 at 8:46 am
This may help
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=26709
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 1, 2011 at 12:00 am
Ninja's_RGR'us (9/27/2011)
HOWEVER. Keep in mind that for any insert, update, delete in ANY of the tables of the indexed view, you will...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 27, 2011 at 1:42 pm
Jeff Moden (9/25/2011)
J Livingston SQL (9/25/2011)
Heh... no fair. I asked you for your results first. 😛
I've not run your code yet. I was waiting to see if you...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 27, 2011 at 1:01 pm
Jeff....code below.
if not clear, pls post back
use tempdb
GO
--===== Conditionally drop the tables
IF Object_id('vw_PreAg', 'V') IS NOT NULL
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 25, 2011 at 11:38 am
Do you have the code that built the 20M*30*100 data for both tables so we can test at the level you did?
Did you do a comparison of the original code...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 25, 2011 at 9:06 am
First off....I agree with Jeff's test results having run on both 2005 std and 2008R2 dev.
personally, I really dont like hardcoding pivot columns, and more often than not, will be...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 25, 2011 at 7:55 am
good article here
http://www.sqlservercentral.com/articles/T-SQL/63681/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 21, 2011 at 12:37 am
just wondering if this post has any relevance to this one by same OP...???
http://www.sqlservercentral.com/Forums/FindPost1176651.aspx
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 20, 2011 at 1:26 pm
Viewing 15 posts - 2,176 through 2,190 (of 2,452 total)