as others have already said...the answer is yes.

but why would you want to ?

you could try something along these lines

EXEC sp_MSForEachTable 'SELECT top 3 * FROM ?'

sp_MSForEachTable is undocumented...suggest you do some research.

suggest you read the following article on this site....

http://www.sqlservercentral.com/articles/T-SQL/88244/

hope it helps.

just for clarification on my part...

in a previous post you mentioned

" It is SQL Server 2000 and I using Management Studio 2008 to connect. I search for some documentation but...

http://www.sqlservercentral.com/Forums/FindPost1326539.aspx

did you have time to to take a look at my post above?

are you able to provide a " create...

forefj (7/8/2012)

---

What I was looking for was what Grant Fritchey finally posted.

As I mentioned I don't want to post everything for privacy reasons and I would now have to go...

...small sidebar

why

CONVERT( datetime , CONVERT( nvarchar , TT.TDDATE , 113 ) , 113 )

TDATE is a datetime...as below

CREATE TABLE [dbo].[INITIAL](

[TN] [numeric](15, 0) NULL,

[WH] [nvarchar](4) NULL,

[TDDATE] [datetime] NULL,

for example:

select CONVERT( datetime...

Welsh Corgi (7/8/2012)

---

The problem is that most of the tables do not have Insert, Modified Date on them so they can't just select on the Datetime stamps.

On the smaller tables...

try this......let us know if this is anywhere near your requirements

regards

CREATE TABLE [dbo].[Customer](

[CustomerID] [int] NULL,

[LinkID] [int] NULL,

[Name] [varchar](50) NULL,

[Customerkey] [int] NULL

) ON [PRIMARY]

GO

INSERT INTO [dbo].[Customer]([CustomerID], [LinkID], [Name], [Customerkey])

SELECT 1, 1,...

forefj (7/7/2012)

---

I read Jeff's posting, especially the part about people posting for homework assignments or a job interview - neither apply in my case.

I am still somewhat new working...

forefj (7/7/2012)

---

I read Jeff's posting, especially the part about people posting for homework assignments or a job interview - neither apply in my case.

I am still somewhat new working...

forefj (7/7/2012)

---

Thanks for the feedback. I would post the data but for security reasons

I can't. Some of the items in the query have been changed as well for...

a suggestion

if you can provide some 'create table' scripts for your relevant tables and some sample data...say 20 rows (insert data)....then someone maybe jump in and help

edit>>...and your expected results...

Hi...a suggestion

provide the DDL (create table statement) and sample data (insert data) for table 'INITIAL' ...lets say 100 rows

also the definition of 'View_STK_WITH_ARC'

and based on the sample data you...