|
You can do it with the help of Group By clause and count function.
Parwej Ahamad
g.parwez@gmail.com
|
|
|
|
|
by using group by clause and count function
never give correct format according the order of entry in table
no knowledge in .net
|
|
|
|
|
select count(amount) as appeartimes,[name]<br />
from tablename group by amount,[name]
I Love SQL
|
|
|
|
|
Mr blue boy
i want to display record in order as entry in table
like first time kamal pay 78 amount three time then pay 45 amount two time
in table
according entry order i want display record
kamal 78 3
kamal 45 2
such like that
ur quiry never give actual format like entry
no knowledge in .net
|
|
|
|
|
hope this helps
select name,count([amount]) as timeofpaid<br />
from tablename group by [name],amount order by name,timeofpaid
I Love SQL
|
|
|
|
|
i have a column of datatype string in the sql server 2000 database.
following is the data in that table
1
2
11
12
a
if i sort the data then output comes in the following manner
1
11
12
2
a
, but i want 1 2 11 12 a
to sort out this problem i thought to make two unioun queries
to fileter the numeric values and alphanumeric values.
no the questio is can somebody tell me how to filter the numeric and alphanumeric values .
Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.
|
|
|
|
|
Don't double post, it's rude.
|
|
|
|
|
i want to use the DateDiff() procedure of VB6.0 but iam getting Run-time error 5: Invalid Procedure call or Argument.i want to know the exact syntax of using DateDiff() procedure.
Thanx & Regards.
Success is not a Destination,
... But a Journey !!
|
|
|
|
|
If this is a VB6 method, using VB6 objects, then it's not really SQL, or am I misunderstanding you ?
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Sorry i didn't get you.
Thanx & Regards.
Success is not a Destination,
... But a Journey !!
|
|
|
|
|
He means - this is not a SQL question. It's a VB6 question - hence it shouldn't be in the SQL forum.
|
|
|
|
|
Try pressing F1 for help.
Also, VB6 is not a SQL question.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Ashfield wrote: Also, VB6 is not a SQL question
Nope. It is questionable though.
|
|
|
|
|
i don't have MSDN installed.
Thanx & Regards.
Success is not a Destination,
... But a Journey !!
|
|
|
|
|
Well try the granddaddy of all things, google!
To help, here's a link to vb6 functions
Visual Basic Command Syntax
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Thanx. Sure it is very helpful to me and for all the others who are beginners. Thanx.
Thanx & Regards.
Success is not a Destination,
... But a Journey !!
|
|
|
|
|
While trying to process multiple select statement and retreiving files from my database I get the following message:
"ContextSwitchDeadlock was detected
Message: The CLR has been unable to transition from COM context 0x271130
to COM context 0x2712a0 for 60 seconds. The thread that owns the destination
context/apartment is most likely either doing a non pumping wait or
processing a very long running operation without pumping Windows messages.
This situation generally has a negative performance impact and may even
lead to the application becoming non responsive or memory usage accumulating
continually over time. To avoid this problem, all single threaded apartment
(STA) threads should use pumping wait primitives (such as
CoWaitForMultipleHandles) and routinely pump messages during long running
operations."
How do I resolve this problem, I am using C# and SQL Server.
Thanks in advance,
Michael
|
|
|
|
|
The documentation for this can be found at http://msdn2.microsoft.com/en-us/library/ms172233.aspx[^]. It's a Managed Debugging Assistant, which is a component that is invoked by the .NET Framework Common Language Runtime (CLR) when debugging.
It's very unusual to get this message - I've never seen it in debugging .NET applications that work with databases. I believe it indicates that your UI thread was blocked for a long period of time. You should strongly consider moving any long-running queries to other threads.
All calls to COM objects that are marked Apartment thread model have to run on the thread which created them. This includes cleanup code. .NET's garbage collection model pushes anything that needs cleanup after garbage collection onto a finalization queue, which is read by a separate finalization thread. That finalization thread has to cause the thread that created the COM object to run the cleanup code. While it's blocked waiting for the original thread, other objects which require finalization just build up on the queue, because there is only one finalization thread in the process.
You should check that you're using the SqlConnection family of objects throughout and not trying to use OleDbConnection or use the classic ADO objects.
DoEvents: Generating unexpected recursion since 1991
|
|
|
|
|
Hi,
I need to have a Matix report which looks like :
...............|YEARS
--------------------------------
...............|Class1|Class2|Class3
Programme|StudNo|StudNo|StudNo
ie; The Matix will look like this
Programme|.......2001.................|........2002............|.
------------------------------------------------------------------------
..............|Class1|Class2|Class3|Class1|Class2|Class3|.....
IT...........|..23...|...24..|..45....|..12...|..23...|..12..|.....
MBA........|..34...|...12..|..12....|..31...|..13...|..14..|.....
I don't know how to split the YEARS' column into 3 different subcolumns which has got class1,class2,class3.Each year has got the 3 different staic classnames. Under that the no of students in each class comes. The students in each class in each year should be calculated based on some condition. Its not available directly from a dataset. Hope u can understand the matix.
PLEASE HELP!!! 
Thanks & regards,
Payal
modified on Thursday, March 6, 2008 8:38 PM
|
|
|
|
|
Your column groupings need to be Year and Class.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
The Class field has 3 static values Class1 Class2 Class3. If Class was a single dataset then only Year and class could be set as Column grouping.
Can u plz explain how to go about in the case where i have 3 different static values for the class?
Thanks
Payal
|
|
|
|
|
Thanks
I found out out how to go about it.
Payal
|
|
|
|
|
I have the following stored procedure (written in an "Execute SQL Task" in SSIS).
How do i get the value from @Error and set it to Global Variable in SSIS? The global variable name is "varError"
DECLARE @Error int
EXEC @Error = sp_delete_temp_people_import_tables
|
|
|
|
|
If you're using OLEDB
1) Set your string as
EXEC ? = sp_delete_temp_people_import_tables
2) In the Parameter mapping page, add a new parameter. Set the variable name to varError, Parameter Direction to "Output" and parameter name to "0"
If you're using ADO.NET
1) Just give your SP name in the SQLStatement box
2) Set IsQueryStoredProcedure to true
3) Add a new parameter. Set the variable name to varError, Parameter Direction to "Output" and parameter name to the name you've specified in the SP
Remember, if you're using ADO.NET, the SP must use an OUTPUT parameter and NOT a return value.
SG
Cause is effect concealed. Effect is cause revealed.
|
|
|
|
|
Im using OLEDB
Ive configured the properties as you said
Variable Name = User::intError
Direction = Output
Data Type = Long_Integer (global variable is expecting an int32)
Parameter Name = 0
but whe i run i get the following
##############################################
--Execute Stored procedure
EXEC ? = sp_delete_temp_people_import_tables
" failed with the following error: "Syntax error, permission violation, or other nonspecific error". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Task failed: Execute SQL Task
################################################
When i try parsing it before i ran the package i get the same error as above - "Syntax error, permission violation, or other nonspecific error".
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
