Forum Replies Created
Viewing 15 posts - 241 through 255 (of 506 total)
-
RE: Compute date column if other date columns not null ?
@Ld,
If you create the computed column in SQL or in the GUI the result is the same. To persist the computed column... -
RE: Compute date column if other date columns not null ?
CREATE TABLE #t
(
Id int IDENTITY NOT NULL
, date1 date
, date2 date
, date3 date
, date4 date
, date5 AS
CASE
WHEN ... -
RE: update data if row count matches based on column
The 2 tables don't have any data in common. That is, none of the ID values match from A to B. They don't have the same number of rows. What...
-
RE: Select MAX, Update Function
Please post your sample data in a consumable format (script including create table statement with inserts).
-
RE: Using CASE in Where Condition
In T-SQL variables must start with the @ character.
MaybeWHERE BO.LOGI1 = @mylogicVariable;
It's hard to guess, try to provide more complete information. -
RE: Query Help on PIVOT
Create Table #t (
Id varchar(5)
, C1 varchar(5)
, C2 varchar(5)
, C3 varchar(5)
, C4 varchar(5)
);
INSERT #t VALUES
('R1', 'R1C1','R1C2','R1C3','R1C4')
, ('R2', 'R2C1','R2C2','R2C3','R2C4') ;
SELECT u.Id
, u.Col
, u.ColVal
FROM #t t... -
RE: SSMS 17.6 connecting so SSIS 2016
Try running SSMS as Administrator then connect to integration services.
-
RE: Subtract Year from Year and Month
Try:DECLARE @yearmonth char(7)='2017-01', @YmMinusYr char(7);
SELECT @YmMinusYr = Convert(char(7), DateAdd(yy, -1, Cast(@yearmonth+'-01' AS date)), 120);
SELECT @yearmonth ThisYear, @YmMinusYr Last year;
-
RE: Encrypt Password in OPENROWSET
U could put it in an encrypted stored procedure. -
RE: Preparation of entry list according to subject
Try:
declare @T table
(
stockId int not null,
dealId int identity (1,1) not null,
dealType char(1) not null,
stockDate datetime not null,
... -
RE: SQL Server 2012: How to take database full backup with multiple files with Unique file name including date using Management.
Could you restate your question. I'm not sure what you mean by multiple backup files with unique name.
-
RE: SQL Server 2016 REF 70-761 question
I would have chosen H as DateCreated would tell you when the row was added but only if it is set properly as it has no default and is defined...
-
RE: Use an external Excel sheet as a parameter in SSMS WITHOUT using a stored proecedure
You could create a model to join data in an excel range to SQL Server tables.
Viewing 15 posts - 241 through 255 (of 506 total)