|
I think you could write a little procedure (or program). If you need the columns only from one table, just select the first row and loop through columns. If you need info from several tables, you could use system tables and based on the info from there, loop tables, fetch first row and then loop through columns. You'll need to use dynamic statements based on system table information.
|
|
|
|
|
If you want it in SQL , so :
SELECT names FROM tableName WHERE id IN ( SELECT MIN(id) FROM tableName )
You should identify first row by a field , in this case I used id
|
|
|
|
|
Mohammad Dayyan wrote: SELECT names FROM tableName WHERE id IN ( SELECT MIN(id) FROM tableName )
Hey Mohammad,
More help please 
By selecting column names, I'll get all the columns even if they contain a value other than the minimum in the sub select statement, are you sure it can be done from sql??
All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)
|
|
|
|
|
It should work, but I think sou can use this query too :
SELECT name, MIN(id)
FROM tableName ;
|
|
|
|
|
Hey Mohammad,
Thank you for your kind help, but do you understand my question??
I want to get the column names of a table that has for example the value '1' in the first and only row of that table
Example:
A B C
-- -- --
0 0 1
The output should be:
C
Please tell me if you can make this happen.
All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)
|
|
|
|
|
Thanks Muammar. I've got it right now 
I think you should use several queries
select A from tablename where A=1
select B from tablename where B=1
select C from tablename where C=1
|
|
|
|
|
No, thanks to you Mohammad,
That should do it, but do you have any idea how can we combine the 3 select statements so they would return a single row??
Thank you for being there until now
All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)
|
|
|
|
|
Thanks Mohammad, UNION ALL was what I needed to combine multiple select statements and get them in one column
Column Name
------------
A
B
C
D
Column Value
------------
0
0
1
0
Though, I still need to combine those tow columns in one output, can you help in that too my friend
All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)
|
|
|
|
|
Muammar© wrote: Thank you for being there until now
Oh no problem Muammar, I'm happy to help someone .
Muammar© wrote: That should do it, but do you have any idea how can we combine the 3 select statements so they would return a single row??
I'm so sorry , I don't know
|
|
|
|
|
Don't worry Mohammad, thanks anyways for your efforts, I think it's some sort of a join query and I'm googling for join queries.
Thanks again Mohammad.
All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)
|
|
|
|
|
hi. How do you transfer data of a database from another database. I am using MS SQL. I have hundreds of data there and I need to transfer it to another database since I'm having problems with the previous one with regards to attaching it to the dataset with crystal reports. It only recognizes the newly created databases in SQL Express and I don't know why. So I just planned to recreate my recent database and transfer all of the existing data to a new one. How do I do that? Thanks!
|
|
|
|
|
harcaype wrote: How do you transfer data of a database from another database
SSIS is one way if you have to do this continuously but you can also use backup/restore or detach/attach. They would be easier for a single transfer.
harcaype wrote: It only recognizes the newly created databases in SQL Express
If this is the root problem, I think you should concentrate in this. There's no reason why Crystal would connect only to a new database if the database you're trying to connect to is in good condition.
|
|
|
|
|
Root problem? I'm sorry, but what did you mean by root problem? I'm not really sure myself though. A few days ago I was able to attach the tables on the dataset with the same database, and get recognized in the Crystal Report Wizard. Then when I duplicated my project file, and redo what I did in my "backed-up" project file, that started the strange problem. And if you mean that getting and successfully querying the database is a good condition, Yes. My database is in good condition for that part.
|
|
|
|
|
harcaype wrote: A few days ago I was able to attach the tables on the dataset with the same database, and get recognized in the Crystal Report Wizard. Then when I duplicated my project file, and redo what I did in my "backed-up" project file, that started the strange problem
Yes that's what I mean by root problem. If your new project acts differently than the previous project I would guess that the problem is actually in the project, not in the database. But then again I don't know enough about the solution so this is merely guessing.
Try for example restoring a backup to a new database. If that solves the problem then everything should be ok. If it doesn't it would still give you more information about the problem.
|
|
|
|
|
I tried attaching the database on a newly created project. Still the same. Not recognized in the crystal report wizard. Sigh.. Oh well. I'll just try this newly created database first. Hopefully it works.
|
|
|
|
|
Let's hope so. If not, post what you have found and we'll see if some new ideas come up.
|
|
|
|
|
Mika Wendelius wrote: There's no reason why Crystal would connect only to a new database if the database you're trying to connect to is in good condition.
Unless Crystal Reports is connected to the new instance only. I'm willing to bet he has two instances installed.
The world is a stage and most of us are desperately unrehearsed.
—Sean O’Casey, Playwright
|
|
|
|
|
Jerry Hammond wrote: I'm willing to bet he has two instances installed
That would explain it, but even though it's a matter of connection string... "Where do want to go today"
|
|
|
|
|
If I remember my Crystal Reports it is even simpler. From within the report he is building he should be able to use the UI to connect to the correct instance/db.
The world is a stage and most of us are desperately unrehearsed.
—Sean O’Casey, Playwright
|
|
|
|
|
It depends if he's letting the dialogs to show up or if he sets credentials in the code.
But you're right, at the time when the report is launched, the actual connection is evaluated. And if any information is missing, it will be asked.
|
|
|
|
|
I got it working now. Thanks! I just created a new database however I have a new problem. Yesterday I was able to successfully migrate my data to another database, using this query: "INSERT INTO Records SELECT * FROM MMDAserver.dbo.Records", then being stupid, I accidentally deleted the newly created database from the project file I attached into. Now when I created the new database again with the same name and same everything, I already get this error when I try to copy them again:
Msg 8101, Level 16, State 1, Line 1<br />
An explicit value for the identity column in table 'Records' can only be specified when a column list is used and IDENTITY_INSERT is ON.
|
|
|
|
|
This means that you hav an IDENTITY column in records table. Normally you cannot give value to an identity column because SQL Server assigns it. When migrating old data you can set this feature temporarily off. Have a look at: SET IDENTITY_INSERT (Transact-SQL)[^]
However if you don't want that SQL Server assigns the value at all, you should remove the identity definition from that table.
|
|
|
|
|
Yeah I just noticed. LOL. I removed the Identity Specification for the newly created tables. THANKS A BUNCH! You guys were a great help!
|
|
|
|
|
You're welcome
|
|
|
|
|
hi everybody,
My sql databse gets suspected and i am not able to use that database or delete that database.How can i use that database.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
