I have a table which contains ID and Email col.
The data is stored as follows:
ID Email
---------------
1 A
2 A0
2 A1
3 A2
3 A3
3 A4
4 A5
I want to show the value as
ID Email1 Email2 Email3
1 A
2 A1 A0
3 A2 A3 A4
4 A5
Is there any way possible to do this
anuragshrivastava64
Last Activity: Sep 23 '10, 07:08 AM
Joined: Jan 16 '07
Location:
-
Transpose a query result
-
Loop through all databases
Hi,
I have to run a script that fetches some value (say Column1) from a particulat table (say Table 1) from all the databases in SQL Server.
Is there any way i can parameterize (USE 'DATABSENAME') Command.
Can I use something like
Declare @StudyName char(20)
Set @StudyName ='Master'
Use '@StudyName'
Please let me know any solution -
just out of curiosity.
I mean number of rows affected after a transaction should not be shown(as we do in SQL)
Anyways is it SET FEEDBACK ON/OFF... -
Set Nocount On/OFF equivalent in Oracle
Can anyone plz tell Set NoCount on equivalent in Oracle.
I have used it only in SQL -
Find hidden triggers in database
I am new to SQL Server.
I have got a project where lot of stored procedures ,UDF's and triggers are used.
The problem is I am finding all the functions and procedures but not been able to find any of the TRIGGERS.
Can anyone plz tell me where can I find the triggers.
I used the query (Select * from Sysobjects) and it shows 52 triggers -
I am afraid I can't help u thru the whole exception handler methodology in VB.
Anyways what u can do is to create a new exception handler and may be write the following
ExceptionHandle r:
If Err.Number =13
MsgBox "Please enter the number correctly"
End if
If anything else u want to know please feel free to ask.Leave a comment:
-
can u elaborate it a little furtherLeave a comment:
-
Then u can simply check whetetehr the text enterd is numeric or not thru ISNumeric function
Just copy the following spurce of code before u chek
If Not IsNumeric(Me.Te xt1) Then
MsgBox "Sorry wrong entry"
Text1= ""
Text1.setfocus
Else
aNumberbox = CheckData(Me.Te xt1)
End If...Leave a comment:
-
Sorry but can't get what u want exactly
anyways a dirty solution is here
Sub Command0_Click( )
Dim aNumber As Double
On Error GoTo ErrorHandle
aNumber = CDbl(Me.Text1)
ExitHere:
MsgBox ("You entered the number " & aNumber)
MsgBox ("Why not try it again?")
Me.Text1.SetFoc us
Exit Sub
ErrorHandle:
MsgBox...Leave a comment:
-
Why don't u can create a timer and in the Timer Event write ur codeLeave a comment:
-
Make a control array of Text boxes.
and increment allLeave a comment:
-
change order of loop
may be changing the for loop works
Try this
For iSheet = iSheetCount To 16 Step -1
Worksheets(iShe et).Delete
Next iSheetLeave a comment:
-
U will have to create Active X Control for that.
Try downloading someLeave a comment:
-
In Form Load event give Label.Visible = False
And Button_Click event give Label.Visible =TrueLeave a comment:
-
http://www.vbexplorer. com/VBExplorer/tips/src26.asp
May be this will help youLeave a comment:
-
Check this
http://www.daniweb.com/forums/thread79688.htm lLeave a comment:
-
May be u can try this.
DOesn work fully
Private Declare Function SendMessage Lib "User32" _
Alias "SendMessag eA" (ByVal hWnd As Long, ByVal wMsg As Long, _
ByVal wParam As Long, lParam As Long) As Long
Private Sub cmbType_GotFocu s()
Dim lRet As Long
lRet = SendMessage(cmb Type.hWnd, &H14F, 1, ByVal 0&)
End SubLeave a comment:
-
May be you are trying to copy a database that is opened.
Close the connection to that database and then copy....Leave a comment:
-
No actually we are makin an application in two modes Advanced and Standard.
In advanced version it can be used across network i.e Multi User.
But in standard version it has to be single user only.
The exe will be on server only. Other users will log on to server and use that exeLeave a comment:
No activity results to display
Leave a comment: