I am sure that your desired output makes perfect sense to you. Unfortunately we don't know your business rules and what you posted does not help clarify what you want....

I am not sure that your cursor actually works in all cases. When running it as is the values for ID 7 seems to be accurate. If you add a...

I still don't understand your desired output. The formatting from this site doesn't help either. 😉 You probably need to create a temp table with your desired output so we...

Take a look at the documentation for MERGE. http://msdn.microsoft.com/en-us/library/bb510625.aspx

Look closely at the OUTPUT clause. You should be able to utilize that for what you need.

Cool. Now if we can find out what the question is we can...

The script you posted should work assuming the values are within acceptable values for each datepart. As much as I hate to say this I think you may have to...

Your inserts do not work. There are more columns specified than values provided.

Also, what are you looking for as output based on this sample data?

To the OP - Hi and welcome to the forums. In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample...

That doesn't really capture what the OP is looking for....

Your case expression will handle any rows with a NULL but you obviously have some data in there somewhere that cannot be cast to a datetime. Maybe you need...

miles_lesperance (4/16/2014)

---

I am trying to take a field that has part of a date in it, so I have to parse it out as follows:

SUBSTRING(a1.Field1, 3, 2) + SUBSTRING(a1.Field1,5,2) +...

OK so let's pretend you are going to run this with the sample data you provided. You said the value for the parameter would be 25%. Given that value, what...

daniness (4/16/2014)

---

Hi Sean,

This is the query:

SELECT ISNULL(ath_stlmnt_instr_id, ae.stlmnt_line_instr_id) AS ath_instr_id

,ath_instr_id AS orig_instr_id

,ath_gl_num

,ath_cost_cntr

,CASE

WHEN ath_postype = 'GLD'

THEN sum(ath_usdamt)

WHEN ath_postype = 'GLC'

THEN sum(ath_usdamt) * - 1

END AS ath_usdamt

,count(*)

FROM dbo.ACCTING_TRANSACTION_HISTORY

left join Accting_body ae...

daniness (4/16/2014)

---

Hi Chris and everyone,

Thanks for the suggestion. However from what has been posted here earlier, the fields in both Group By sections need to match. I tried it, nonetheless,...

rash3554 (4/16/2014)

---

@SSChampion,

But how would I insert into employeeaddresses table? Can I have 2 table valued parameters as input to a procedure is my question? one to insert empaddr_verified using...