You're welcome. 😀

jeremy.bruker (11/26/2012)

---

Well basically I wanted it to return all the license for the state. Then only tell me how many actual pilots I have in those states. ...

freecoder (11/26/2012)

---

CREATE TABLE #holding(

[TIDM] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[CLIENTCODE] int NULL ,

) ON [PRIMARY]

INSERT #holding

(TIDM,CLIENTCODE)

values ('ABC',1234),

('BCD',1234),

('BCD',1234),

('LMF',1234),

('DEC',1234),

('ADE',1234),

('LGJ',1234),

('PCD',1234),

('ABC',1234)

so i want a list of clientcode who dont hold a particular...

There is not a NOW function in sql server. You can instead use SYSDATETIME() or GETDATE().

Something along these lines.

SELECT Base_State, SUM(case when type = 'PP' then 1 else 0 end) as PP,

SUM(Case when type = 'JP' then 1 else 0 end) as JP

FROM #UserMain a

left...

Glad you found a way to make it work. I had a very different idea in my head about how to do this which I think would be far simpler....

You are welcome. Hope something in there works for you.

Agreed.

You could maybe tweak it slightly to avoid being forced to create your alter code as dynamic sql. Just have your template generate a placeholder proc and then always alter...

I don't want to get an argument over this but it is not that I don't have an answer....

Oh my bad...i think my brain has already decided to call it quits this week. You are replicating the proc. As you have likely discovered you can't quite do what...

pamozer (11/21/2012)

---

I am trying to create a template for our developers for stored procedures. I want the logic to be the following:

If Exists(Select * from sys.objects where name='sproc')

Alter Procedure...

John Esraelo-498130 (11/21/2012)

---

would pivot be able to do the following?

_JobNum_JobName _DivName _PMNames_HrsUsed_DollUsed_JobCost

12680Mission BeachKing County Johnnie ...

Hi and welcome to SSC. It is certainly possible to do this. Unfortunately we need some more details to be able to provide much help. We need ddl (create table...

richard.noordam (11/21/2012)

---

I have a dataset that i need to iterate thru in a row wise manner where each row has columns that will either be filled with a value or...

briancampbellmcad (11/21/2012)

---

Thanks... your idea worked of thr UNION All and one trigger!.... my misstake was I has not deleted my original query which was still firing producing that dupe record.......