Viewing 15 posts - 16 through 30 (of 212 total)
That was an easy one, thanks! You could also solve this query with CONCAT. 🙂
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
January 25, 2017 at 2:28 am
It's a classic implicit conversion issue. SQL Server will never convert a "bigger" datatype to a smaller.
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
July 11, 2016 at 6:49 am
Well it's still possible to write the alias in 12 different ways in SQL2014 (deprecated or not) 🙂
SELECT object_id AS test
FROM sys.columns AS mt;
SELECT object_id AS 'test'
FROM sys.columns...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
September 6, 2015 at 5:50 am
SQL Guy 1 (10/7/2014)
From Text field I can...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
November 4, 2014 at 9:26 am
Interesting SQL server question! I learned something new today. 🙂
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
November 2, 2014 at 6:00 pm
Interesting question! Never heard of it and got It wrong, but I learned something new. Thank you!
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
October 27, 2014 at 1:21 am
TomThomson (10/23/2014)
Amusing question; the use of RAND is an interesting distraction for a question that is really about UNION ALL and nothing else.
I agree! It would have been UNION instead...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
October 26, 2014 at 5:26 pm
Thanks for the easy one. 🙂 I've used template files a lot and I love them.
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
October 26, 2014 at 5:19 pm
Mighty (10/16/2014)
0 points out of 2. Will try to select an incorrect answer tomorrow to see if I get a point. 😛
Excellent idea! 🙂
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
October 16, 2014 at 3:02 am
Vimal Lohani (10/15/2014)
twin.devil (10/15/2014)
Comments posted to this topic are about the item <A HREF="/questions/unpivot/117130/">Unpivot</A>
HAHA,
Still wrong answer
admin has not tested it.
Answer should be two rows.
OrderIDProductNameProductQty
1 ...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
October 16, 2014 at 2:08 am
Toreador (10/15/2014)
paul.knibbs (10/15/2014)
I mean, the error about incorrect syntax near "FROM" isn't one of the available answer options, so it should be pretty obvious that's not what was intended.
It would...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
October 15, 2014 at 2:59 am
That was an easy question. 🙂 Thank you for that point.
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
October 6, 2014 at 1:11 am
Ed Wagner (10/3/2014)
SqlMel (10/3/2014)
But I must say that I do not use this feature in my coding.
I haven't either. I'd use TOP myself, but this is another nice tool...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
October 3, 2014 at 7:43 am
Sean Pearce (10/1/2014)
Roland C (10/1/2014)
Another badly redacted question ! It gets a little boring :doze:You could always submit your own question.
I agree with you. I Think it's hard to create...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
October 2, 2014 at 1:19 am
Eirikur Eiriksson (10/1/2014)
Slightly off topic, prefer using RAISERROR to PRINT for progress reporting on long running scripts as it is almost instant and the printf...
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
October 2, 2014 at 1:12 am
Viewing 15 posts - 16 through 30 (of 212 total)