|
PATINDEX function returns the starting position of the pattern within the string being searched.
I don't think this is neccessary...
Regards
John
|
|
|
|
|
Patindex is used to check whether the given 'id' is in products table.
Then Use the same input id to query the productstate table to know the statename accordingly.
Thanks!
Santhosh Kumar Edukulla
|
|
|
|
|
I have a requirement to mark duplicate records when I pull them from the database.
However, I only want to mark the 2nd, 3rd, 4th etc record - not the first one.
The code I have below creates a column called Dupes but marks all the duplicates - including the first one.
Is there a way to only mark the 2nd, 3rd, 4th etc record ?
SELECT *, cs.CallStatusDescription as CSRStatusDesc, cs2.CallStatusDescription as CustomerStatusDesc, (Select MAX(CallAttemptNumber)From CallResults cr Where cl.Id = cr.CallLogId) as CallAttemptNumber,
Dupes = (select count(id)
from CallLogs
where (CustomerHomePhone != '' AND cl.CustomerHomePhone = CustomerHomePhone)
OR (CustomerBusinessPhone != '' AND cl.CustomerBusinessPhone = CustomerBusinessPhone)
AND DealerId= 'hdsh'
AND CSRStatus IS NULL
and datediff(d, logdate, getdate()) <= 21),
FROM CallLogs cl
left Join CallStatus cs on cs.Id = cl.CSRstatus
left Join CallStatus cs2 on cs2.Id = cl.Customerstatus
Where SaleStage IN ('1', '2', '3', '4', '5', '6') And (LogProcessFlag = 1 Or LogProcessFlag = 0)
And DealerId='hdsh'
And Logdate Between '08/01/2007' And '08/31/2007'
|
|
|
|
|
id<=c1.id
add one more condition (id<=c1.id) to the subquery which Dupes column will generate a sequence num for the subsequent duplicate records. All Dupes with value (1) should be considered as first occurance and rest Dupes value with 2, 3, 4... are 2,3,4... occurances
Not sure. just check
Regards
John
|
|
|
|
|
I have a reporting Database, which contains monthly metrics, now i want to develop a page in Sharepoint portal, which pulls all records from this reporting database..
Now in Sharepoint portal, User should be able to enter reason for not meeting expectations for that month...
Any suggestions abt how to develop this project would be greatly appreciated.
Sudhie
|
|
|
|
|
I don't know if this is the right section to ask this question
but if someone have some idea i appriciate his help
when i do the wizard step to do the replication this error always occur:
The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "REPLLINK_TELECOPLUS519346055_DATETIMEDA579057684_PUB5-1837106822_EMPTYFORRE236221469" was unable to begin a distributed transaction.<br />
Changed database context to 'emptyForRep'.<br />
OLE DB provider "SQLNCLI" for linked server "REPLLINK_TELECOPLUS519346055_DATETIMEDA579057684_PUB5-1837106822_EMPTYFORRE236221469" returned message "The partner transaction manager has disabled its support for remote/network transactions.". (Microsoft SQL Server, Error: 7391)
Thanks a lot
Assaf
|
|
|
|
|
Hi,
very hard to tell what's going on but can you check if you have a DTC (distributed Transaction Coordinator) enabled on both sides and that both of them can see each other (no firewall in between on ports 4000-4005 and 5000 I think). Microsoft has published some tool called DTCping which can help you proving that DTC works properly on both sides.
|
|
|
|
|
Is there a way to string together a value that is returned by a query wihtout writing function or PLSQL?
Table Def:
ky_remarks
no_remarks_seq
tx_remarks_generic
For instance
select tx_remarks_generic from remarks<br />
where ky_remarks = 232323324<br />
and no_remarks_seq > 0
no_remarks_seq = numeric and allows for multipule lines of remarks.
How can I string all the remarks for that key together in my SQL?
Thanks
Tom
Tom Wright
tawright915@gmail.com
|
|
|
|
|
Tom Wright wrote: Is there a way to string together a value that is returned by a query
well if your talking abt concatinating then in SQL Server u can use the + operator and in ORacle u can use the || operator to concatinate strings
Tom Wright wrote: Tom Wright
tawright915@gmail.c
giving your email likethis is an open invitation for spamers to attack your email!!!
Rocky
You can't climb up a ladder with your hands in your pockets.
|
|
|
|
|
here is the question:
I want to completely remove t-sql code to oracle code in the project.
For the following code :
SqlCommand cmd = new SqlCommand( m_sqlDeactivateApplication, Connection, Transaction );
cmd.CommandTimeout = 45;
cmd.Parameters.Add( "@ApplicationID", SqlDbType.Int ).Value = AppID;
cmd.Parameters.Add( "@ApplicationProfileID", SqlDbType.Int ).Value = appProfile.ApplicationProfileID;
cmd.Parameters.Add( "@LenderID", SqlDbType.SmallInt ).Value = app.LenderID;
cmd.Parameters.Add( "@NewProductID", SqlDbType.SmallInt ).Value = app.ProductID;
:(what should i do to make it work in pl/sql.
your valuable feedback is appreciated.
thanks,
haseeb
|
|
|
|
|
You will need to change your providor form SQL server to oracle. Your currently using the SQL providor (when you declare a SQLCommand and use SQLDBType you are using the SQL Server specific constants etc. Change to either OLEDB (generic) or better to the oracle providor.
|
|
|
|
|
i have a database of lists of subjects...then in my module, i want to display all the subjects that i recorded in the listbox...
how can i do it? i already connect my dataset in the connection wizard but i can't display it in the listbox.
|
|
|
|
|
if your simply displayin the values of a single column of a DataTable then just make a new bindingSource and fill it with the tableAdapter. Give the bindingSource Name as its DataSource and specify its valueColumn n Display Values from the properties pane if you like.
Thanks
Rocky
You can't climb up a ladder with your hands in your pockets.
|
|
|
|
|
How can i do it? will i make codes for that or will i just set the databindings in the properties of the listbbox?
|
|
|
|
|
ms-help:
chk this address in your MSDN 2005. and whenever u ask questions such as this always specify your application like C# 1.1,2.0, SQL Server 2000 or whatever
Rocky
You can't climb up a ladder with your hands in your pockets.
|
|
|
|
|
my MSDN library is not installed...i just borrow the cd
can you just tell me the process, pleassssse!
|
|
|
|
|
do you have yahoo messenger? so we can easily talk about it, this is mine:
pinkaliciouz_rharz@yahoo.com
|
|
|
|
|
For Heaven's Sake! just open the MSDN.com over the web. go to the index and type ListBox COntrol. There will be a section of data binding. Read it and Follow the instrunctions.
These forms are meant to benefit all the people, Thats the way we play the game. You can find a few articles on CP as well. Learn to LURk Before you leap.
Search this same topic in this fforum as well. I'm sure you'll find something useful\
Thanks
Rocky
You can't climb up a ladder with your hands in your pockets.
|
|
|
|
|
|
Hi all,
I keep recieving this error when I try to do an UPDATE on an existing record: [Microsoft][ODBC Driver Manager] Invalid cursor state
I'm making use of Oracle 10g with an ODBC connection. What does it mean and How can I fix it??
Many Thanks in advance
Regards,
The only programmers that are better that C programmers are those who code in 1's and 0's ![Green Alien | [Alien]](https://www.codeproject.com/script/Forums/Images/alien.gif)
Programm3r
My Blog: ^_^
|
|
|
|
|
|
Hi,my requirement is i want to join three tables in which first and second table are related and second and third tables are related.I want to get data from all three tables so how it is possible.
Pls send me some reply.
GIRISH
|
|
|
|
|
Hi,
You could do a join on the three tables with their foreign keys. After the join you would be able to get all data from the three tables. Depends on your database but here is an example:
SQL (JOIN)[^]
Regards,
The only programmers that are better that C programmers are those who code in 1's and 0's
Programm3r
My Blog: ^_^
|
|
|
|
|
Thanx for ur reply, if possible just see this query and tell me wt is wrong in this,
select PurPRMaster.*,StkItemMaster.Name as IName,StkItemMaster.Unit,PurPRTrans.* FROM PurPRMaster
inner join purOrderMaster on PurPrmaster.prno=PurOrderMaster.prno
inner join purprtrans on purmaster.id=purtrans.mastid
inner join StkItemMaster on StkItemMaster.Code=PurPRTrans.ItemCode
It is doing cross multiplication.
wt could be the reason.
Thanks in advance.
GIRISH
|
|
|
|
|
==============================
TABLE [Customers] (
==============================
[CustomerID]
[CompanyName]
[ContactName]
[ContactTitle]
[Address]
[City]
[Region]
[PostalCode]
[Country]
[Phone]
[Fax]
CONSTRAINT [PK_Customers] PRIMARY KEY CLUSTERED
(
[CustomerID]
) ON [PRIMARY]
==================================
TABLE Employee
===================================
EmployeeID
LastName
FirstName
Title
TitleOfCourtesy
BirthDate
HireDate
Address
City
Region
PostalCode
Country
HomePhone
Extension
Photo
Notes
ReportsTo
PhotoPath
Table Order
========================
3 OrderID
0 CustomerID
0 EmployeeID
0 OrderDate
0 RequiredDate
0 ShippedDate
0 ShipVia
0 Freight
0 ShipName
0 ShipAddress
0 ShipCity
0 ShipRegion
0 ShipPostalCode
0 ShipCountry
SELECT dbo.Customers.CompanyName, dbo.Employees.LastName, dbo.Employees.FirstName, dbo.Orders.OrderDate, dbo.Orders.RequiredDate
FROM dbo.Orders INNER JOIN
dbo.Customers ON dbo.Orders.CustomerID = dbo.Customers.CustomerID INNER JOIN
dbo.Employees ON dbo.Orders.EmployeeID = dbo.Employees.EmployeeID
Rami Abd Alhalim
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
