Topics
Started by
Posts
Last post
Hi Gurus. Here are the details of an issue that I want to fix, without using cursors. My Table is: …
3 replies
I have a fairly large query and I'm trying to add this simple bit of code to: (select value FROM […
2 replies
Hi frnds.... I like to create store procedure for this stmt instead of using query select * from t…
2 replies
How do you select a global var from another server, ala a fully qualified name? SELECT server.maste…
5 replies
OPEN cursor FETCH NEXT FROM cursor INTO .... WHILE @@FETCH_STATUS = 0 BEGIN -- Process chunk o…
5 replies
HI, I am trying to setup a job to restore a remote database backups. these backups run every altern…
1 replies
I have a view setup from an SMS database which lists servers. Within the results there is a field f…
1 replies
Hi all, my table structure is, saNumber int flag int amt in…
14 replies
Hi I have a customer table which is full of bad data, but does have some good data in it. The bad d…
3 replies
Please help me enforce the following data integrity: Each unique value of Col1 must not be combined…
3 replies
Hi, The following query gives me the list of user tables in the database: select * from sys.objects…
2 replies
Hello everybody, I wondered if in Tsql (sqlserver2005) there is a way to select all the instances i…
6 replies
Here is some test data with a select statement --===== If #MyTable already exists, drop it IF…
2 replies
I am trying to write this code below from Access into SQL Server, but my problem is that I have IIf…
33 replies
Hi. I have a basic stored procedure that allows users to search by either ProductID or Product Desc…
4 replies
Viewing 15 topics - 4,816 through 4,830 (of 12,234 total)
You must be logged in to create new topics.