|
hi
i have following query which works in sqlserver 2005 but same query shows the error in my sql is there any other syntax plz help
i working on pivote table and qury run in sql2005 but not in mysql why?
create view myview as
select * from dbo.master1
pivot
(
count(EmpName)
for EmpSubGrp in
(EG3 ,TM5 ,TMA ,TMC ,TM1 ,TM2 ,OP6 ,OP7 ,TMB )
) as p
|
|
|
|
|
Because standard SQL is not enough, and every DB has it's own extensions. This is a SQL question, we have a SQL forum.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
this can be deleted I figured it out.
modified on Saturday, April 4, 2009 1:01 AM
|
|
|
|
|
Hi,
if something goes wrong with TextBox.Lines then read the documentation about TextBox.Lines!
Luc Pattyn [Forum Guidelines] [My Articles]
- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets
|
|
|
|
|
well where would that be?
|
|
|
|
|
The documentation on RichEdit from Microsoft can be found here[^].
I'm sorry that I can't help you any further, but it seems to be that someone has deleted the original question
I are troll
|
|
|
|
|
Hi.
How can I create something like this with String Formats :
1
2
3
.
.
.
10
11
12
.
.
.
99
100
101
102
.
.
.
1000
1001
1002
Actually , I wanna insert three spaces characters before a digit , like above.
Could you guide me ?
Thanks
|
|
|
|
|
for (int ii = 0; ii < 1200; ii=ii+25)
Console.WriteLine("{0,4}", ii);
see string formatting[^]
Yusuf
Oh didn't you notice, analogous to square roots, they recently introduced rectangular, circular, and diamond roots to determine the size of the corresponding shapes when given the area. Luc Pattyn[^]
|
|
|
|
|
Great , thank you.
I was using Console.WriteLine("{1,4}", ii); , and it throws an exception
|
|
|
|
|
Mohammad Dayyan wrote: I was using Console.WriteLine("{1,4}", ii);, and it throws an exception
of course, index is zero based.
Yusuf
Oh didn't you notice, analogous to square roots, they recently introduced rectangular, circular, and diamond roots to determine the size of the corresponding shapes when given the area. Luc Pattyn[^]
|
|
|
|
|
Hi...
Im using the MSFlexiGrid library in a C#.Net Project. Im using a FlexiGrid control. Until yesterdey, everything seemed to work fine but now I have an error when I try to see a form which has the flexigrid control.
<br />
Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG))<br />
I can't compile anything either and looking for this error in google, I found that I need to register something with/in the ATL.dll library, which is part of Windows System.
I know that I could use the DataGrid control but I would like to know why this dont work if this was working without problems.
I don't have a clue of what to do. Any help would be apreciated and excuse me about my English if I made a mistake.
Ivan
|
|
|
|
|
Why would you use the flexgrid ? Not registered means it's not registered with COM, I would expect.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
Check your refrences and Component of MSFlexigrid is exist. then add refrences and Component of MSFlexigrid.
Best Regard
Anubhava Dimri
mailto: anubhava.prodata@gmail.com
|
|
|
|
|
How does one regenerate a form?
I had a form up and running, did a save and then nothing. The form reapeared with no controls on it. I checked the Code view and all the code was there. I checked the form.designer.cs, all the descriptors for all the boxes, control, and everything else were there. So why isn't being seen. This is the second this has happened.
I dont want to recreate the whole project.
How can I "turn on" or recreate this form?
I'm using VS2005 Standard
Thanks
|
|
|
|
|
Check the constructor of your form, it should contain a call to InitializeComponent(); .
I are troll
|
|
|
|
|
Lecutus1 wrote: I dont want to recreate the whole project.
Get the version of the form immediately prior to your latest change from source control.
You are using source control. Right?
Today's lesson is brought to you by the word "niggardly". Remember kids, don't attribute to racism what can be explained by Scandinavian language roots.
-- Robert Royall
|
|
|
|
|
hi all
i can't figure out the difference between
urlIdentityPermission and SiteIdentityPermission
they both point to a site url
|
|
|
|
|
Hello Everyone,
I really need help from all of you and that too as soon as possible
My requirement goes like this
1. I am supposed to display live video using two different cameras placed at two different Angles with one camera ON at a time of instance(both cameras attached to a single pc)
Earlier I had displayed live video in a panel control using Avermedia capture card and a camera attached to it using the sdk provided with the Avermedia capture card
I am thinking of using Two capture cards with two cameras now but i am facing with a problem of how to detect the two capture cards and close one camera and start another camera at a click of a button
i have been searching net for help but was not succesful .
i am new to this and.
Any sort of help or reference would be really beneficial from me to proceed ahead with the requiremnet
System Details:
O/S Winxp withservice pack 2
coding Language C#
Framework used 2.0
Ide Vs2005
Capture card Avermedia Ezcapture
|
|
|
|
|
Hi,
i m having a project related to Avermedia capture card and a camera. I must capture image by those devices but i don't know how to capture a image by using c# language
U can help me !
thanks
|
|
|
|
|
Is there a way to display a treeview with the root on bottom?
|
|
|
|
|
Yes and no, it depends on how much effort you're willing to put into it. There's not a toggle that you can switch, but you can extend a treeview to suit your own needs. That would be done through owner-drawing[^].
It might be that one of the prebuilt-trees out there support an upside-down view
--edit--
I doubt that owner-drawing let's you change the position of the item. Another option would be a Panel where you add UserControl s as childitems with the docking set to the bottom of the control. Scrollbars should appear when the items grow beyond the size of the panel.
I are troll
modified on Friday, April 3, 2009 3:14 PM
|
|
|
|
|
|
|
I am working on a small project in which i need to get the info about other users that i would like to see the profile of who come under the criteria i want.
so lets say i want come one slim and from height 5-6 and between the age of 18 21.. i have the xml file of people.. so should i convert xml into array first and then do something with it.. or should i find the stuff i need take it out of xml and then put it in the array and then show it out.. either way how can i do it good and best without alot of headache.. thanks alot
<Clients>
<Username>Username</Username>
<Password>Password</Password>
<Alias>MyAlias</Alias>
<BodyType>Athletic</BodyType>
<Height>5</Height>
<DisplayHeight>5'9''</DisplayHeight>
<Age>19</Age>
<Gender>Male</Gender>
<Income>$45,000 to $ 60,000</Income>
<CriteriaBodyType>Slim / Selender</CriteriaBodyType>
<CriteriaHeightfrom>5</CriteriaHeightfrom>
<CriteriaHeightto>6</CriteriaHeightto>
<CriteriaAgesfrom>18</CriteriaAgesfrom>
<CriteriaAgesto>20</CriteriaAgesto>
</Clients>
<Clients>
<Username>User2</Username>
<Password>sheepy</Password>
<Alias>TJ</Alias>
<BodyType>Athletic</BodyType>
<Height>5</Height>
<DisplayHeight>5'9''</DisplayHeight>
<Age>20</Age>
<Gender>Male</Gender>
<Income>$45,000 to $ 60,000</Income>
<CriteriaBodyType>Slim / Selender</CriteriaBodyType>
<CriteriaHeightfrom>5</CriteriaHeightfrom>
<CriteriaHeightto>6</CriteriaHeightto>
<CriteriaAgesfrom>18</CriteriaAgesfrom>
<CriteriaAgesto>20</CriteriaAgesto>
</Clients>
<Clients>
<Username>Claudia</Username>
<Password>pass</Password>
<Alias>ALIASCLAUDIA</Alias>
<BodyType>Body Builder</BodyType>
<Height>5</Height>
<DisplayHeight>5'</DisplayHeight>
<Age>20</Age>
<Gender>Female</Gender>
<Income>$30,000 to $45,000</Income>
<CriteriaBodyType>Some Extra Baggage</CriteriaBodyType>
<CriteriaHeightfrom>5</CriteriaHeightfrom>
<CriteriaHeightto>5</CriteriaHeightto>
<CriteriaAgesfrom>18</CriteriaAgesfrom>
<CriteriaAgesto>25</CriteriaAgesto>
</Clients>
</ClientData>
|
|
|
|
|
faizych wrote: so lets say i want come one slim
You want "come one slim"? Really? You think we know what that means?
faizych wrote: how can i do it good and best without alot of headache
That depends on what all that means. If it means no headache for you because someone here does it for you then good luck, not me. I help people that do the work themselves. Part of doing the work of software development is learning the technologies you need to use so that you can understand how they work. The reason we want to know how they work is because when we know that, we know how to proceed with our work using them. See how that all comes together?
|
|
|
|