i have below two tables,and am trying to create a view using below statements.

also wants to apply index on view, i cannot apply index on views with UNION.

so i want...

Hi,

Want to combine two select queries in to one by excluding UNION.

Hi Team,

We are using the same record_id in multiple tables, so the other tables which are using record_id column also should not update until the commit / rollback.

Thank You,

Its working.

without "old_val, new_val" trigger is working fine,want to add the old and new values to know which value is udpated to what.

please help in query.

Thanks its working good.

also wants to delete from table before insert.

is it possible in this view...

i Know Joins, but wants to know the syntax to replace below query with value in another table..

+ISNULL(u.code,'')+' '

Dont know how to join while concatenating the two strings.

Please help

Table : Unify

id desc code

1 HSBOM 002

table 'JKS'

code | Desc

-------------

001 | LCC

002 | HHT

003...

Yes wants to join the two tables, in first table am trying to get the values as a single string, and i want to get the code from second table...

Thank you for suggestions.

Is there any third party tools or SQL Server tools to compare the DB's and generate automatic scripts to sync.

Is SQL Database manager will help on this...?

Please...

Hi Team,

Below code is working.

with base as (

select

*,

rn = row_number() over (partition by user_name order by access_time desc)

from dbo.library

)

delete from base where...

access_time field is the accessed time of user, want to keep the recent 50 entries and delete all the remaining for every user.

Numeric values in the first query should be converted to INTEGER.

Hi,

first query result :

1

2

11

20

32

68

100

124

246

256

second query result

A1

A10

A11

AB1

AB10

B1

B2

B21

B31

want to generate the complete output in single select statement.