Hi

I have tried With the following code...

Is It Possible to pass the data type dynamically

Hi,

I m sorry. I have missed sp_executesql . Thanks. Working fine

Hi,

I have tried with the modified query as follows

Declare @ColumnName as Varchar(50)

declare @ssql nvarchar(200)

Set @ColumnName ='Column1'

set @ssql = 'Alter table shalinitestAdd ' + @ColumnName + ' int'

But...

Hi Jeff,

Thanks a lot, Working Perfectly after converting in to stored procedure

Jeff Moden (5/3/2008)

---

First, take a look at the URL in my signature to get better help, faster. 😉

Following my own "rules", here some test tables and some test data...

--=====...

hi jeff

As of now my requirement is i have to clone the item based on the locationid. so i have insert the recipe and recipelineItem based on the location.When...

Hi jeff

Consider the table structure would be

RecipeId RecipeName LocationId

1 chicken ...

Hi Jeff

I m getting error when i get the query based on some condition as i have mentioned in previous post

Hi,

I will get these id in the gui.I have prob with the query bcoz if i give some thing like this SELECT @MaxRecipeId = MAX(RecipeId)

FROM Recipe Where...

Hi jeff

This is just like copying the recipes and its corresponding lineitem from one location to other location to reduce the time of dataentry for the user to maintain in...

hi Jeff

This is to implement some cloning functionality in my application

hi Jeff Moden

Thanks for ur reply the same result i have expected.

hi

I have Table name as Recipe

RecipeId Name......

1 Chicken

2 ...

Hi

I need to fetch the record by each row and get their id and update these id in the other table

For ex:

I have an user table with the...