its not necessary to have dynamic sql

i had tried with normal query but didnot work so tried iwith dynamic sql

the out needed is display

1) date,amt with the given...

i think query is unclear

Transcation tbl has transcationdate, amount and cid

Mas_C has cid and cname

Transcation date displayed will be from & todate passed from the application

1) the output needed...

swap what?

i am not getting any results

sql2008r2 instance was installed as a network server

when selected the 2008r2 from network server and attached the db it worked

how do i make it as a local server

on a standalone...

i have 2005 also installed

and 2008 r2 both

when i am trying to connect i get 2 server names in the dropdown

1) local

2) systemanme/sqlexpress which is 2005

when i use...

getting incorect syntax near =

sample data attached

i hope this is the proper for you to proceed

Thanks for the valuable info

But i need this way

but this gives error

whts the correct way?

If exists (select 1 from #1_TEMP where Status= 'd') and exists (select 1 from #1_TEMP...

SELECT

''As RefNo,

'' AS ERPItmDesc,

'' as TDesc,

'' as Item Description,

'' as Date,

0 as ID

FROM TBLDETAIL FM INNER...

i tried with full outer join but not getting the result

used INSERT INTO table2(frmdt,todt)

SELECT ca.frmdt,ca.todt

FROM table1 t

CROSS APPLY(SELECT FDT1, TODT1

UNION ALL

...

currently the data is inserted as

frmdate todate

2009-12-14 ...

solved

i have a int column as Custid

initally value is balnk.

but i have set the default value when creating the field as 0

i need to increment the max Custid value

but if...