I have a table in which I have result, defect,name as columns:
Name Result Defect
A P x
A P x1
B P X2
When defect is not null and defect!=' ', I select the rest of the defect for a particular 'name'='A'
I get the below result
x
x1
i.e two rows, but I need this in a single row like:
...
Bangaru
Last Activity: Jan 14 '08, 05:22 AM
Joined: Feb 19 '07
Location:
-
resultset in a single row
-
Hi Jim,
I am not sure whether I should open a new thread for my problem...
since I found this post to be related with my doubts I reply here
In my case it is like I select a particular column with where conditions, it returns 8 rows like:
Result set
Defect
*******
Test1
Test2
Test3
I need the result in single row like as below
... -
how to retrive excel template stored in a table on SQL 2005 DB
I would like to know how to retrive an excel template stored in a table present on SQL 2005 DB...
Whether we can use the Select query? but then how will a template be displayed for us when we use Select query?
Pls help in this regard
Thanks -
How do I execute a .sql file from command promt
How do I execute a .sql file from command promt?
I googled and couldnt find a clue about it...
Please help -
Need help in Sorting in VSFlexGrid
the problem is I have the code, sorting as below in the VSFlexGrid:
VSFlexGrid1.Sor t = flexSortStringN oCaseAscending
I have a column that displays both Date and time
When I get this grid populated the first time, the Sort works.
when I select a different condition to populate the Grid, then when I sort clicking on the column that has both Date and time, it doesn't.
what happens is that it... -
Hi,
I do use sql2005, in my machine the pound symbol gets imported as it is. But in some computers it gets inserted as "??" as you say. So I guess its nothing to do with sql2005 but with some system settings which even i am not sure. Waiting for someone to help in this regard.
Regards,
BangaruLeave a comment:
-
Also I see that we are able to import to our application the symbols pound i.e. non-ascii, but in my collegues system this turns to Question mark symbol.
Does any system setting affect this?Leave a comment:
-
Removing the duplicate rows from a database
If you have a problem in deleting duplicate rows in a table if the table does not have any primary key, then here is a tip to do that.
Deleting duplicate rows when there is no primary key
Problem
Every once in awhile a table gets created without a primary key and duplicate records get entered. The problem gets even worse when you have two identical rows in the table and there is no way to distinguish... -
Removing the duplicate rows from a database
If you have a problem in deleting duplicate rows in a table if the table does not have any primary key, then here is a tip to do that.
Deleting duplicate rows when there is no primary key
Problem
Every once in awhile a table gets created without a primary key and duplicate records get entered. The problem gets even worse when you have two identical rows in the table and there is no way to... -
Bangaru started a topic how does SQL 2005 store Non-ASCII values and how it will be displayed in VB 6?in SQL Serverhow does SQL 2005 store Non-ASCII values and how it will be displayed in VB 6?
Hi,
How do SQL 2005 handle Non-ASCII values?
My application is in VB 6 and SQL server 2005, and when I import non-ascii values like pound symbol, it is converted to question mark...
Can someone help me on this?
Thanks. -
Bangaru replied to SQL how to view the list of tables in DB, the columns in the table, stored procedurein SQL ServerI dont have Enterprise Manager because It is now upgraded to SQL2005 so I need t owait until SQL 2005 Server is installed on my PC.
I'll try this once I get it installed and post a message again on this :)
Thanks a lot for all your response.Leave a comment:
-
Bangaru replied to SQL how to view the list of tables in DB, the columns in the table, stored procedurein SQL ServerI tried this but it didnt work as it said that I dont have permission or the it doesnt exsist :(
I dont have execute permission...
I dont want to execute the stored procedure, but want to view the code in it
I cant ask the DBA... as I dont know who it is......Leave a comment:
-
Bangaru replied to SQL how to view the list of tables in DB, the columns in the table, stored procedurein SQL ServerHow do I find if I have permissions to execute it?Leave a comment:
-
Hi,
In some servers, if the Select statement is run with out specifying WITH (NOLOCK) then it will throw timeout expired.
Suppose you run the following query from your application
Select * from emp;
then it will throw time out expired
Please use
Select * from emp WITH (NOLOCK);
then it wont expire. I am not sure of which server setting that causes...Leave a comment:
-
Bangaru replied to SQL how to view the list of tables in DB, the columns in the table, stored procedurein SQL ServerHi all,
Thanks
select * from information_sch ema.tables where table_type = 'base table'
select * from sysobjects where type='p'
the above query worked
Thanks a lot
But
I tried sp_helptext 'spname'
But it returned
Server: Msg 15009, Level 16, State 1, Procedure sp_helptext, Line 54
The object 'spname' does not exist...Leave a comment:
-
Bangaru started a topic SQL how to view the list of tables in DB, the columns in the table, stored procedurein SQL ServerSQL how to view the list of tables in DB, the columns in the table, stored procedure
How do i view the code in stored procedure?what permission should I have for it.
Also how do I get the list of tables in the DB?
No activity results to display
Leave a comment: