Viewing 15 posts - 1,861 through 1,875 (of 2,452 total)
SQL Mad Rafi (7/9/2012)
Dear All,Is it possible to insert a column into a table at any place,
.
as others have already said...the answer is yes.
but why would you want to ?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 9, 2012 at 6:11 am
you could try something along these lines
EXEC sp_MSForEachTable 'SELECT top 3 * FROM ?'
sp_MSForEachTable is undocumented...suggest you do some research.
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 9, 2012 at 2:56 am
suggest you read the following article on this site....
http://www.sqlservercentral.com/articles/T-SQL/88244/
hope it helps.
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 9, 2012 at 12:49 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 8, 2012 at 1:00 pm
http://www.sqlservercentral.com/Forums/FindPost1326539.aspx
did you have time to to take a look at my post above?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 8, 2012 at 12:54 pm
Gullimeel (7/7/2012)
Post the plan of your query and ddl for tables.People might be able to help u on getting your query optimized..
are you able to provide a " create...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 8, 2012 at 12:15 pm
forefj (7/8/2012)
As I mentioned I don't want to post everything for privacy reasons and I would now have to go...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 8, 2012 at 10:49 am
...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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 8, 2012 at 9:59 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 8, 2012 at 9:50 am
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,...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 8, 2012 at 2:55 am
forefj (7/7/2012)
I am still somewhat new working...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 8, 2012 at 1:11 am
forefj (7/7/2012)
I am still somewhat new working...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 7, 2012 at 3:10 pm
forefj (7/7/2012)
I can't. Some of the items in the query have been changed as well for...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 7, 2012 at 1:59 pm
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 7, 2012 at 1:36 pm
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 7, 2012 at 1:32 pm
Viewing 15 posts - 1,861 through 1,875 (of 2,452 total)