|
the Max Size of "text" is 255,but it's so short to me.
how should I do?
thank you.
KSCsoft
|
|
|
|
|
if you need a larger test field, use Memo.
|
|
|
|
|
i want to make transaction on disconnected database what shall i do
ma_refay
|
|
|
|
|
You can't. You'll have to reconnect to start a transaction in the connection's context.
|
|
|
|
|
I'm having an issue with combining data rows returned by a query. I am working with sales data from a table joined to several other tables(confusing I know). When run the query returns multiple instances of the same company name(chain of stores), all from different areas of the country.
My question is whether or not there is a way to combine all the data for one company name and be able to get totals for ie: price, # of sales, etc. I've tried using a group by statement, but as I need all the column data from the original table I'm having to group by every column name.
Thanks.
Cheers,
Lil Turtle
|
|
|
|
|
If you are using SQL server then the best idea is to have a view which will return all company names. Once you are done with this you can write another SQL select on view with group by clause for any further data selection.
Hope this helps.
Difficult - > Challenging, this simple replacement made me take my life little easy;)
|
|
|
|
|
A view in this instance is not needed as the data returned is for a report that I'm doing and not part of a permanent data store. Thanks for the tip though I can apply this to other endevors.;)
And I do appreciate the help, Thanks.
A humble novice,
Lil Turtle
|
|
|
|
|
Lil Turtle wrote: I am working with sales data from a table joined to several other tables(confusing I know).
Not really - Joining tables will be a regular occurrance if your database is normalised properly.
Lil Turtle wrote: My question is whether or not there is a way to combine all the data for one company name and be able to get totals for ie: price, # of sales, etc. I've tried using a group by statement, but as I need all the column data from the original table I'm having to group by every column name.
Then what you might try to do is to perform the GROUP BY in a subquery and then join the subquery to the table which contains all the other data that you want. If you want an example, you might like to show your existing code.
Scottish Developers events:
* .NET debugging, tracing and instrumentation by Duncan Edwards Jones and Code Coverage in .NET by Craig Murphy
* Developer Day Scotland: are you interested in speaking or attending?
My: Website | Blog
|
|
|
|
|
The GROUP BY in the sub query worked like a dream. Thanks for the response, I appreciate the help.
A humble novice,
Lil Turtle
|
|
|
|
|
I am only one administator of SQL 2005 database , I want to divide database in seven administration levels !
GETEL - General Telecom
|
|
|
|
|
|
Colin Angus Mackay wrote:
My question is return is: What do you mean by an "administration level"?
Thank you, Colin. I don't quite follow what GETEL - General Telecom is asking for. Would this be different user roles?
|
|
|
|
|
|
Hi - We have a particular field called "EventNum" which is written to a whole bunch of tables. I am new to this group and table struture.
Is there a way I can select out this value from across all the tables in a particular database.
something like - "select * from dbo.* where eventnum=11111111"
this same info is spanned across many tables.
many thanks.
|
|
|
|
|
|
Suppose it is the same name in all the tables and it is the primary key in the most of the tables, then?
Thanks.
|
|
|
|
|
|
|
|
Don't listen to the naysayers. Using T-SQL you can. I do not have access to SQL Server atm so I will describe it and leave it to you. Select from the system objects table where name = Event Num making sure you only get column definitions. Select all table names from the system tables (it might be objects to) that contain the given column. Then you can use a T-SQL query to return multiple result sets each one using exec "select * from " table name" WHERE eventNum=" + whatever.
Sorry I am not in front of SQL Server or I would have given you the code.
A man said to the universe:
"Sir I exist!"
"However," replied the Universe, "The fact has not created in me A sense of obligation."
-- Stephen Crane
|
|
|
|
|
Ennis Ray Lynch, Jr. wrote: Don't listen to the naysayers. Using T-SQL you can
You are still doing what I said and SELECT ing the tables individually. You are just automating the process slightly by building a string with the SQL in in and then executing that dyanmic SQL. There is no single command to do what the OP requested.
DECLARE @sql nvarchar(4000);
DECLARE EventCursor CURSOR
FOR
SELECT 'SELECT * FROM ['+TABLE_SCHEMA+'].['+TABLE_NAME+'] WHERE eventNum= @eventNum'
FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = 'EventNum'
OPEN EventCursor
FETCH NEXT FROM EventCursor INTO @sql
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC sp_executesql @stmt = @sql,
@params = N'@eventNum int',
@eventNum = 4 -- Replace this number with the desired event number
-- or a parameter that represents it.
FETCH NEXT FROM EventCursor INTO @sql
END
CLOSE EventCursor
DEALLOCATE EventCursor
Scottish Developers events:
* .NET debugging, tracing and instrumentation by Duncan Edwards Jones and Code Coverage in .NET by Craig Murphy
* Developer Day Scotland: are you interested in speaking or attending?
My: Website | Blog
|
|
|
|
|
Still no manual discovery is required which I think is what he wanted.
A man said to the universe:
"Sir I exist!"
"However," replied the Universe, "The fact has not created in me A sense of obligation."
-- Stephen Crane
|
|
|
|
|
Thank you for the code - that worked well.
Do you happen to know how we code using CTE, Common Table Expression in SQL2005?
I tried something like :
With event_numbers(table_name, column_name) AS
(
select table_name, column_name from information_schema.columns where column_name='EventKey'
)
I get the table names but how would I select out the complete information for each table?
Thanks!
|
|
|
|
|
Hello,
I am developing an vb.net application and trying to connect to a 9.1B Progress database (I already have read how Progress is not an easy database to connect to.) I have the Merant driver installed on the client and server for connecting to Progress.
When I try to connect to Progress through the system admin using Merant ODBC and the system DSN, it connects fine. (Start->Settings->Control Panel->Administrative Tools->Data Sources(ODBC)->System DSN->Configure) (on the Advanced tab in Configure, the Security Required is NOT selected)
So far, all the forum postings(multiple websites) I have seen for the error message
ERROR HY000 MERANT ODBC Progress driver insufficient information to connect to the data source
recommend the same fix yet I have tried the recommended fix and still get the error.
My connection string is
DRIVER={MERANT 3.70 32-BIT PROGRESS}; DSN=OURDSN; UID=" "; PWD=" "; database=ourdatabase;
The forums say the error is from not having a UID and PWD parameter in the connection string. However, I DO have each of these. I read that the ASP-engine will(incorrectly) not pass on the UID/PWD parameters when the UID/PWD variable values are emtpy. Workaround: pass on a non-empty UID/PWD string filled with blanks.
So I changed my original connectionstring from UID=; to UID=" "; and from PWD=; to PWD=" ";
No improvement.
anybody know the connection string for Progress database in .net using Merant 3.70 driver or how I can further determine what the insufficent information is referring to?
Thanks
|
|
|
|
|
Youb have written correct string but if you have SQL server name (e.g.'sa' PWD='' or PWD='sa' ) whatever u have given at the inststallation time that must be matched. Then u can easily connect to ur database. I think there's no need to write 'DRIVER={MERANT 3.70 32-BIT PROGRESS};' But I m not sure about this so check it.
Without that it is working but don't give null string to the UID or PWD field but gie as below.
DRIVER={MERANT 3.70 32-BIT PROGRESS}; DSN=OURDSN; UID=; PWD=; database=ourdatabase;
Bye,
Jesal Rana
OK
|
|
|
|