|
iam using Sql server 2000.
|
|
|
|
|
Hi
I have result set as
table name=ID
ID1 ID2 ID3
1 3 1
2 6 1
1 1 1
I want output as
Name1 Name2 Name3
A C A
B D A
A A A
I have one table for name is Name field of this table are:Id,Name.
I m trying query as
Select Name.Name as Name1 Name ,Name.Name as Name2 from Name,Name.Name as Name3
from Name
inner join ID on Name.ID=ID1
Inner join ID on Name.ID=ID2
inner join ID on Name.ID=ID3
above query is giving error. Plz help in this
thanx
Care Carrer
|
|
|
|
|
Man thats ugly, got to be one on the lousiest data structures around.
Joins are not going to do it. You will need to use sub selects.
select <br />
(Select name from name where ID = ID1) name1,<br />
(Select name from name where ID = ID2) name2, <br />
(Select name from name where ID = ID3) name3<br />
from ID
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
i have a table with thousands of records. i have to change the status of the record if 3 new records entered in the table. for eg if i have 4 records in the table i shoud change the first record and for the second record status change, i should have three more new records except already existing records. Please help
Thank You!
|
|
|
|
|
Need more info but just from the sound of it you should be using 1 record with nested records in XML using XML data type. If you are using a queue you are using xml for the conversation.
|
|
|
|
|
What SQL language? Can make SQL Server downtime (Dead, paralysis)
I was only joking and friends
|
|
|
|
|
ChinaTJBoy wrote: I was only joking and friends
Ohh!!! I thought that some Chinese is practicing English.
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
So a Rabbi, a Monk and a Priest walk into a bar and the bartender says "What is this some kind of joke?"
//I am available for birthday party's and barmitzfas....
|
|
|
|
|
i think this is not right place for sharing your jokes...
Reasons are not Important but Results are Important.
Swati
|
|
|
|
|
ChinaTJBoy wrote: I was only joking
You need to really work on your joke telling. They are pretty off
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
Big Joke
♫ 99 little bugs in the code,
99 bugs in the code
We fix a bug, compile it again
101 little bugs in the code ♫
|
|
|
|
|
Hi all,
I want to execute a union query where data comes from two different servers.What i did is first i linked the server to my current server as
Exec sp_addlinkedServer 'myserver'
Exec sp_addlinkedsrvlogin 'myserver','false',NULL,sa,''
and
then i executed the foll query
select user_name+'t1' from myserver.mydatabase.dbo.User
but i get the foll error
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
any help would be appreciated...
When you fail to plan, you are planning to fail.
|
|
|
|
|
I'm guessing that the remote server does not have Mixed Mode Authentication enabled.
SG
Aham Brahmasmi!
|
|
|
|
|
hi,
go through this
http:
and then also if your problem occurs then
"This is caused by trying to connect to SQL Server when SQL Server is not configured for Mixed Mode authentication."
Reasons are not Important but Results are Important.
Swati
|
|
|
|
|
Hi thanks for your reply...
The link u provided really helped..
Thanks again.
When you fail to plan, you are planning to fail.
|
|
|
|
|
Is there possibility to define unsigned type or convert already exist type, int for example, to unsigned int in MSSQL?
|
|
|
|
|
Can you be more clear in your question?
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
|
|
|
|
|
Sure.
I have some unsigned short variable in C process and I need to load its values into database.
The values of this variable may exceed 32K and I also don't want to use 4 bytes data valuse. Just like in C process - 2 bytes long.
|
|
|
|
|
There is no unsigned integer types in SQL Server, except for tinyint (0 - 255).
You can use an user defined data type, but that will not make the size of the data smaller (which is what I'm assuming you want to do). You can also add a constraint to a column so the value is >= 0.
As for saving space, no way to unsign an int.
|
|
|
|
|
There are no unsigned integers in SQL Server, except for tinyint.
So for bigger values define a INT or BIGINT data type ( as per your database demand ) and add a check contraint to accept only positive values.
Like the below example.
create table x_table(i int, j_Pos_value int constraint chk_j _cons Check
(j_Pos_value>=0))
"We can't solve problems by using the same kind of thinking we used when we created them"
|
|
|
|
|
Hi,
I want to know that in sql server 2000 when user wants to reterive particular record from table,Is this true that whole table rows are processed or executed .
becuase i want to know how i improve the performance of my database.
Any Suggestion .
Regards
Rameez
|
|
|
|
|
This depends on many things. Generally to get 1 record you use a where clause to filter the table. If the field you are filtering on does NOT have an index then a table scan is required until it finds the record. This is called art of database tuning. There a many books written on this subject.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Check this[^]
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
|
|
|
|
|
You should definitely look into this tool. I have used it to find out what is going on while my application is running. Also, when writing your SQL statements, you should avoid statements like "select * from myTable" you should only list the columns that are really required otherwise you will be sending more data than is necessary over the network.
My 2 cents.
David
|
|
|
|
|
Yes, all records of database are traversed.
"We can't solve problems by using the same kind of thinking we used when we created them"
|
|
|
|