Viewing 15 posts - 8,956 through 8,970 (of 10,144 total)
anu (1/7/2009)
I didn't understand how to use sub-query for my query.
Can you help.
Also, the above query doesn't get me the desired...
January 7, 2009 at 2:30 pm
Nice work, Dave. This might do the job also...[font="Courier New"]SELECT a.application_id,
d.brandname,
dd.dosage,
t.renew,
c.short_name
FROM pap_application a
INNER JOIN tracking t ON a.application_id = t.application_id
INNER JOIN drug d ON a.drug_id =...
January 7, 2009 at 10:19 am
Jack Corbett (1/7/2009)
Michael Earl (1/7/2009)
Thanks Jack.No problem. Just seemed to notice a correlation. I suppose I could be way off, maybe there are other factors involved.
Chortle 😀
January 7, 2009 at 10:12 am
This should be close...
SELECT a.application_id,
d.brandname,
dd.dosage,
t.renew,
...
January 7, 2009 at 9:38 am
cdun2 (1/7/2009)
Why do you want to store the TrackingNumber in more than one place?
They are actually only stored in ConsumableOrderDetail. The temp table that I am using receives data from...
January 7, 2009 at 8:47 am
cdun2 (1/7/2009)
... what did they look like before the update?
TrackingNumber in ConsumableOrderDetail is NULL before the Update. The table to be updated will always have an equivaltent number of rows...
January 7, 2009 at 8:30 am
Richard Proudfoot (1/6/2009)
January 7, 2009 at 7:38 am
If it really doesn't matter which row gets updated, why keep more than one row?
If your rows might look like this after update TicketID ...
January 7, 2009 at 7:35 am
nabajyoti.b (1/7/2009)
i am sorry, did not understand what BOL is?could you please let me know the url?
Books On Line, the help system for SQL Server.
January 7, 2009 at 6:11 am
nabajyoti.b (1/7/2009)
which style do i use in convert(char(12),getdate, )to display in dd-mmm-yyyy pattern in sql
Look up CONVERT in BOL, there's loads of detail.
January 7, 2009 at 5:48 am
vaibhav.a (1/7/2009)
is it possible to use nested cursors......I want to use cursors inside cursors in my SP.....
Yes you can, but be aware that cursors will almost always be resource hogs....
January 7, 2009 at 5:38 am
Fishbarnriots (1/7/2009)
1005
10054603700000
10055
10055000100000
10055000200000
10055000300000
etc
So a search for 1005 could return multiple records rather than just the one, all rather frustrating, it would have been nice if the...
January 7, 2009 at 5:23 am
dhunted2000 (1/7/2009)
got a problem here,cant get this to work
DECLARE @FIELD CHAR(50)
DECLARE @VALUE CHAR(4)
SET @FIELD='Name'
SET @VALUE='MEDIC'
SELECT [Supplier],[Name] FROM scheme.plsuppm Where @FIELD like @VALUE
I have 10 records of Names...
January 7, 2009 at 5:19 am
Fishbarnriots (1/7/2009)
1005
10054603700000
10055
10055000100000
10055000200000
10055000300000
etc
So a search for 1005 could return multiple records rather than just the one, all rather frustrating, it would have been nice if the...
January 7, 2009 at 5:07 am
cdun2 (1/7/2009)
TicketNumber TrackingNumber
88473 ...
January 7, 2009 at 5:03 am
Viewing 15 posts - 8,956 through 8,970 (of 10,144 total)