Topics
Started by
Posts
Last post
I am trying to create a xml file from a sql table. Please see the sample data below. Any help is ap…
5 replies
Hi I Have distinct values like 1 game1 2 game2 3 game4 I want output in 1 game1 game2 game4 Below…
6 replies
Hi all I am struggling to understand the following code SELECTCOUNT(*) AS UserCount, LogDate, Lo…
4 replies
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
Viewing 15 topics - 5,716 through 5,730 (of 10,647 total)
You must be logged in to create new topics.