|
I would not use ODBC as it is another layer of abstraction on your DAL. I have not used it in a very long time. The question to me is ALO or OLEDB[^] having done some research I decided to stick with OLEDB.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Ado.NET is Cool for that 
see this http://www.dotnetfunda.com/articles/article103.aspx[^]
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
www.ITS.co.za
|
|
|
|
|
select m.pharmacyid as MemberJoinedPharmacy,
tempTrans.pharmacyid as MemberFirstTransaction,
tempTrans.transactiondate,
m.datejoined,
m.cardno, m.title, m.firstname, m.lastname,
m.street, m.suburb, m.state, m.postcode,
m.lastsale, p.pharmacyname
from member m
join pharmacy p
on m.pharmacyid = p.pharmacyid
join (select top 1 * from transactioncurrent t
where m.memberno = t.memberno
and t.voucherno is null
order by t.transactiondate) tempTrans
where m.datejoined >= '2009-01-01'
and m.pharmacyid in (select ph.pharmacyid
from pharmacy ph
where ph.pharmacygroupid = 87)
and m.datejoined <= tempTrans.transactiondate
and m.pharmacyid <> tempTrans.pharmacyid
order by m.pharmacyid
|
|
|
|
|
By db engineer I assume you mean the database engine? If so, obviously, yes there is something wrong - what that may be we can have very little idea without any other information.
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
Hi Bob,
thanks for ur reply, already worked out...
|
|
|
|
|
What sort of syntax error? Where is it? These will be stated in the error message.
|
|
|
|
|
thanks mate, already worked out....
|
|
|
|
|
i tried to drop the primary key of the table using
alter table customer drop primary key but it says
Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'primary'.
what might be the problem
|
|
|
|
|
try this
alter table customer drop constraintname
constraintname is the name of the primary key constraint
|
|
|
|
|
I have the same problem too. What are you suppose to use.
|
|
|
|
|
Hi
What is the best version of sql server 2008 for my needs
1. all graphics function for make tables and query and so on...
2. database of over 2 million records
3. 30-40 users that work on the database
is the express edition fit for me ?
thank's in advance
|
|
|
|
|
Hi,
IIRC SQL Server Express is limited to 4GB of data.
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
|
|
|
|
|
I have an application I will call App1 which the customer access it's own database in an instance of SQL server which we have over 200 identically customer databases (identical schemas). However, we use a single login via web services that has admin rights over the entire database. It is the same for all customer databases. I want to reduce risk by lowering rights. APP1 only accesses the customer database via stored procedures. We also have several functions that we use which are called in the stored procedures. We do not use any views. We also created an ad hoc reporting app that I will call App2. App2 performs SELECT queries directly from the database tables. We do not update tables from App2. What is the simplest way to handle this. I would assume a role (I believe that would to be an application role) at the database level with execute permissions for App1. For App2, it would be the same except it would be SELECT ONLY, I would not allow it to have execute ability on the stored procedures. I think this is the best way but I would like some feedback before I go ahead and propose this change.
|
|
|
|
|
In reference to app2 the reporting app, we use procs to service 98% of our reporting requirements. ALL reporting procs are prefixed with rs and there is a standard SQL user with execute assigned to only those procs and select on all tables and views. We have some VERY complex reporting requirements.
We then have a script that goes through the database and assigns the correct rights for reportuser which the report dev runs whenever he publishes a new report.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
hai all,
In my database table i have a data in a table like below
X 102
Y 101
Z 123
X 142
Y 245
Z 625
X 234
Y 432
Z 111
How can i get the data from table kike below.
X Y Z
102 101 123
142 245 625
234 432 111
Please help me how to write select query for below.
Thanks in advance,
cheers,
sekhar
modified on Saturday, April 4, 2009 7:26 AM
|
|
|
|
|
Hi,
You need to use SQL 2005's PIVOT statement. Have a look at examples here[^].
Regards,
Syed Mehroz Alam.
My Blog
My Articles
Computers are incredibly fast, accurate, and stupid; humans are incredibly slow, inaccurate and brilliant; together they are powerful beyond imagination. - Albert Einstein
|
|
|
|
|
Hi,
I have a cte query that returns a hierarcy of content and subcontent shown below:
Id PId Name
----------------------------
1 0 HomePage
2 1 AboutUs
5 2 WhatWeDo
7 5 Alternate
8 5 Another one
10 8 Second
11 8 third
4 1 ContactUs
6 4 TotalItems
3 0 Testing
I want to take this result set and generate a Xml like the one shown below:
<ContentItems>
<Content Id='1' PId='0'>
<Name>HomePage</Name>
<Content Id='2' PId='1'>
<Name>AboutUs</Name>
</Content>
</Content>
....
</ContentItems>
I have tried using the FOR XML but it it seems to just put all the nodes under <contentitems> node. Any suggestions is appreciated. Thanks.
|
|
|
|
|
How to get the time difference between two dates in SQl?
|
|
|
|
|
|
Hi!
I have a database (master.mdb), and I want link 3 table (first, second, third) from a password protected (abc1234) database (secondary.mdb).
How could I link with VBA?
Thank you
|
|
|
|
|
Have a look into the information this site can supply Connectionstrings[^]
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi all,
I am getting Error: Truncated incorrect time value.
while working with TIMEDIFF function in mysql.
pls help resolve this error.
Thanks inadvance.
No Defeat Is Final Until You Stop Trying!.......
|
|
|
|
|
hi,
i got the solution,
there is a max limitation for time value for TIMEDIFF function that's why its throwing error.
anyways thanks
No Defeat Is Final Until You Stop Trying!.......
|
|
|
|
|
SQL> create or replace procedure create_tablename(name varchar2) is
2
3 str varchar2(20) := name;
4 v_str varchar2(255);
5 Begin
6 v_str := 'Create table '||'AFR'||'_'||str||'(rollno NUMBER(2),name varchar2(10))';
7 Execute immediate v_str;
8 End;
9 /
Procedure created.
SQL> variable abc varchar2(20)
SQL> exec create_tablename(:abc);
BEGIN create_tablename(:abc); END;
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SCOTT.CREATE_TABLENAME", line 7
ORA-06512: at line 1
hey can any1 suggest what exactly the problem is?
The above code is for creating the table dynamically in Oracle 9i....
|
|
|
|
|
That's as close to a clear text message as you get from Oracle.
ORA-01031 means you're not having the privilege to do what you just tried to do.
ORA-06512 tell you where the error happened.
So it means that your user is not having Create Table rights in tablespace Scott.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
