Topics
Started by
Posts
Last post
We have a table with 200+ million rows and growing. This table is so heavily updated that there are…
10 replies
Hi all, When i try to insert the data from my server to my local machine at that time i got the fol…
3 replies
Hello, I have a rather basic question but today I'm feeling a bit stumped. I want to create a coun…
2 replies
I need to retrieve a list that sums up all the [gac] per [custn]. The goal will be one GAC per cust…
10 replies
Hi all...I need your assistance here! I need to update a view. It has an UPDATE trigger (INSTEAD O…
1 replies
Hi, I'm trying to transform some data that is broken out into multiple records into a single record…
4 replies
Does anyone know if it's possible to tell which record in a table is locked? I can get the name of…
3 replies
it's simple...i want to create a rule that allows only the characters 0-9, and +-. i started with a…
12 replies
I have 3 columns of TabA to comapre with similar table TabB. How do i check if every record is same…
7 replies
Is it possible to update more than 1 column from a 3 way table join? the following update works whe…
2 replies
I have a small problem with the below query. The first table in the CTE is coming from an unindexed…
2 replies
Hi Gurus, Can I use following T-SQL coding: If @Result0 Begin Set @Result=11 Goto Failure End inste…
2 replies
DECLARE @t table (offset int IDENTITY(1,1), foo nvarchar(50),number int) INSERT INTO @t (foo) VALUE…
8 replies
Hi All I got in a situation where i have to clean my table which is backs to an year wor…
9 replies
I am trying to build relational table from the XML below using the attribute values where FIELD1 is…
7 replies
Viewing 15 topics - 6,376 through 6,390 (of 12,234 total)
You must be logged in to create new topics.