Viewing 15 posts - 211 through 225 (of 290 total)
Thanks.
Keeping your recommendations in mind, I ended up doing it this way:
Select S.*, race
FROM SchoolGradeSex S
CROSS JOIN
(SELECT 'AMIND' as race
UNION SELECT 'ASIAN'...
November 9, 2018 at 8:47 am
;WITH A(A) AS (SELECT '' FROM (VALUES (0),(0),(0),(0),(0),(0),(0),(0),(0),(0),(0),(0),(0),(0),(0),(0)) T(C))November 7, 2018 at 1:41 pm
October 31, 2018 at 12:44 pm
I have found the reason! In the constraint edit properties under Evaluation Operation it says 'Expression and Constraint' instead of the default 'Constraint'.
Even though no expression is defined anywhere...
October 26, 2018 at 10:20 am
I have. that is exactly what the third image shows. there is nothing there.
October 26, 2018 at 10:11 am
This is the BIDS 2008 project that someone else created. I opened it the first time.
and when i execute it, the last container does not get executed. Everything ends...
October 26, 2018 at 9:03 am
What particular aspect of sql server are you most interested in?
including hands-on T-SQL or not?
October 23, 2018 at 7:51 am
THANK YOU! i like your idea a lot.
October 18, 2018 at 12:51 pm
Thank you.
I think the above CTE is my answer.
October 11, 2018 at 11:35 am
Sorry, I did not complete my question.
The only way I know is this:
select * from MWDatesPR M1
where...
October 11, 2018 at 11:34 am
October 10, 2018 at 7:51 am
What (version) of client tools to use to connect?
is it BIDS? is it Data Tools? (version?)
October 3, 2018 at 12:50 pm
Nice! Thank you. I appreciate everybody's input on this.
September 25, 2018 at 3:03 pm
Viewing 15 posts - 211 through 225 (of 290 total)