I have pivot table column that has null values in some instances from top to bottom. To get rid the nuisance how can I hide this automatically? Do I need to use vba? Your help would be much appreciated.
Thank you!...
ddtpmyra
Joined: Jun 12 '08
Location:
-
how to hide columns in PIVOT table
-
Error 400
I have this drop down menu all is fine but when i keep on shifting from different selection I got stuck with error 200
heres the SCENARIO>>>>>>
drop down menu choices are:
all fruits
orange
plum
ERROR HAPPENS WHEN I DO THIS>>>>
after one round of selection
from all fruits
then, oranges,
then plum ,
then back to all fruits... -
You are awesome NeoPa and Rabbit! It works thank you soooo much for your help! -
i can see the cedill in right format when stored on temporary table this is good! But every time I export it to a .dat file it looks like this...
€
I wonder if the cause of these is because how i called it on my BCP
Code:SELECT @SQL='BCP Test_File OUT '+@FILENAME+' -c -t -T -S '+@@SERVERNAME
Leave a comment:
-
Sorry I dont know how to do that. Can you show me how like an example?
thank you....Leave a comment:
-
@NeoPa:
When I select the temp table inside SQL it is in Cedill form but everytime I export it to a .dat file it's different €.
I wonder if I'm using the correct BCP format (below) any other suggestions?
Code:SELECT @SQL='BCP testfile OUT '+@FILENAME+' -c -t -T -r '+@@SERVERNAME
Last edited by NeoPa; Nov 29 '12, 03:43 AM. Reason: [CODE] tags are mandatory. Please don't forget to use them in future.Leave a comment:
-
@NeoPa:
It interprets it as a '€' char.
@Rabbit:
Can you give me an example of a select that will use U+00C7?Last edited by NeoPa; Nov 29 '12, 03:41 AM. Reason: Replying to each post needn't (shouldn't) require a separate post for each. Merged.Leave a comment:
-
C-cedilla -- Special Character
I declare to a variable equivaclent to cedil
but everytime I export it it's giving me different char. Is there's a way to write U+00C7 which is equivalent to cedill? You help will be much appreciated.Code:DECLARE @TAB CHAR(1)=char(199)
thank you. -
How to delete carriage return using batch file
I found this script and it's working perfectly fine it just that it can only process less file 8KB and I have bigger than that 49kb. Anybody who can help me to resolve this problem?
sample data
apple banana mango
apple banana mango
apple banana mango
output data desired
apple banana mango apple banana mango apple banana mango
...Code:@echo off > newfile setLocal
-
OR....
Code:Select UPPER(LEFT(name+space(25),25))
Leave a comment:
-
I thought of this…
Adding 25 blank space at the end of the last_name and only select the 25 char from the left.
Code:Select UPPER(LEFT(name+' ',25))
Leave a comment:
-
How to add characters exactly 25
Here's my case...
I need to allocate exact 25 characters on a field. For instance the name is Lucy this means I have to add 21 extra spaces at the end.
How can I do that on my select statement?
Code:select name,25-LEN(name) as difference, case when 25-LEN(name)<25 then ?????????? else ???????? end len from person
-
How to tell last char is not int
We are working on members id, and we wanted to have a standard naming convention.
For instance:
Members ID with charter at last will be keep the way it is.... while members id with number must update.
Example:
A123B --->keep the way it is.
C456D7 ---> 7 should be deleted.
How can we script it in a query this condition?
Thanks for your help! -
sftp batch file
Here's my script and it's still prompting me to enter the password. Is there other way to push the password without the prompt and do it automatically? Help!
Code:sftp abc@xx.xxx.x.xx echo mypassword put c:\test.txt quit
-
thanks Rabbit, what I found there's another procedure that runs that using the same table name.Leave a comment:
-
SQL error 2714
I have job scheduler inside the MS SQL the job sometimes and sometimes fail. How can I avoid this?
ERROR MSG:
There is object name 'run_job' in the database. SQL STATE: 42S01 ERROR 2714. -
HHSS calculation
We have appointment table that date and time are separated, and these are all in varchar types.
ex.
---------------------
|appt_date |begintime|
|20120405 |0755 |
|20120415 |1345 |
----------------------
How can I select and calculate the begintime minus 15minutes? -
select max
my clause is like this (below)...
what I'm trying to do is to select the most current patient appointment.
...Code:from person per left join patient p on p.person_id =per.person_id left join person_payer payer on payer.person_id=per.person_id and payer.def_cob =1 left join person_ud pud on pud.person_id =per.Person_id left join mstr_lists ml on ml.mstr_list_item_id =pud.ud_demo3_id left
-
Case statement insde where clause
I'm trying to add my case statment inside the condition but I think I'm not doing this right. I want to run a list of orders based on current date.
Let say if current date is monday I want to run the added orders made from friday 3pm.
And if current date is tuesday then I want to run the orders added yesterday from 3pm.
Having this condition all I have to do is to play with the getdate and dateadd. ... -
Nested Query
Hello,
I dont know how to write this thought to a query statement but heres the idea.
I have list of orders of customer, now I want a flag that will tell me this is a first time order.
...Code:[U]Table_Customer[/U] Name Address customer 1 454 B St. Brooklyn customer 2 454 Hyde St. San Francisco customer 3 445 Way Ln Michigan [U]table_history_order[/U] Name
No activity results to display
Leave a comment: