Topics
Started by
Posts
Last post
I am working on some crazy SQL to do a load from staging tables into the live tables. As most know,…
2 replies
I am looking for result in pipe delimited format IF OBJECT_ID('tempdb..#temp1')> 0 DROP TABLE #…
15 replies
I have a Stored Procedure which returns results set in 2 tables. For example, if i execute it using…
4 replies
hi i am getting my result like this column1 p = 30 q = 50 r = 70 now i need to divided this like th…
10 replies
Hi All, I have (two hundred and 29 million ) records in a table. we have a procedure which is upd…
9 replies
By: Varun R
hi i need to update 1 table based on other. first table declare @temp1 table (id int, member nvarch…
5 replies
By: vinu512
Table structures DECLARE @team table (emp_code int,old_emp_code int, emp_name varchar(20)) insert …
11 replies
By: vinu512
Hello All, I have a query where I need to use an "IN" clause like: AND e.Id IN (@EmpId) but it …
11 replies
Is there a way to tell when a stored procedure was last recompiled/compiled? I am trying to work wi…
13 replies
By: dkschill
I have table something as below Acivity_id Entry_id Eventy_type_id Event_value …
18 replies
Any idea how to only return what is between the second and third forward slash(/)? Character length…
1 replies
All, Please help or advise. I need a script to delete a login which is mapped(user mapping) to seve…
2 replies
By: SueTons
hi, my sp takes long time to execute, i need some alternative for the same code. create Procedure […
8 replies
Hi, I have several db servers that service several of our clinics (each clinic using their own serv…
3 replies
By: GSquared
I have a table that has product receiving in it, I need to retrieve the max receipt date for an it…
1 replies
Viewing 15 topics - 5,716 through 5,730 (of 10,635 total)
You must be logged in to create new topics.