Topics
Started by
Posts
Last post
Hi I am trying to create a cross tab query on dbl_FuelUsage and this is what I have SELECT TOP 1…
5 replies
By: jan.tran
Experts, I have used the below code to generate the 100 numbers on the fly. -----------------------…
22 replies
I have a table emp where in empsal is a field in it. How can I check a condition where empsal can b…
2 replies
Hi, I got stuck on this structure without a clue how to get it done: I've got a result table: IDN…
2 replies
please tell me how can i get the records from inserted/deleted virtual tables in sql.....
7 replies
I have been posed a question, and I have a solution that is a little too manual for my liking! Can …
3 replies
Experts, TableName - MastBCP Code NewCode FlatAcct MSC MSC001 4000700DIVD+1|4000710DI…
2 replies
Hello All. Happy New Year. I a table which lists changes that have taken place over the past week.…
2 replies
How can i check the format of a field where it shud contain values starting with year like YYYY-239…
10 replies
I have a store procedure where I want to pass in 1 to n applicationsourceIDs to run as part of the …
9 replies
I am combining results from multiple tables using union alls. I need to sort the result by date. T…
2 replies
create table #t ( EmpNo varchar(30),Empdesc varchar(100),Date char(10),Message text ) insert into …
2 replies
Experts, I have the table like EmpNo Ename 1 A 2 B 3 C 5 E 6 F 7…
6 replies
By: DonaldW
Hi, I've a lot of transactions in a single sp. I want to store the error messages in a table if…
1 replies
Following is table structure of (Master/detail) tables and I have to display durationSpent in secon…
8 replies
Viewing 15 topics - 3,466 through 3,480 (of 17,082 total)
You must be logged in to create new topics.