Try Imceda Coefficient

Thanks,

Ganesh

Pls follow the link. You will get the code too 🙂

http://www.winnetmag.com/SQLServer/Article/ArticleID/27520/27520.html

Thanks,

Ganesh

What is the data type of the column.

Try giving DATALENGTH rather len.

Do this if you running the query output to grid.

Run the query,...

Third one sounds good.

Thanks,

Ganesh

I would change the second query like this.

insert into tblAllRecords(field_list)

select field_list from tblNewRecords new

where not exists( select 1 from tblAllRecords where field1...

Step 1: Drag and Drop the Dynamic properties in the designer

Step 2: Right click on the Designer window - > Click Package Properties -> Global Variables

...

You will get what you need 🙂

Pls follow the link

http://www.aspfaq.com/show.asp?id=2462

Thanks,

Ganesh

Have a nice day unless you have other plans

can you be more clear on your question.

I mean with an example with what you have and what you want.

Thanks,

Ganesh

From the Query analyser, you can try using templates.

I hope it will be more meaningful than the wizard from Sql Enterprise Manager.

Thanks,

Ganesh

Both of these functions are not deterministic. Therefore, they cannot be used inside a UDF. You can work around this by putting them into a view and then referencing...

I have modifed the code which is highlighted in red. I hope I understood the problem. Pls do adjust if it doesn't help you.

create table #temp ( col1 int, col2...

From your question, I presume the ID column is unique else pls modify the following code to push the data to a temporary column with an identity column and loop...

I hope this url would solve your problem.

http://groups.google.co.in/groups?q=exporting+sqlserver+excel+cell+formatting&hl=en&lr=&ie=UTF-8&selm=c5fhe8u8BHA.1532%40cpmsftngxa08&rnum=3

Thanks,

Ganesh

Pls ref BOL.

A. Alter a  to add a new column

This example adds a column that allows null values and has no values provided through a DEFAULT definition. Each row...

Try this out....

EXEC sp_rename 'bcp_ki_city', 'bcp_city'

Thanks,

Ganesh