Topics
Started by
Posts
Last post
We have a large web based system ASP/SQL 2000/DTSearch Indexing that has run successfully for over …
1 replies
update InpatientMedStat set InpatientMedStat.PrincipalDiagnosisCode = ltrim(rtrim(rptpxa2.DCo…
19 replies
How to extract data from table to a remote(shared) path rather than to the database server path? I …
6 replies
As part of an insert statement I feel I want to write something along the lines of the following. C…
4 replies
We are looking at converting all columns within a database to nvarchar & nchar from varchar &am…
2 replies
hi, can i create two indexes on a same table?what is clustered index and what is non clustered i…
4 replies
Dear All, Consider a table called Journals.It is a master table that contains the Journal names wit…
5 replies
I am passing a few values to a proc. The parameter is defined as a decimal within the proc. but the…
1 replies
I need code the SQL code to generate today's date 'MMDDYYHHMMSS' with no Semi colon how should I do…
5 replies
I have a unusual export problem, where one system that we export to requires 2 lines per row (fixed…
11 replies
I have an application that fires off several stored procs sequentially. The first process cre…
54 replies
I have this stored procedure to calculate the percentage of the employee in the cost center.&n…
2 replies
Hi, I'm trying to figure out some confusion regarding left joins. I have table A, which I want to j…
7 replies
Is there a better way of writing this query? The @List can be up to 100 consecutively.  …
3 replies
Hi, Have a SQL Server MSDB1 (2000 Standard edition) linked to another SQL Server MSD…
12 replies
Viewing 15 topics - 5,326 through 5,340 (of 17,082 total)
You must be logged in to create new topics.