Viewing 15 posts - 1,411 through 1,425 (of 26,490 total)
I came up with this:
CREATE TABLE SESSIONS(ID INT, SESSIONNAME VARCHAR(250), MAXSLOTS INT);
insert into SESSIONS
select 1, 'First Session', 5
union all
select 2, 'Second Session',3
union...
June 27, 2018 at 7:16 am
Sorry for this dumb question but I am very new to SQL. Could someone help...
June 26, 2018 at 5:10 pm
June 26, 2018 at 2:43 pm
June 26, 2018 at 2:15 pm
A simple catch all query will work
SELECT *
FROM @TAB AS [t]
WHERE ([t].[INCLUDE_ME] = @INCLUDE_ME) OR (@INCLUDE_ME <> 'Y');
June 26, 2018 at 12:12 pm
honestly, SQL is not my...
June 26, 2018 at 8:27 am
Still need to learn LEAD/LAG but would think one of these would be something to use with SQL Server 2012 and newer.
June 25, 2018 at 11:45 am
You know what seems to be the eternal question that no one seems to get tired of asking, "How do you restore a copy of a database to an older...
June 25, 2018 at 11:42 am
June 25, 2018 at 11:31 am
June 25, 2018 at 9:47 am
BUT, you should be aware of several things that affect the accuracy of...
June 22, 2018 at 4:14 pm
Viewing 15 posts - 1,411 through 1,425 (of 26,490 total)