Topics
Started by
Posts
Last post
Hi all, I have the requirements to get the path of a particular location through getting its Parent…
4 replies
What is the order of execution of conditions in a where clause. Ex:1 Select * from A Wher A.a1 = 10…
9 replies
Is there a way to do a delete on a large group of records without locking the table for reading?
5 replies
My quandry uses 3 tables. The first table, OLD_TABLE, has position_name. For the&n…
6 replies
Hi, I have 12 columns, one for each month, the column has a float value I need to retrieve based on…
4 replies
Hi, I have a table SUBPARTS with a ProdID, SubPartID, SubpartDesc, SubPartSerial. The data looks li…
6 replies
I know what I need to accomplish can be taken care of with a subquery, but have thus far been wildl…
9 replies
I've not gotten the If statement to work. Before: http://www.webfound.net/sqlbefore.txt After (with…
1 replies
I have a sp that SELECTs from other SQL server select * from SERVERNAME.DBNAME.dbo.TABLENAME I logi…
4 replies
I have two tables, tbl_ProdAttr (Product attributes) and tbl_Attributes. I am try…
7 replies
I did a few searches and I am not seeing anything saying Union queries are bad. Are they?&nbs…
2 replies
im trying to update rows in a table as shown below, there are many many rows i need to update. upda…
3 replies
Hi All, I have some timetable info for rooms in a school as follows: Description period …
2 replies
I have the final part of my report to complete. Yesterday I posted the most confusing set of thread…
5 replies
i have to create a flatfile report ( it will be used in excel in a pivot table). im having some tro…
3 replies
Viewing 15 topics - 7,021 through 7,035 (of 17,082 total)
You must be logged in to create new topics.