I dont understand......you previously asked for this

1188 Ali Ahmadi BaseSalary 1213232323 ExtraSalary 54585 SpecialSalary 245832

1245 ahmad Alipour...

I am going to have a guess...as a starter

is the following anywhere close?

WITH cdets as (

SELECT Countryid, country, stateid, states

FROM countrydetails

WHERE ...

ok...lets tidy this up a bit for you

CREATE TABLE countrydetails(

Countryid INT

,country VARCHAR(20)

,stateid INT

,states ...

elham_azizi_62 (9/30/2015)

---

but Now need this out put:

1188 Ali Ahmadi BaseSalary 1213232323 ExtraSalary 54585 SpecialSalary 245832

1245 ahmad Alipour ExtraSalary 2526961

1478 sara Emami BaseSalary 548745

I mean when a column...

-- you say you have a remote server, and lookin back thro the various code

-- you have sent me I am not sure which is/is not relevant

-- therefore please insert...

Jeff...my sincere condolences....My Dad passed away a few years back after a long struggle with cancer...it aint easy my friend.

glad to hear you are going to writing again and look...

Hi Jeff.....did you ever do "part 3"

"Coming up in Part 3, random names, characters, codes, and SSNs."

best wishes

yeah..I did....several

busy at the moment....if I get a chance I may take a look...

I strongly suggest that you fully research this and understand what is and is not possible for...

have a play......maybe help / may not

DECLARE @yourdate datetime;

SET @yourdate = '20150620';

SELECT

CASE

WHEN DATEPART(M , @yourdate) >= 7 THEN DateFromParts(YEAR(@yourdate) , 7 , 1)

...

USE tempdb

GO

-- create a test proc in tempdb

CREATE PROCEDURE usptest

AS

SELECT * FROM #temp

GO

-- following code will not remove proc from SSMS

-- but does prevent it showing in the "obvious" list...

are you telling me that there is no one else in your "business" that...

I assume you have heard the phrase "give a man a fish........"

not sure where you did your research....but https://msdn.microsoft.com/en-GB/library/ms175972.aspx explains it reasonly well

you will need to declare your variables

When a CTE is used in a statement that is part of...

rkelly58 (9/25/2015)

---

Had a go at combing my scripts into the code, but no luck, here is what I tried:

SELECT MachineLocations.CampusID, MachineLocations.Campus, MachineLocations.BuildingID,...