pchaitanya
Last Activity: Apr 10 '09, 07:17 AM
Joined: Feb 26 '08
Location:
-
When there are more than one column then by using simple pivot function we can do this. I am blocked as I have only one column in my table -
Pivots
I have only one column in my table.
Now i need to convert column data as column headers using pivot
plz help -
hi
thank u,
But by using pivot we cannot send name of column dynamically na !Leave a comment:
-
conversion from varchar
I have a column named entrydate in my table as datatype varchar as following
mm/dd/yyyy . How can I convert the column to datetime format..
I tried the following but i got an error
select convert(datetim e,entrydate,1) from timeentry
I got the following error
::Conversion failed when converting datetime from character string. -
Cursors
Hi all,
How can we transform column data as column headers using cursors... -
pivot
Hi all,
My doubt is can we give input to pivot dynamically means columns that are to be transformed at run time -
Thank u,
In case of using pivot we should initially declare the required item or column .
How can we read column dynamically at run timeLeave a comment:
-
columns operation
Hi all,
Is there any way so that I can get data in a column as column headers for that table -
creating a table
hi,
I am creating a temporary table..
My aim is I have a table namely Emp with columns ID,Name
on Select name from emp
I wil get list of names
Now I want those names as column headers for temporary table
How can I do this -
retriving data to datagrid
hi all,
suppose in a table if i have columns namely name,entrydate
now on retriving and binding to a gridview how can I get names rowwise and entrydate columnwise on a gridview
on Xaxis I want entrydate and yaxis names
in following format
-----------------------------------------------------------------------------------
XXXXX | entrydate1 | entrydate2... -
Gridview
Hi,
I am totally new to this environment.
I am using a gridview in my page that retrives data from database
When I retrive i no of rows is increases/decreases based on query
now I want data in rows as column headers
let me explain
on retriving I get the grid as below
Id name date timein timeout
1 ... -
how to find first day among given dates
I have selected some list of valid dates to a label.
now i need to find first day among the given dates from label contrl
i got dates from calender control by clicking for entire week..
that is i have dates from sunday to saturday and I have to find which date is sunday...... -
How to Store information in textbox to sqlserver
hai..
I have created a textbox at runtime.
using
textbox t=new textbox();
page.form.contr ols.add(t);
1)I am getting textbox at left top of the page.
How to Change Position of textbox.
2)How to insert text in textbox to database on button click.
No activity results to display
Leave a comment: