Topics
Started by
Posts
Last post
I want to join 2 tables, table a and table b where b is a lookup table by left outer join. my quest…
3 replies
Performance issue on Query. Here is query which i ran and it takes around 7-8 min to give the outpu…
1 replies
Hi , I have been given below query in oracle format,which I have to convert into TSQL statement. Or…
3 replies
Hi I have two tables, INCIDENT and PEOPLE INCIDENT has two fields, ID and Date PEOPLE has three fie…
5 replies
Hello, i have below queries each select is fetching records at one level. Is there a way i can wri…
1 replies
I'm Norwegian and have 2 food and recipe website in Norway. I been working with sql and asp for man…
20 replies
I have two tables. Table A has 2162 rows and table B has 101 rows. There isn't any join keys that I…
12 replies
create table #Security ( id int primary key identity(1,1), [Security Id] varchar(20), ) insert in…
4 replies
I have a stored procedure that is suddenly returning data in a different order, and I'm wondering i…
16 replies
DECLARE @sql NVARCHAR(400) DECLARE @WgnWCUser VARCHAR(30)='DBO' DECLARE @TIMESTAMP VARCHAR(30)='Up…
3 replies
I have attached three scripts Input Scripts 1. dbo.InputTest1.Table 2. dbo.inputtest2.Table Output …
5 replies
Hi All XML has never been a strong point of mine. Need some help getting data into XML format as sh…
9 replies
I need to create a week calendar from date in SQL 2012. Week date starts with Sunday regardless if …
12 replies
Hello everyone, I have this script that captures metrics and sizes using T-SQL. When running in dev…
1 replies
Hi All, I have to tune the below query so that it gets executed in the most minimal amount of time …
11 replies
Viewing 15 topics - 2,701 through 2,715 (of 4,984 total)
You must be logged in to create new topics.