Hi,

I have modified my query which I have posted earilier... try this ...

create table #temp (name VARCHAR(100), first_name VARCHAR(50), last_name VARCHAR(50))

truncate table #temp

INSERT INTO #temp (name) ...

HI,

Try the below code.....

create table #temp (name VARCHAR(100), first_name VARCHAR(50), last_name VARCHAR(50))

INSERT INTO #temp (name)

SELECT 'FIRST+LAST'

UNION...

Thank you very much for the replies. I want to suggest the person who downloads the master table to make correct data types while downloading. Thank you.

Try this....

declare @wordstr varchar(500)

set @wordstr = ' '

select @wordstr = @wordstr +letters from dbo.alpha

select ltrim(rtrim(@wordstr))

Hi,

I found the solution...

When I used cast(convert(varchar(10),a.Created_date,101) as datetime) in second query it is working...

thanks,

Nagesh

Create proc [dbo].[pAddNewThemeSCheme] (@themeID int, @label varchar(50), @isActive bit, @folderName varchar(50))

As

--themeID needs to be existant in the table Theme

Declare @TID int

...

Thanks to all. That servers my requirement.

Thanks once again :Whistling: :satisfied:

Nagesh

Try this..

select * from mytable where isnull(ltrim(rtrim(status)),'')<>''

sory for the late reply...

I have tried @@servername, it is giving servername but how can I get ip address?

I want to find out the IP thru stored procedue...

Nagesh

[highlight=#ffff11]why are you converting date variables to varchar as you are supposed to insert date?

Mahesh [/highlight]

If I don't convert date variables to varchar in that dynamic query it will give...

I tried like this

-------

CREATE TABLE [dbo].[custom_table](

[id] [int] IDENTITY(1,1) NOT NULL,

[int] NULL,

[description] [varchar](3000) NULL,

[Due_date] [datetime] NULL,

[completed_date] [datetime] NULL,

[isactiveflag] [int] NULL)

declare @insertsql varchar(2000), @dt1 datetime,@dt2 datetime, @desc varchar(100),@dt3...

hi, thanks for reply

My table is like

CREATE TABLE [dbo].[custom_table](

[id] [int] IDENTITY(1,1) NOT NULL,

[int] NULL,

[description] [varchar](3000) NULL,

[Due_date] [datetime] NULL,

[completed_date] [datetime] NULL,

[isactiveflag] [int] NULL)

and when we insert null values...