Topics
Started by
Posts
Last post
Hey everyone, I've got a table with a column of ints and I need to remove any discontinuity between…
7 replies
whats wrong with this statement how would I write this statement using CASE Function "If AddressTy…
2 replies
is it possible to do a case statement in a join. I have an order table which needs to join to a lo…
11 replies
I am newbie to rewrite the PLSQL to TSQL. Please give some conversions for below code in PLSQL to T…
1 replies
Hi Guys, I need to know how to do division, subtraction and multiplation within an CASE WHEN statem…
16 replies
I have a case where 10 or so sprocs with multiple CTE's in several of the sprocs have been created …
3 replies
Hi All, Have any one of you tried running dbcc commands using openrowset.Please find the code bel…
3 replies
The code below does an update on a 17 million rows table (table is from an Axapta 3 database) upda…
9 replies
Hi, I'm trying to find a way to campare values in rows of the same table without using joins. for e…
5 replies
I have 2 sql statements: update t5 set updatefield = 0 from t5 inner join t6 on (t5.c1 = t6.d…
3 replies
Hello everyone, I got the following problem... [font="Comic Sans MS"]The table subject Contains ind…
6 replies
Hello all, It's been some time since I've written a recursive CTE and I'm having a difficult time. …
9 replies
Hi guys, here's a question that needs an answer. I have 2 sql 2005 databases. Inside the first one …
5 replies
At the moment our client system update record Created_Date and Amended_date fields from the users s…
4 replies
Hi all, Could you please help me to move data from one table to another? It's a bit tricky. a. Tabl…
3 replies
Viewing 15 topics - 8,311 through 8,325 (of 12,230 total)
You must be logged in to create new topics.