Topics
Started by
Posts
Last post
Hi there, I have two tables which are a 1 - M relationship. I have a user who want a horizontal vie…
3 replies
I did a search on this before I posted, but didn't find anything. I am using a procedure to return …
4 replies
I've got 250+ procedures that need one line of text changed. Can anyone point me in the right direc…
1 replies
The define of OpenQuery in MSDN is as following: OPENQUERY ( linked_server , 'query' ) Can anyone k…
1 replies
I plead with the DB gurus out there for assistance. I have just encountered what would appear to b…
20 replies
I am using sql6.5 Can I use a Variable such as @NAME inside of a PATINDEX statement in a SPROC? For…
2 replies
I have an Ideas Table with the following fields ideas_id iDEAS_sTATUS (i.e submitted in draft in pr…
1 replies
Using SQL Server 2K, I have a SP which calls 2 other SP's and returns a Name and a Record Count. …
6 replies
Hi all I've got a nagging problem trying to use xp_cmdshell. Environ is NT4 running SQL2k. We have …
17 replies
Why does SQL Server not allow multiple NULLs for a column with a unique constraint defined? As far …
17 replies
I have a table, i want to make a log of update information , for ex if some data is modified from s…
1 replies
I'm trying to run an update query in a sql DTS package. I created the the 2 connections, SQL-Oracle…
2 replies
Hello guru's out there. I have a question about case statements. Below is an example from the books…
15 replies
Hi all, I am trying to automate a process by creating or Altering a view dynamically using a stored…
3 replies
I am trying to use opendatasource to export a table to a text file and am gettiing error 7399. I ca…
1 replies
Viewing 15 topics - 15,691 through 15,705 (of 17,082 total)
You must be logged in to create new topics.