Viewing 15 posts - 1,276 through 1,290 (of 1,468 total)
Could someone please explain me that the Adjacency List and Nested Sets structures are used in...
January 30, 2017 at 6:47 am
SELECT course_id = ISNULL(p.course_id, 0), pscd.sub_category_details_id
FROM #products_sub_category_details AS pscd
LEFT JOIN #points AS p
ON pscd.sub_category_details_id = p.course_id
GROUP BY pscd.sub_category_details_id, p.course_id
/***/ ...
January 26, 2017 at 10:25 pm
SELECT username, schoolnum, MainRole FROM test1.dbo.Table1
EXCEPT
SELECT username, schoolnum, MainRole FROM test2.dbo.Table1;
January 24, 2017 at 10:28 pm
Although STRING_SPLIT is a native function to SQL 2016, it is not very efficient.
You will get better performance if you use the following SQL STRING SPLITTER
January 24, 2017 at 10:24 pm
January 23, 2017 at 4:27 am
January 23, 2017 at 12:43 am
I would start by finding all of the objects that reference the lookup table.
SELECT
SchemaName = OBJECT_SCHEMA_NAME(sm.object_id)
, ObjectName = OBJECT_NAME(sm.object_id)
FROM sys.sql_modules...
January 19, 2017 at 10:56 am
All the outputs of your case statement need to have the same (or implicitly convertable) data type.
Also, your case statement needs to be terminated with and end
January 18, 2017 at 11:20 am
January 16, 2017 at 3:14 am
January 16, 2017 at 3:11 am
I have a set of relatively big tables with very high reads and writes occurring...
January 16, 2017 at 2:51 am
DECLARE @String VARCHAR(50) = '#BAVDB#(RowCount=3204)';
-- As a single statement
SELECT NumVal = SUBSTRING(@String, CHARINDEX('=', @String) +1, CHARINDEX(')', @String, CHARINDEX('=', @String) +1) - CHARINDEX('=', @String) -1);
--...
January 13, 2017 at 3:44 am
January 13, 2017 at 3:31 am
Viewing 15 posts - 1,276 through 1,290 (of 1,468 total)