Viewing 15 posts - 211 through 225 (of 506 total)
Please post DDL (create table) for each table and inserts with sample data so those helping don't have to type this for you and answer your question.
May 22, 2018 at 2:52 pm
Jezz,
The mention of a variable above refers to a table variable for the sample data instead of creating a table.
May 22, 2018 at 2:41 pm
Developer Edition has all the Enterprise features but is only licensed for development. So yes it includes SSRS.
May 21, 2018 at 6:40 pm
DDL = Data Definition Language. It includes CREATE, ALTER and DROP statements.
DML = Data Manipulation Language. It includes DELETE, INSERT, SELECT, UPDATE and MERGE statements.
CREATE TABLE MyTable(FirstColumn...
May 21, 2018 at 3:18 pm
Please post DDL for the tables or T-SQL for table variables and sample data in the form of inserts.
May 17, 2018 at 11:40 am
DECLARE @vendors table( Id int IDENTITY, VendorName varchar(100) );
INSERT @vendors ( VendorName )
VALUES ( 'V1' )
, ( 'V2' )
, ( 'V3' )
, ( 'V4' )
...
May 17, 2018 at 11:35 am
replace May 17, 2018 at 10:39 am
SET @Where = ' WHERE Name LIKE %';
with
You can grant execute on a database or a schema to a user or role. The user May 17, 2018 at 9:14 am
DECLARE @Object TABLE (
[ObjectID] [int] NULL,
[ObjectName] [nvarchar](255) NULL
);
INSERT INTO @Object (ObjectID, ObjectName
)
VALUES(174169,'Network of Excellence');
DECLARE @AttibuteValues table(
[AttributeID] [int] NULL,
[AttributeName] [nvarchar](255) NULL,
[CategoryName] [nvarchar](255) NULL,
[VersionNumber] [int] NULL,
[ValueInt] [nvarchar](255) NULL,
[ValueStr] [nvarchar](255) NULL,
[FKObjectId] [int]...
May 15, 2018 at 11:09 am
DECLARE @t table(Participants nvarchar(1000));
INSERT @t ( Participants )
VALUES ( N'Green, Jack;ews@coby.com;jim.beck@downing.com;Yue, Ian' )
, ( N'cody.Ortiz@about.com;Enverga, Frank;carol.green@michi.com' )
, ( N'mtorrent@cali.com;Mike, John;tom.frank@ncsc.com' )
SELECT names.rn id
, a.Item Emails
...
May 14, 2018 at 4:58 pm
@scott.barrett 23151
In your post above you have IFF...
May 14, 2018 at 2:13 pm
R service is a service to run R code in the database. There aren't specific R objects to backup.
May 7, 2018 at 5:13 pm
Also in SQL Server 2012 they introduced OFFSET so in SQL Server 2012+ you can use.
CREATE TABLE EMP (EMPID int , SALARY INT);
INSERT INTO EMP VALUES (1,20000);
INSERT INTO...
May 7, 2018 at 5:09 pm
The only way I can think of is adding an updated column with a trigger that updates it on after update.
May 7, 2018 at 5:01 pm
Viewing 15 posts - 211 through 225 (of 506 total)