I would suggest putting that type of formatting in your bar graph instead of in your sql. Formatting in the front end is best so you can maintain your dates...

Let's start with formatting this so we can see what is going on.

DECLARE childcur_inventory CURSOR

FOR

SELECT Structure_Number

,STATE

,Neighbor_State

,Border_Bridge_Structure_Number

FROM #InventoryItems

OPEN childcur_inventory

FETCH childcur_inventory

INTO @Structure_Number

,@State

,@Neighbour_State

,@Border_Bridge_Structure_Number

WHILE @@FETCH_STATUS = 0

BEGIN ---@@FETCH_STATUS = 0

IF @Neighbour_State = 'CN'

OR @Neighbour_State...

Run your code again, but before you do uncomment this line.

--select...

Marv2011 (5/8/2015)

---

Its for research purposes. The table that I am analyzing is a back end table of a front end clinical survey. A null value means that question was skipped...

Marv2011 (5/8/2015)

---

Thanks for this!

I sometimes work with large data sets where my tables have over 100 columns. Is there an easier way of doing this instead of 100 case statements?...

COALESCE is just another function and is not at all relevant here. Not sure how a...

GG_BI_GG (5/7/2015)

---

Tnx for the quick responds.

Ye it still dont work.. I think Alvin's recommendation makes my qeury not quicker..

Is there a better way to make my query syntax, on which...

Lynn Pettis (5/7/2015)

---

Sean Lange (5/7/2015)

---

Lynn Pettis (5/7/2015)

---

Sean Lange (5/7/2015)

---

The problem is for the...

Lynn Pettis (5/7/2015)

---

Sean Lange (5/7/2015)

---

The problem is for the first join they want...

The problem is for the first join they want the first character. For...

GG_BI_GG (5/7/2015)

---

I like to DISTINCT my column facc_bkey but that take a lot of time. This is very, very slow 🙁

Select DISTINCT CAST(a.DATAAREAID AS NVARCHAR(4)) + '_' + CAST(a.ACCOUNTNUM AS...

I was about to post my version but Lynn beat me to it. On second thought, I will post my version anyway. It is a very different approach from his...

What have you tried?

KGJ-Dev (5/7/2015)

---

Hi,

I have column called DateDesc and the values are "Start JAN","END MAY", "Mid JUNE". Like this i have for all the months of the year.

I needed to convert this...

nick.latocha (5/7/2015)

---

This was my prototype:

create table #items (itemID varchar(10), statusID int)

create table #statuses (statusName varchar(50), statusID int)

insert into #items values ('Item 1',1|2|8)

insert into #items values ('Item 2',1|4)

select * from #items

insert...