Topics
Started by
Posts
Last post
Hi all, Good morning Can anybody help me to find the size of data of a query resultset other client…
3 replies
Hi, Is there any way we can Count the rows of a table without using the Count() Function? Vinu Vija…
7 replies
Hello All, I am working on a procedure that just creates 2 temp tables and insert the records into …
4 replies
Hello, I have the following query in which I need help with the substring join: select x.labtest_…
1 replies
I have a table with 1 column containing the following: SELECT * FROM TEST STYLE HK82382 HK82386 HK8…
3 replies
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
hi i need to update 1 table based on other. first table declare @temp1 table (id int, member nvarch…
5 replies
Table structures DECLARE @team table (emp_code int,old_emp_code int, emp_name varchar(20)) insert …
11 replies
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
I have table something as below Acivity_id Entry_id Eventy_type_id Event_value …
18 replies
Viewing 15 topics - 5,716 through 5,730 (of 10,644 total)
You must be logged in to create new topics.