Topics
Started by
Posts
Last post
I was joining nearly 5 inner joins and 2 left outer join Final with group by Here i am facing perfo…
3 replies
Hi, When I add the below line of code to my stored procedure, the performance becoems very poor. I…
3 replies
In the statement below, there is a problem where some records are occasionally duplicated. I have …
1 replies
Hi all, I have a table that stores "register" information, e.g. UserID, RegisterDate, Available/Una…
2 replies
I have this same statement, can't seem to figure this out. How can I SUM the 'current amount' colu…
2 replies
hi in my stored proc i have 3-4 while loop and i need to use different variable for it i m having m…
5 replies
Hi everyone, We have a SP that is quite long and it has a lot of such code: UPDATE table1 SET co…
5 replies
Hi, I can't explain the following behaviour: I join 2 tables and depending on the where filter I ge…
7 replies
I have this query works great - no problem: select * from (SELECT pehPErcontrol,case left(substrin…
3 replies
Hello Everyone Happy hump day to all. I am working on gather some stats for each table in a databas…
5 replies
I have a table with articles and a view with additional article information. For an article in the …
1 replies
I have a table create table searchtbl ( skills varchar(100), position varchar(40), location varchar…
10 replies
When testing Stored Procedures, can you run something like BEGIN TRAN EXEC sp_deleteSomeRecords "V…
11 replies
Hello I am inserting data from one table to another using update,set command and getting the follow…
8 replies
Is it possible to create a join on an alias? I have this query that I need to join to a table (mont…
5 replies
Viewing 15 topics - 3,346 through 3,360 (of 10,647 total)
You must be logged in to create new topics.