It's recommended to open BOL time to time (press F1)

C. Use ROUND to truncate

This example uses two SELECT statements to demonstrate the difference between rounding and truncation. The first statement...

declare @Andy nvarchar(50)

select @Andy = 'andy' + char(13) + ' '

SELECT     charindex(' ', @Andy)

result: 6

Gives an idea?

Add Versions to select:

INNER JOIN (select StoreId, CompanyId, MAX(Active) as Active, MIN(Version) as Version from Karts group by StoreId, CompanyId) Karts ON Stores.StoreID = Karts.StoreID AND Stores.CompanyID = Karts.CompanyID

By "wrong table"...

Seems your status column is placed into wrong table.

But anyway try to replace

INNER JOIN Karts ON Stores.StoreID = Karts.StoreID AND Stores.CompanyID = Karts.CompanyID

with

INNER JOIN (select distinct StoreId, CompanyId, Active...

Say you have 2 tables in both databases:

Create table thing (

  Id int IDENTITY(1,1),

  Name nvarchar(50) NOT NULL,

  typeId int NOT NULL)

Create Table ThingType (

  Id int Identity (1,1),

  Name...

If Version id itd datatype, use this:

ORDER BY Karts.Active * Version

Is version is varchar,

ORDER BY case when Karts.Active = 1 then Version else '0' end

CREATE VIEW dbo.TransView

AS

SELECT T1.Col2 as VC1, T1.Col3 as VC2, T2.Col1 as VC3, T2.Col2 as VC4

FROM Table1 T1

    INNER JOIN Table2 T2 on T1.Col3 = T2.Col1

GO

-- Say Col1 in Table1...

Create a view on your 2 tables to repeat schema of the table you are going to import data from.

Create trigger "INSTEAD OF INSERT" on this view.

Within a trigger you...

You cannot use function call as a parameter for anither function. It's wrong syntax.

DECLARE @String varchar(100)

SELECT @String =dbo.getSOs(121616)

SELECT * FROM dbo.SplitToInt(@String,';')

(@@Datefirst + DATEPART(WEEKDAY, @AnyDate)  )%7

is constant for any DATEFIRST set up.

For Mon it's 2, fot Tue it's 3, etc.

Use it to get rid of DATEFIRST dependency.

If you use

(@@Datefirst...

SELECT ...

FROM MyTable

WHERE LastUpdated between dateadd(n, -2, GETDATE()) and GETDATE()

Sorry, because you have [Description] in resultset it will always being used for ordering. It was long discussion about year ago about ANSI and implementation of its prescriptions by Microsoft.

Good...

Do not specify prefix in ORDER BY clause.

SELECT          f.[Id],

                [Description] = CASE

                    WHEN b.[Description] IS NOT NULL THEN b.[Description]

                    ELSE f.[Description]

                END,

                [Foo_Description] = f.[Description]

FROM            [dbo].[Foo] AS f

LEFT OUTER JOIN...

midan1, your problem you are playing with varchars where it must be datetime.

If period from 16:00 to 20:00 is something to be hardcoded?

I don't think so. So, store it in...

SELECT *

INTO ...

FROM ...

There is F1 key on your keyboard. It calls BOL. It's really useful in case of syntax questions.