Next, looks like this subquery will always return rows with LKC2.seq == 1, if any.

(select LKC.lockID,LKC.seq,A.lockCombo2

from

[LockerPopulation] A

JOIN TST.dbo.School SCH ON A.schoolnumber = SCH.type

JOIN TST.dbo.Locker LKR ON...

Type of, pseudocode

create procedure newProc (

@Plan_Indicator_ID

@FinancialYearID,

@RangetypeID,

@VersionID

)

as

if (@VersionID is null and @RangetypeID is not null ) then

firstProcCode (@Plan_Indicator_ID,@FinancialYearID,@RangetypeID)

else if (@VersionID is not null and @RangetypeID is...

declare @currentWeek int =26

select ...

from (...) as t -- selects exactly 52 rows you need

order by case when @currentweek >= t.week then 100+t.week else t.week

sqlinterset (6/22/2015)

---

I have a table has data of all months. i want to have this table data in the form as first it lists data

from 1 month to current...

This will not produce correct result for the input...

Having 2 very similar updates like

UPDATE t SET

t.AODYD = <exp1>

FROM <table expression>

WHERE <common predicates> AND <predicate1>

UPDATE t SET

t.DAODYD = <exp2>

FROM <table expression>

WHERE <common predicates> AND <predicate2>

you logically...

Using your setup above

DECLARE @dt DATETIME = cast('2014-11-25' AS DATETIME);

SELECT cast(dt as date) dt

,Order1

,COUNT(UNit.UNIT) AS Units

,SUM(CASE

WHEN (datediff(dd, INSV_DATE, d.dt)) >= 31

THEN 31

WHEN (datediff(dd, INSV_DATE, d.dt)) < 0

THEN...

Nice question.

MSDN has ADO.NET Code Examples https://msdn.microsoft.com/en-us/library/dw70f090(v=vs.110).aspx to start with.

First look at SqlClient namespace which is ADO.Net specific toolset for MS SQL DBs.

Having already done some Db related projects...

See Remarks in CREATE TABLE https://technet.microsoft.com/en-us/library/ms174979.aspx

Trigger is executed within the scope where insert is emitted which is essentially scope of PROCEDURE here. And trigger has its own scope. Trigger has...

This is bitwise AND. It requires INT operands

Look at

declare @i int = 13

Select @i & 1 bit1, @i & 2 bit2, @i & 4 bit3, @i & 8 bit4

Try move OUTPUT into trigger and use temp table created in the proc.

ALTER trigger tr_tmessage on tmessage

instead of insert

as

--Set NoCount On

insert into tmessage

OUTPUT inserted.ID INTO #tt

select dscp from inserted

GO

--

ALTER proc...

BOL:

Triggers

Columns returned from OUTPUT reflect the data as it is after the INSERT, UPDATE, or DELETE statement has completed but before triggers are executed.

For INSTEAD OF triggers, the returned...

Too many unknown parameters. First, what are criteria to extract family name? Last word exactly? Lookup table of all known family names? second word after [last] 'and' plus all the...

What is expected result for the sample data like this ?

INSERT INTO @T

SELECT 1 AS Id, 'A' AS Category, NULL AS ActivationDate UNION ALL

SELECT 2, 'X', NULL UNION ALL

SELECT 2,...