Topics
Started by
Posts
Last post
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
Hi, I have created a script that will populate a table dynamically. The script will create the ins…
5 replies
I have a table empid date shift1 shift…
7 replies
Hi, I have to write a query for searching records. I have four input fields. If USER is entering…
6 replies
Dear All, I have a problem to calculate all record and calculate one field which have two data diff…
4 replies
Viewing 15 topics - 4,816 through 4,830 (of 12,230 total)
You must be logged in to create new topics.