Table sales_month doesn't contain year. Start with something like this:

SELECT s.*, c.*

FROM Sales_Month s

INNER JOIN view1 c ON c.? = s.Month_Number

WHERE c.[year] = ?

Replace the question marks with something...

winmansoft (3/26/2013)

---

Hi,

I am using Sql server 2008 R2 express.I want a column id with auto incrementing value in my table.But i don't want to use built in Auto increment property...

Edit: duplicate post.

select top 5 machine.name, machine.model, machine.scantime

'INSERT INTO [SMS_000].[dbo].[BMCMachines] ([ComputerName],[MachineModel],[stime]) VALUES (' + '''' + machine.name + ''',' + '''' + machine.model + ''',' + convert(datetime,machine.scantime,112) + ''')' from...

Steve JP (3/26/2013)

---

...The issue with the convert is that the 3rd arguement is the style and is used to set the style when you convert from a datetime to a...

astrid 69000 (3/26/2013)

---

Chris, i did what i asked. your query added groups to the dates. from 1 to 8 group 1, from 9 to 16 group 2 and so on...

abitguru (3/26/2013)

---

GilaMonster (3/26/2013)

---

You're selecting, then updating the table with...

You will need to apply similar logic to all tables which have duplicate rows per employeeid. I'd guess that you need the most recent rows containing org.ORGANIZATIONID and job.JOBTITLEID. Can...

Astrid, please look very carefully at the results of Kingston's solution and mine. They look the same but they are not. One of them will be correct (probably!), the other...

Is this what you're looking for?

DROP TABLE #SampleData

;WITH SampleData AS (

SELECT *

FROM (VALUES ('A',1), ('B',2), ('C',3), ('D',4), ('E',5), ('F',6)) d ([SomeStuff], [OrderlineID])

)

SELECT *

INTO #SampleData

FROM SampleData

-- check

SELECT * FROM...

Yes - one or both of the other two tables has multiple rows per employee. Can you check both tables to...

-- Create a sample data set to work with

-- A #temporary table called #AstridsSampleData

IF object_id('TempDB..#AstridsSampleData') IS NOT NULL

DROP TABLE #AstridsSampleData

;WITH CTE_SomeStuffIMadeUp ([day], [Count]) AS (

SELECT '2008-01-01 00:00:00.000', 3 UNION...

Run this, post the first ten or so rows returned:

SELECT rn = ROW_NUMBER() OVER(PARTITION BY employeeid ORDER BY ACTIONORDER DESC),

employeeid,

FIRSTNAME,

LASTNAME,

EMAILADDRESS,

STARTDATE,

ACTIONORDER

FROM linkedServer.linkedDB.dbo.AUEMPLOYEE as employee

WHERE employee.ENDDATE IS...

astrid 69000 (3/26/2013)

---

yes i did, but i get confused, the "SELECT '2008-01-01 00:00:00.000', 3 UNION ALL" is not the one i need to add one by one manually?

the query...

D'Oh!

;WITH Employees AS (

SELECT rn = ROW_NUMBER() OVER(PARTITION BY employeeid ORDER BY ACTIONDATE DESC),

employeeid,

FIRSTNAME,

LASTNAME,

EMAILADDRESS,

STARTDATE

FROM linkedServer.linkedDB.dbo.AUEMPLOYEE

WHERE employee.ENDDATE IS NULL -- still active

)

SELECT

e.*,

org.ORGANIZATIONID,

job.JOBTITLEID

FROM...