Topics
Started by
Posts
Last post
For simplicity's sake let's say I have 3 tables: 1. People --- personId (int) --- firstName (varcha…
3 replies
I have a table with two columns, FromDate and ThruDate. I want to delete records from a second tab…
5 replies
Hello, I'm not sure about the use of putting 'N' before any query. For eg - Backup Database Adventu…
6 replies
Hi, I have a number of descriptive tables that store multi-language XML strings like: "Somevalue1s…
15 replies
Hi, How to retreive only month and year from datetime colomn. (dd/mm/yy mm:ss:xx) any help or any c…
1 replies
Hi, How to retreive only month and year from datetime colomn. (dd/mm/yy mm:ss:xx) any help or any c…
1 replies
I currently have a short script that counts the number of non_blanks for a field called Ethnic_Orig…
3 replies
Hi, any ideas for the next : I have the next table orders_resume id orders 1 45 2 …
1 replies
Hi, I have a table named "historic" where i save all requests' status. I want to calculate the diff…
6 replies
Hello, Please bare with me as I am new to this. We have two SQL 2005 Database Systems. After an ins…
2 replies
I need to compare END_DT field from ROW1 to BGN_DT date field in ROW2 to make sure the dates are co…
2 replies
I need query like select count(name),name,surname from info table info has only three columns id in…
6 replies
Hello Sir I want save value in database in separte row user id and its value but problem is this th…
2 replies
Hi, I need help and the scenario is as below. Assuming i have two tables [User] and [UserProfile], …
5 replies
Hi There, I would like to request some assistance with an issue I am experiencing with a trigger I …
14 replies
Viewing 15 topics - 6,526 through 6,540 (of 12,230 total)
You must be logged in to create new topics.