Topics
Started by
Posts
Last post
I have to update one column in each of 40 million rows in a vendor-supplied table. The table has no…
3 replies
Hi, I need to create a delete trigger on the table but there is a foreign key contraint on the tabl…
5 replies
I have a query that get's the following data: 1v+1 4(v+1)*2 12(v-1)*2 the first column is a deci…
3 replies
how do i extract text after a ',' comma for example i have address in this format: ZION …
1 replies
Is anything similar to this possible without writing whole query in every begin block or without dy…
3 replies
Dear All I have a table as follows for a basic bid system SourceID / Prod ID / Bidder / Bid Value…
4 replies
Hi all, I'm getting 3 syntax errors from something in the following construct: SELECT 'EXPENSE',6…
7 replies
When I try to run this code DECLARE @login varchar(255) SET @login = 'user' CREATE TABLE #Hierarc…
1 replies
I am trying to create a linked SS2K db in SS2K5, and I need the link server to automatically conver…
5 replies
Hello Guys, I am working as a DBA in a MNC. Currently i need some help .... I have very large produ…
3 replies
My customer needs to assign contract numbers to salespersons and vendors in advance. What I want to…
4 replies
I need a procedure accepting series of ID's and retrieve data according to those ID numbers. Like t…
7 replies
I have a straight forward select statement which happend to include a ntext column 'ResponseData'. …
4 replies
I've got two stubborn SPROCs...both in the master DB. I've dropped and created them and also tried…
3 replies
hi create table cust_product (cust varchar(10), prod varchar(10)) insert into cust_product VALUES …
6 replies
Viewing 15 topics - 9,646 through 9,660 (of 12,234 total)
You must be logged in to create new topics.