Viewing 15 posts - 1 through 15 (of 67 total)
October 26, 2018 at 9:30 am
October 22, 2018 at 2:38 pm
SELECT c.name, o.dated, ... FROM Customer c, Orders oOctober 22, 2018 at 8:47 am
Table aliases (in Join statements) -- Just Say No!
Your coding speed is probably not limited by your typing speed (thinking time is greater). Table aliases in Join statements make...
October 22, 2018 at 8:47 am
Just for fun:
CREATE TABLE t1 (x INT PRIMARY KEY, y INT UNIQUE);
GO
INSERT INTO t1 (x,y) VALUES (1,3); INSERT INTO t1 (x,y) VALUES (2,2); INSERT INTO t1 (x,y) VALUES...
March 7, 2013 at 9:29 am
Edward.Polley 76944 (3/6/2013)
Try this.CREATE VIEW dbo.test as (SELECT top (100) * from table ORDER BY primary_key_column). Look at the result they will be ordered.
"ORDER BY guarantees a...
March 7, 2013 at 9:04 am
David Walker-278941 (3/6/2013)
ORDER IS IGNORED IN A VIEW, starting with SQL 2005. Even with Top 100 Percent specified, starting with (I believe) SQL 2008. See Books Online and...
March 7, 2013 at 9:02 am
But!!!!!
ORDER IS IGNORED IN A VIEW, starting with SQL 2005. Even with Top 100 Percent specified, starting with (I believe) SQL 2008. See Books Online and many online...
March 6, 2013 at 4:31 pm
In the Type 4 example, I see that you have a "ValidFrom" column in Client_SCD4_History. But it never gets populated, since Client_SCD1 doesn't have a ValidFrom date.
I see you...
July 16, 2012 at 12:59 pm
Thanks for the reply. (The word "reent" in my question should have been "recent".)
SSIS expression language is a horrible language! I had to write some VBA code...
February 23, 2012 at 10:20 pm
Yes, as someone else mentioned, it's probably more efficient to order the dates descending, and then look for row_number() = 1 from the results, instead of looking for the max(date)....
October 18, 2011 at 9:32 am
swellguy (8/19/2011)
David,Yup, you're right, on 'begs the question.' Slipped through a couple editors, so good catch.
Thanks,
B
You're welcome. Thanks for the kind reply. I'm...
August 19, 2011 at 10:22 am
Please don't misuse the phrase "begs the question". It doesn't mean what you think it means.
I would tell the company that signed the contract that two colors is not...
August 19, 2011 at 9:55 am
peter-757102 (7/28/2011)
krowley (7/27/2011)
July 28, 2011 at 10:10 am
Viewing 15 posts - 1 through 15 (of 67 total)