2,935 Topics
 | |
| | Hi everyone, Ima working on a business site similar to alibaba.com.In that we have a main categories named agriculture,chemicals ....so on. on clicking on agriculture we get one more subcategory containing different names line plant products,beans so on.. on clicking on beans we get the companies selling beans. similar to … |
| | I have the problem of splitting the the table into following way. Pl help me in doing it Actual table Product Id ProductQty CompCapacity 1 8000 5000 2 10000 5000 4000 4000 Resultant table Product Id ProductQty CompCapacity 2 5000 5000 2 5000 5000 1 4000 4000 1 4000 4000 |
| | Hi All, SELECT * FROM Results WHERE ActualValue NOT BETWEEN Lowerimit AND UpperLimit In my query ActualValue is VARCHAR field. How can I get Results that are out of limit? Shrinivas |
| | I did following - [code=sql]create table test_insert_date (field1 datetime not null) grant all on test_insert_date to public create proc usp_test_ins_dt @field1 datetime null as select @field1 insert into test_insert_date values (getdate()) return [/code] After this, I executed the proc as - [icode]usp_test_ins_dt getdate()[/icode] I got error as [B]"Incorrect syntax near … |
| | Hi Guys, I'm new here and have come across a perplexing problem. I have a user table [code=sql]CREATE TABLE Users ( UserID VARCHAR(64), UserName VARCHAR(50) ) INSERT INTO Users (UserName) VALUES ('Tom') INSERT INTO Users (UserName) VALUES ('Dick') INSERT INTO Users (UserName) VALUES ('Harry')[/code] Each user has roles and groups. … |
| | I have SQL 2005 installed on a 64bit windows 2003 advanced server system. I just recently changed the password of the administrator account (which has always had access to sql) and now I can't login to sql. Well, I can. It allows me to view everything, but when I right … |
| | |
| | I am joining two tables with INNER JOIN and I am getting duplicate entries. I used DISTINCT but its not working. Do we have some other keywords for the same? Thanks in advance, |
 | hi developers, i am developing a s/w that need a search. i current using "like" for search. for ex. [code] select * from Tabl1 where col1 like "% Software Developer %" And Col2 Like "% Software Developer %" [/code] But this is not right way. Am i right.? Please guide … |
| | Hi. Can anyone tell me how to find and install IIS? I need it for developing my mobile application with SQL Server Mobile and create a database. Or if you have any suggestions... Do you know any other way on connecting from mobile applications to databases (other than MS SQL) … |
| | Hi. Can anyone give me an idea on how I can create a search box just like a search box in the contacts window in a Nokia phone? |
| | I have a table which have person's name as Prefix, firstname, lastname, address as three different columns. I want to get all records when fire a query like SELECT * from Persons where name= 'abcd' I want such query which can search in all three columns, it means abcd can … |
| | Hi guys, I am a student on placement and I have created a database for a company. This database contains customer details, enquiries, orders and product details. I used joining 'line' tables to solve the many-to-many relationship between some tables but now i am having trouble using them. I have …  |
| | Hi all, I hope someone can assist me with this. I have two databases and i need to replicate (on a regular basis) a couple of tables in one into the other. Any suggestions of the best method of doing this? with thanks Scott |
| | Hi all experts, Currently i have a problem coding in sql query and hope someone expert can answer me. I have a table with the following values (simplified) Name in_date out_date able 12/03/2008 14/03/2008 bravo 10/02/2008 17/03/2008 able 18/03/2008 null Ok so my result if i want to obtain results … |
| | Hello all, I'm having some problems with joins in SQL. I hope someone here can help me out a little bit. I'm using MS SQL 2000 Server. I have the following tables & data: [CODE] [B]Table: tUsers[/B] id location contact_id ----------------------------------------- 1 1 2 2 2 4 3 1 5 … |
| | I want to make a procedure that runs at every day at certain time. I read that I have to do Scheduling, but to do it I should have sql server agent. I am using sql server express edition with sql management studio express endition. But there is no sql … |
| | I m retreiving some data by using cursor inside which i m calling one recursive user defind function to retrive all child data which is linked to parent. While executing i m getting error stating : [B]Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)[/B] How can … |
| | Ok, I have a e-commerce store that uses stored procedures to sort products. I have figured out how to sort my name and price but am having trouble sorting by rating bc the rating table doesnt have all the productids (only ones that have a rating) and also the rating … |
| | I am trying to insert tables into a database that I created at runtime, I am using MS SQL Server Express, and I have tested this query and it works, in the sense that a table is created. However the small text field (stringText [char]) only has a length of … |
| | Just started SQL Class and I am struggling with an assignment. Would someone be kind to give me some help please? your task is to make a stored procedure that will only billcustomers making monthly payments higher than $500.A Customer can have multiple Plans (services for which they pay amonthly … |
| | 1) [B]INNER JOIN[/B]---I know 2)[B]OUTER JOIN[/B]--I know 3)[B]CROSS JOIN[/B]--I know 4)[B]THETA JOIN[/B]--???? 5)[B]SELF JOIN[/B]--?????? 6)[B]NATURAL INNER JOIN[/B]- It eliminates attributes that have the same name. Can u plz frd me the example of NATURAL INNER JOIN. cz its not working in SQL 2005. 7) [B]EQUI JOIN[/B]----?????? Your EArly Reply will … |
| | Hey guys, I am trying to design a query that will return all the records based on a single date but because of the date/time data type in MS SQL 2005 it defaults to the date and the time 00:00:00 which will return no records for me. Is it possible … |
| | Hello All, I'm having a little problem in witting an SQL statement. I'm sure there is a simple solution for it but its just not clicking with me!. Anywayz, I'm trying to write a statement that in the FROM clause, there is a formula, and i would like to assign … |
| | Hi, im going back through some SQL questions for my exams next week and I cant find a soloution for this, anyone help out? Do a report using SQL that lists the names of categories from which items were bought. For each category the report should show the total value …  |
| | Hello :) , How can i filter something then turn it to filter again and one more time , like : SELECT * FROM Tbl1 WHERE BLABLA1 From those results WHERE BLABLA 2 And Finally , from all back results WHERE BLABLA 3. Real Example: Select all where : the … |
| | Hi, How-To for example: SELECT * FROM table WHERE columname > '2' [B]FROM THOSE[/B] WHERE columname > '4' [B]FROM THESE LAST[/B] WHERE columname > '6' Thank you very much, Core regards :) |
| | When I backup my SQL-Server DB to flash disk from server named server1, The operation was completed %100 successfully.But When I had tried to restore IT FROM FLASH DISKE to an other server called server2 the SQL server 2005 desktop Management studio refused the order and responded "The database is … |
| | I want to make a server authentication login. First I logged in with windows authentication, changed the server authentication from windows authentication mode to sql server and windows authentication mode. Then I created a login, named it jihad and changed the password for that login. Then I gave that login … |
| | Hi, can anybody shed any light on what I'm doing wrong here... I'm trying to acheive an XML that looks like the following: [code] <tshirt Name="Stussy NY Posse T-Shirt Yellow"> <variant size="small"> <productID>10</productID> <dimensions length="34" /> </variant> <variant size="medium"> <productID>11</productID> <dimensions length="45" /> </variant> <variant size="large"> <productID>12</productID> <dimensions length="50" /> … |
The End.