SQL Experts Ravali - Urgent help

[vivek1234]

how to execute dynamic sql in cte... Koncham sample code pampinchandi please.... 

 

Below sql is working for regular sql, but i have dynamic sql, please let me know how to replace the below sql with dynamic sql.

 

With CTE AS 

(select id, date from table 1, table 2,....)

(select min(date), id from CTE group by id)

 

 

 

 

[vivek1234]

LTT

[vivek1234]

Sql experts evaru leda db lo ...

[BillMarkSteve]

9 hours ago, vivek1234 said:

how to execute dynamic sql in cte... Koncham sample code pampinchandi please.... 

 

Below sql is working for regular sql, but i have dynamic sql, please let me know how to replace the below sql with dynamic sql.

 

With CTE AS 

(select id, date from table 1, table 2,....)

(select min(date), id from CTE group by id)

 

 

 

 

Select * from cte

 

Ani execute chesi chudu

[BillMarkSteve]

With CTE AS 

(select id, date from table 1, table 2,....)

(select min(date), id from CTE group by id)

 

Lekapothe...ee code tho view create chesi...

Select * from dbo.view