hi
check this to know about PIVOT
kabilahan
Last Activity: May 19 '14, 03:19 PM
Joined: May 3 '07
Location:
-
hi..
convert the date and store it...
example
just run this
select convert(varchar (10),getdate(), 106)
output
10 Feb 201Leave a comment:
-
am having a table with 7 Rows and 12 Columns...this table contains those textboxes. My requirement is, when the user enters all the values and clicks a button the textbox value should store in a 2d array.....Leave a comment:
-
am very sorry...my questino is wrong...
actually i ve 82 textboxes...i want to store the datas into a two dimension arrray
how to do this?...Leave a comment:
-
GRIDVIEW
how to store gridview values in a two dimesion array
am having a gridview like this
[code=html]
<asp:GridView ID="GridView1" runat="server" AutoGenerateCol umns="False" Width="150px">
<Columns>
<asp:TemplateFi eld HeaderText="tes t1">
<ItemTemplate >
... -
Its working ...i changed the column name........... ..
try this..
select * from(
select x1=t2.col2,x2=t 1.col2
from table_1 t1
join table_2 t2
on t1.col1 = t2.col1
) y
pivot(count(x2) for [x2] in (d,w))as teLeave a comment:
-
Its working ...i changed the column name........... ..
try this..
select * from(
select c1=t2.col2,c2=t 1.col2
from table_1 t1
join table_2 t2
on t1.col1 = t2.col1
) y
pivot(count(c2) for [c2] in (d,w))as teLeave a comment:
-
hi try this...
select * from(
select col1=t2.col2,co l2=t1.col2
from table_1 t1
join table_2 t2
on t1.col1 = t2.col1
) y
pivot(count(col 2) for [col2] in (d,w))as te
output is:
-------------
col1 D W
name1 2 1
name2 1 2
name3 1 1
name4 0 1
name5 1 0Leave a comment:
-
1.right click on any database
2.select TASKS and then select IMPORT DATA after clicking
this one dialog box will appear,click NEXT
3.Choose MICROSOFT ACCESS as DATA SOURCE,then BROWSE ur access file then click NEXT
4.Chosse the DESTINATION[SQL native client]
5.Select the SERVERNAME
6.There are two AUTHENTICATION, select the SQL SERVER AUTHENTICATION and give the USERNAME & PASSWORE
7.Select...Leave a comment:
-
hi try this
select convert(varchar ,getdate(),1)Leave a comment:
-
SELECT distinct a.Promo,b.Ban,b .[Ban Status],
b.[BAn Statys Reson Code],b.[Last Ban Status Date] INTO NEW_TABLE_NAME
FROM PC_FUSION_07042 4 a
LEFT OUTER JOIN ARCL05_070423 b
ON a.BAN = b.BAN
WHERE b.BAN is not null
TRY THIS...Leave a comment:
-
select * into NEW TABLE NAME from OLD TABLE NAME--
THIS IS THE SYTAX..YOU CAN USE THIS FOR UR NEEDLeave a comment:
-
hi..
my adivice is dont use excel, create a MS-Access data base and import that into sql..Leave a comment:
-
No activity results to display
Leave a comment: