Viewing 15 posts - 256 through 270 (of 8,731 total)
Here is a page with 500+ T-SQL puzzles that could help. https://msbiskills.com/tsql-puzzles-asked-in-interview-over-the-years/
You could also try to solve problems from the forums which are more focused on...
January 28, 2019 at 11:23 am
January 28, 2019 at 9:52 am
jkramprakash - Monday, January 28, 2019 9:38 AMI tired the ORDER BY before FOR XML but it is showing error message.
Are we supposed...
January 28, 2019 at 9:45 am
My First View definition
CREATE VIEW FIRST_VIEW AS
SELECT PT.F_PRODUCT AS F_PRODUCT,...
January 28, 2019 at 9:12 am
I don't see how QTD or YTD are measures. They certainly look as calculations done on measures using a time dimension.
January 28, 2019 at 8:39 am
January 25, 2019 at 2:42 pm
Got back from a meeting this morning to discover that I suddenly had a second...
January 25, 2019 at 11:48 am
Will there only be 2 values or could you have more than 1 alias?
January 24, 2019 at 12:32 pm
January 24, 2019 at 8:49 am
What if we work with some sample data.
CREATE TABLE SolTracker(
eligibility_flg char(1) NULL
);
CREATE TABLE DutyManager(
eligibility_flg char(1) NULL
);
INSERT INTO SolTracker...
January 23, 2019 at 2:31 pm
set nocount on
declare @GroupCount int = 5
declare @MinValue bigint = 5000000000000480...
January 23, 2019 at 12:39 pm
January 23, 2019 at 9:30 am
January 23, 2019 at 8:48 am
January 23, 2019 at 8:24 am
thomas.miller1 - Wednesday, January 23, 2019 7:52 AMFound it, lol TO_CHAR(SomeColumn,'YYY-MM-DD')....ugh
That's an Oracle function.
January 23, 2019 at 8:21 am
Viewing 15 posts - 256 through 270 (of 8,731 total)