|
How can I change column orders by Transact Sql in Sql Server 2005?
I can do it in sql server 2000 by updating colid in syscolumns table . but sql server 2005 does not allow us to update system tables directly.
please help me. 
modified on Friday, March 7, 2008 9:52 AM
|
|
|
|
|
|
Hi,
I'm designing a reporting program that is being fed with a pre-defined and pre-filled dataset(passed with constructor to report form).The data set is consist of 2 tables and both of them are needed to display.I maked an exact replica of that dataset with dataset designer and dragging fields to report(Reporting Services Report).But the problem is only the first table of dataset is recognised and whille adding any field of of second one to Details section of report , designer produces something like this:
First(Fields!QTY,"Bill_OrderDetails")
(Bill is the replica Dataset and orderdetails is the second table)
and removing First Function causes compiler complains about not using
an aggergate function in detail section.
How can I use the second Table?
|
|
|
|
|
Hi,
I have 2 Tables with each his own columns
but they have both 1 identical column
I want to make a 3th table with the identical columns in
but not twice the same!
For example:
Table 1: ID1,Title,pages
Table 2: ID2,Title,Author
Table 3: ID3,Title (but when my title is the same in table1 and table2 i only want to insert it once)
So i thought,
I insert whole table1 in table3
then with a cursor, run through table2
and if i don't find the value in table3 insert Title from table2 in Table3
Is there another work around?
Thanks,
A.
|
|
|
|
|
Are the IDs in tables 1 & 2 the same? If not, what value will you insert into column ID3 in table 3 when you find matching rows?
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Insert into table3
(ID3,Title,xxx)
Select ID1,Title,pages from Table1
Union
(Select ID1,Title,author from Table2
Where Title Not In (Select Distinct Title From Table1))
Best Regards,
Chetan Patel
|
|
|
|
|
Thank You,
I was looking way to far, for a solution...
|
|
|
|
|
i enter data in table at this order
kamal 78
kamal 78
kamal 78
kamal 45
kamal 45
mohan 12
mohan 12
suresh 23
suresh 23
ram 78
ram 78
mahi 23
mahi 23
and i want to display data on this like [note display according entry]
out put
name amount timeofpaid
kamal 78 3
kamal 45 2
mohan 12 2
suresh 23 2
ram 78 2
mahi 23 2
no knowledge in .net
|
|
|
|
|
You can do it with the help of Group By clause and count function.
Parwej Ahamad
g.parwez@gmail.com
|
|
|
|
|
by using group by clause and count function
never give correct format according the order of entry in table
no knowledge in .net
|
|
|
|
|
select count(amount) as appeartimes,[name]<br />
from tablename group by amount,[name]
I Love SQL
|
|
|
|
|
Mr blue boy
i want to display record in order as entry in table
like first time kamal pay 78 amount three time then pay 45 amount two time
in table
according entry order i want display record
kamal 78 3
kamal 45 2
such like that
ur quiry never give actual format like entry
no knowledge in .net
|
|
|
|
|
hope this helps
select name,count([amount]) as timeofpaid<br />
from tablename group by [name],amount order by name,timeofpaid
I Love SQL
|
|
|
|
|
i have a column of datatype string in the sql server 2000 database.
following is the data in that table
1
2
11
12
a
if i sort the data then output comes in the following manner
1
11
12
2
a
, but i want 1 2 11 12 a
to sort out this problem i thought to make two unioun queries
to fileter the numeric values and alphanumeric values.
no the questio is can somebody tell me how to filter the numeric and alphanumeric values .
Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.
|
|
|
|
|
Don't double post, it's rude.
|
|
|
|
|
i want to use the DateDiff() procedure of VB6.0 but iam getting Run-time error 5: Invalid Procedure call or Argument.i want to know the exact syntax of using DateDiff() procedure.
Thanx & Regards.
Success is not a Destination,
... But a Journey !!
|
|
|
|
|
If this is a VB6 method, using VB6 objects, then it's not really SQL, or am I misunderstanding you ?
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Sorry i didn't get you.
Thanx & Regards.
Success is not a Destination,
... But a Journey !!
|
|
|
|
|
He means - this is not a SQL question. It's a VB6 question - hence it shouldn't be in the SQL forum.
|
|
|
|
|
Try pressing F1 for help.
Also, VB6 is not a SQL question.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Ashfield wrote: Also, VB6 is not a SQL question
Nope. It is questionable though.
|
|
|
|
|
i don't have MSDN installed.
Thanx & Regards.
Success is not a Destination,
... But a Journey !!
|
|
|
|
|
Well try the granddaddy of all things, google!
To help, here's a link to vb6 functions
Visual Basic Command Syntax
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Thanx. Sure it is very helpful to me and for all the others who are beginners. Thanx.
Thanx & Regards.
Success is not a Destination,
... But a Journey !!
|
|
|
|
|
While trying to process multiple select statement and retreiving files from my database I get the following message:
"ContextSwitchDeadlock was detected
Message: The CLR has been unable to transition from COM context 0x271130
to COM context 0x2712a0 for 60 seconds. The thread that owns the destination
context/apartment is most likely either doing a non pumping wait or
processing a very long running operation without pumping Windows messages.
This situation generally has a negative performance impact and may even
lead to the application becoming non responsive or memory usage accumulating
continually over time. To avoid this problem, all single threaded apartment
(STA) threads should use pumping wait primitives (such as
CoWaitForMultipleHandles) and routinely pump messages during long running
operations."
How do I resolve this problem, I am using C# and SQL Server.
Thanks in advance,
Michael
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
