Sorry i was not very clear.

I am getting 12 AM TWICE if i try to use a case to change the 0 to 12.

the query i am using now is...

Hi,

Though i added another WHEN clause, i had a problem. I am still getting 0 AM.

Can anyone please help?

Ya i have added it!

Thanks 🙂

hi Lowell,

Thanks for your reply.

Hi ColdCoffee,

Thanks a lot for your reply. This works fantastically.

I had tried this in a much harder way. Thanks again!!!

Hi,

I had heard of Tableau. This seem to have features you are looking for. It helps mainly to generate dashboard out of your reports.

You can look for more information...

You can try this:

Right click on y-axis. ---> vertical axis properties ----> Number

here you change number type as percentage and set decimal places to 0.

this gives you % values on...

Thanks for the reply.

i have 5 such columns. 4 are of type int and one is a varchar column.

now after adding them we will have to filter out the...

Thanks for all your replies.

@Cold coffee,

i am thinking of moving these groups into a temp table. how about this?

if this is not wrong , then how to proceed on...

Hi All,

Thanks for the reply.

What am i trying to do here is to make groups based on names. Currently it is done using case like:

case when name like 'Microsoft...

Hi All,

I think i was not very clear. I am facing this problem in the dataset.

the standalone proc when executed works fine for #temp too.

One thing i found was, when...

hi kingston,

Thanks for the reply. I tried this but i am getting this error:

"Aggregates on the right side of an APPLY cannot reference columns from the left side."

Hi,

Thanks for the reply.

I need to check who is using the latest version of the application.

so, in the function i am returning the version name and i will be...

Hi all,

thanks for all your replies. Yes as you said, the tbl3.world was not correct.

m working on it. i will surely get back to you once i am done.

hi,

thanks for reply. could you please tell me how can i write a query to get that?

or is there any other way to get the weeks?

my time column in...