I would say Cube is a representation of data similiar like a rubix cube. Where you can look at data from different angles(in analysis world - Dimensions). You can use...

I had a similiar situation to update some old Ids with New IDs... my list contains around 1000-1500 rows in excel...

Save the sheet as a CSV first...

I did...

what you want to achieve ? send the table definition for both Statusxref and ITRegInfo tables.

Assume its something like this...

Select StatusXref.StatusId , ITRegInfo.Status From StatusXref Where StatusXref.StatusId = ITRegInfo.StatusId

define your...

In Simple, SQL Developer version has enterprise manager, query analyzer and all kind of development stuff..

MSDE has only Service Manager to deal with! no enterprise manger or query analyzer.

Linto

I read somewhere that you can purchase windows2000 license and install windows NT4.0.. is that applies for SQL also ?

Linto

Goto

http://www.sql-server-performance.com/vg_database_comparison_sp.asp

for a stored procedure which will do comparison!

Linto

see a sample

Col1 -- is the unique column

col2 is the zip code column..

update table2 set col2 = a.col2 from table2 join (select col1,substring(col2,1,5) as col2 from table2 )a on table2.col1=a.col1

Thanks

Linto

Sorry if i misunderstood you..

First, the sample code put in the forum is not by me.. its by somebody else. To get rid of the error modify the line

SET...

Check whether NOT NULL constraint is set on the production database for security_id column in user_security table.

Linto

use DATEPART function and retrieve the date parts from the date retrieved.

declare @dtTime datetime

set @dtTime  = getdate()

SELECT CAST(DATEPART(m, @dtTime)as varchar) +'/'+ CAST(DATEPART(d, @dtTime)as varchar) +'/'+  CAST(DATEPART(yy, @dtTime)as varchar)

Linto

How you restored the database ?? using DTS ? or backup/restore?

If you attempted DTS, whether you selected copying constraints ??

Linto

Its not clear from the question.

What you want to do ?? When you delete the BENEFITTYPE from the web page, you want to delete all the BENEFITS associated with it...

Make sure that there is no other triggers created for the table using

sp_helptrigger

Linto

I got an error while trying to run a query in a similiar way..

Whats the difference??

I got this error message

Server: Msg 207, Level 16, State 3, Line 1

Invalid...

I don't see a reason why we are going away from the current one!!

If you want a different logo, try entirely different one, instead of building based on existing one.

Linto