Hi Lowell and Flo

Now we have two solutions to the same problem. One with MS Undocumented feature another one is using cursor. Which one should be used !!! from a...

Carol Adams (4/7/2009)

---

I am still a little green in some parts of sql, but I have 2 SQL2005 databases, we will call them PROD1 and RPT1. What I need to...

Instead analyzing the XML files and creating the scheme, If you convert teh XML file CSV file and load it in SQL Server and then analysize the data.

To Convert XML...

Hi

Try using OUTPUT keyword to find out whther its updating any records or not.

CREATE TABLE EMPLOYEE_WORKING_HRS(

EMP_ID int NULL,

ENAME varchar(30) NULL,

YR varchar(4) NULL,

MON varchar(3) NULL,

WORKING_HRS int NULL,

RATE int NULL,

SALARY AS (WORKING_HRS*RATE)

)

INSERT...

aram_golbaghi (4/8/2009)

---

hey i think i found my solution:

CREATE VIEW UV_ProductsPrices

AS

WITH PriceCompare AS (

SELECT i.productid ,ph.actiondate,ph.feebuy,ph.feesale,ph.feeenduser,ROW_NUMBER() OVER (Partition BY ph.ProductId ORDER...

The point which i didn't understand is why your code depends on the sequence of the PK??

Perfect solution..with simple trick using REVERSE...

In addition to the "EXEC" always have TRY..CATCH block to avoid any un-expected errors during the operations.

Amazing topic..it is still going...

I Wounder why we dont have TRIM function in SQL Server. 😉

Hi jeff, this is not about replication.:-D Its about moving data from...

AFIFM (4/7/2009)

---

Now, I just found that the one of the fields in 'ClientsDB.Users' is [VARCHAR(50)] and the equivalent field in 'MarketingDB.Users' is [int]. So how do I make the change...

You can even pad all the "0" till yuo reach length of the string as 11.

http://www.developerdotstar.com/community/node/319

if you are doing it from VB.NET then it...

Hi

Ask your Oracle DBA to increase RollBack Segment size. In addition to this instead of reading all the records at one shot read them in chunks to avoid any kind...