Topics
Started by
Posts
Last post
I am trying to update the field "status" in our ACADEMIC table. So far my code correctly pulls the …
15 replies
I am looking for opinions on putting Insert and Update code into the same proc. Personally I think …
7 replies
In writing a conversion script for data from a competitor's application, I am trying to pull CPTCod…
2 replies
Hi, I need to call a linkedserver in the remote server. Server1 : 64bit SQL 2005 Server2 : 32bit SQ…
1 replies
I have a table called AlertLog which contains these columns: 1. AlertCode 2. TimeStamp 3. AlertNoti…
1 replies
Table 1 seqnumNotes 1 Note1 2 note2 Table 2 seqnumnotes 1notesA 1no…
7 replies
Hi, I am trying to get # of rows for a table. I used sp_spaceused, through which I get a number whi…
6 replies
Hi Guys, Does any body have any idea about the below error: The current transaction cannot be commi…
3 replies
I have a table that I want to extract the first record of each KEY. I'm using the following select…
13 replies
I have the following column. Jurisdiction_id TX TXSAN TXSANCOR I'm wanting to create a report that …
7 replies
I'm extracting from a DB2 table and loading into SQL2005. I've got this weird character that appea…
7 replies
Hi. I am attempting to construct a query intended for use in a report. The report is to display pay…
25 replies
Hi There, Im having the problem when i tried to update the value in the column. My table has follow…
4 replies
What is wrong with below script select 'EXEC sp_addextendedproperty @name = ''MS_Description'' ,@…
7 replies
I have to concatenate fields from a table into on huge column in another table. Problem is some of …
10 replies
Viewing 15 topics - 8,686 through 8,700 (of 12,230 total)
You must be logged in to create new topics.