Koen Verbeeck (4/13/2012)

patelmohamad (4/13/2012)

Agree with you koen but the column indexing will be lost in it and in my next step i have used the same statement but with where...

Koen Verbeeck (4/13/2012)

I did read the question. Do you think I randomly type stuff in forum topics?

I did have to guess...

Hi Koen,

Please read my question then suggest some better solution,

before posting My question on Sqlservercenteral.com...

Hi Sean,

this the Actual function which has been used in many procedures and in functions,

the use of the "GetDeviceLogData_SpecifiedTime" is depend upon procedures

i need Latitude,Longitude. and in some...

Hi sean,

the UDF which i have created is

Table1 is the Clone copy of Table2 for fast process we are transfering the data from table2 to table1

hope you understand the...

Hi,

I have done some calculation internally which is required... but that calculation has to been done each and every time i calls the procedures or write any other..

is it good...

BEGIN

SET NOCOUNT ON

DECLARE

@RowIndex INT

,@RowCount INT

,@Name VARCHAR(300)

,@SQLQuery VARCHAR(MAX)

IF NOT OBJECT_ID('tempdb..#tempCheckDatabase') IS NULL

BEGIN

DROP TABLE #tempCheckDatabase

END

SELECT

Identity(INT ,1 ,1) AS RowID

,NAME AS DBName INTO #tempCheckDatabase

FROM sys.databases WITH (NOLOCK)

SELECT

@RowCount...

Hi guys,

I found the solution

it's in Options "Results in TEXT" Just uncheck the "Include column headers in result set"

Thanks

Thanks guys

and Gianluca thank you once again for posting a article of Kalen Delaney

it gives the details of the Temptable

Thanks Gianluca Sartori

Thanks guys for your precious suggestion

Hi Sean,

Agree with you but in Asp.Net application we holds the data in DataTable,List or Dataset Basically the Data holder and then display in grid, my question is same for...

Hi Sean,

Thanks for your valuable suggestion, and i have implemented and search other things and discovered

Please have a look and suggest if i am missing something...

SET NOCOUNT ON;

DECLARE...

Thanks sean,

Agree with you,

my solution is little bit slow... but my question is to search a respective data in any of the column of the database tables.

Hope i...

hope you will get my point