Topics
Started by
Posts
Last post
Hi, I'm trying to use OPENROWSET in order to connect to various servers and retrieve some job infor…
5 replies
Can a table variable be updated with the contents of another table variable? Code: ---------- UPDAT…
11 replies
Hi, I have a sql server 2000 sp 3 on a windows xp sp2. I run this code in query analyzer : SET XACT…
5 replies
I have a stored procedure that takes two parameters. A select is executed that must find reco…
14 replies
As part of my job it's becoming more and more frequent for me to have to import fixed format files.…
10 replies
Given this table: CREATE TABLE #T_PEOPLE ( SSN char (9), BIRTHDAY datetime ) insert #T_PEOPLE(ssn, …
5 replies
I am running a script against a couple of databases on my SQL Server 2000 Standard Edition Instance…
2 replies
How can i say fetch records from 20000 to 20025 using query or thru ADO. My Table is: Create table…
6 replies
Hai gurus, I have a problem. I have created a table as shown below. Actually what I am trying to do…
3 replies
Hello All, How is your day going? I hope that all is well. Does anyone have SQL code to determine t…
8 replies
I have a UDF that I want to put in the master database for everyone to use. I know the owner of it …
1 replies
need help to create function Replace on TEXT field and in the text field i have a HTML code i won…
3 replies
On a 2K server (sp1) I am recieving a syntax error when using the TOP clause in a select. For examp…
5 replies
Hello, I have the following query that brings the same record twice! I don't understand why th…
7 replies
How do I get the top 2 listings from within each grouping from a group by clause. For example, if I…
6 replies
Viewing 15 topics - 11,026 through 11,040 (of 17,082 total)
You must be logged in to create new topics.