Topics
Started by
Posts
Last post
I posted this last week. Many people offered assistance; thank you so much. After posting I did fix…
3 replies
Dear all, I have SP : CREATE proc [dbo].[usp_FindPrimes] (@opt tinyint, @ResultCount int) asse…
15 replies
Below is what I have run. I can query the workbook if I already know the sheet name. And insert int…
10 replies
Hi All, I think this might be complicated. New to this forum, but okay at SQL. I'm starting to delv…
11 replies
Preface:I've been working on a particular problem past the threshold of time before I should ask fo…
14 replies
Folks, I am (trying to) create an XML data file from SQL that has the following structure<Letter…
1 replies
Hi All, Need some guidelines when considering creating a missing index. When I get information fr…
5 replies
Hi All, Need Index suggestion. I am seeing on one of our prod table, I see 18 non-clustered indexes…
3 replies
Hi All, New to the forums, but I've been working with SQL for a little bit. I'm starting to explore…
5 replies
Ok I am writing a proc that will look to a directory and import excel files. It is a work in progre…
11 replies
Hi All, Looking for a TSQL script which can delete/truncate data from child tables first and then …
1 replies
I am looking to calculate no of months between two dates which are in YYYYMM format. Like no of mon…
13 replies
Hi All, Its a general query performance expectations setting question for a non-tech or adamant TL…
3 replies
Hi All, Need to identify repeated/duplicate indexes. Sample table : create table test_tbl(id int n…
7 replies
I have a table with one field that merges all notes entered from an application into a single varch…
9 replies
Viewing 15 topics - 886 through 900 (of 4,984 total)
You must be logged in to create new topics.