Topics
Started by
Posts
Last post
Good night In new in sqlserver, its a simple question when i type sp_who, displays all user, connec…
7 replies
I'm getting very confused! It's easily done with me! If anyone can help with what is probably a v…
3 replies
I haven't quite been able to get my hands around this query this afternoon. I have 3 tables. A form…
5 replies
By: Allen B
We currently use a DTS package to extract data from the db and export it in an XLS file, or in some…
1 replies
Is there a way I can return a recordset via a SP which contains the fieldnames that hold a particul…
12 replies
I have an Access front end and I'm converting my queries to Stored Procedures in SQL and using Pass…
2 replies
Hi experts, I have a temporary table from which I would like to keep only the rows that have a uniq…
2 replies
I have the following stored procedure and it works great, but it names all of my joins as "Exprxxxx…
4 replies
By: gomikem
How do I convert the following from SQL to T-SQL? >=Now()-14 I've looked all over the internet a…
2 replies
By: gomikem
How do I turn log shipping off and on so I can run some batch jobs? Thanks.
1 replies
By: tbeadle
I'm using sql2000. I have a table with 4 text fields which need to be referenced in a view. The fie…
2 replies
I am using VBScript with ADO (Active Data Objects), to connect to SQl Server 2000. For some reason …
2 replies
I have data in a table as shown below (Before) that I need to use t-SQL to dynamically transpose/fo…
1 replies
Select MAX(FID) as maxfid from FarmInfo SELECT FID, Etc, Mtc, Tur, wegb, ost, other, Pmtc, Ctel…
1 replies
Aside from the usual system databases (which I'm afraid to touch) I have two user database files a…
8 replies
Viewing 15 topics - 661 through 675 (of 2,871 total)
You must be logged in to create new topics.