Viewing 15 posts - 31 through 45 (of 46 total)
IF EXISTS(SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[StringToTable]'))
DROP FUNCTION [dbo].[fnDStringToTable]
GO
--This UDF will split a delimited list into a single column table.
CREATE FUNCTION dbo.StringToTable
(
@list NVARCHAR(4000)
, @delimiter NCHAR(1) =...
April 17, 2008 at 2:46 pm
thankyou ................i will try with this.................
April 14, 2008 at 8:27 am
Columns names are aa,bb,cc,dd
in the prev post
for Example.............
address phonenum ...
April 11, 2008 at 12:55 pm
we dont need the table name.........just need to display the attachments to it...........
all the table names are present in another table.................
April 7, 2008 at 1:19 pm
thanks...........
i need to search for data next to _ref
April 7, 2008 at 12:48 pm
'hello' is not the specific name.............we have different data in place of that..............data is dynamic.............and also we have like
tblname _ref.data and
tblname.data1
we need to get data(-ref fields) and data1...
April 7, 2008 at 12:00 pm
'hello' is not the specific name.............we have different data in place of that..............data is dynamic.............and also we have like
tblname _ref.data and
tblname.data1
we need to get data(-ref fields) and data1...
April 7, 2008 at 11:55 am
i am looking for data inthe columns...........data means in the column which are attached to _ref.
April 7, 2008 at 11:35 am
thanks for ur response..
i need to search for a column names which are present in a table in the below format..
tablname_ref.ColumName1
tablname_ref.ColumName2
tablname.ColumName11
tablname.ColumName22
i need to retrieve the ColumName1 from
tablname_ref.ColumName1
and...
April 7, 2008 at 9:57 am
the comparison of columns is not for particular tables.................
for every ObjectID it need to get the columns and compare...........
if we have ObjectID like 1,2,3
it loops 3 times and every...
April 4, 2008 at 12:34 pm
thanks for ur reply...
we have two tables VMR AND B_VMR
B_VMR is original table
VMR is updated table
and we need to compare these two tables( not particular after every iteration tables...
April 4, 2008 at 11:46 am
if we use left join we display all records in left table.......but we need to display only new record.........
March 31, 2008 at 10:11 am
i have a bunch of tables to be compared.........all the table names are in one virtual table.............
thanks for ur response
March 31, 2008 at 8:02 am
they asked to use curser becoz it needs to check the records every time for the changes for every baselineobject...........
March 30, 2008 at 11:07 am
Viewing 15 posts - 31 through 45 (of 46 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy