|
Watch using Access to SQL as Microsoft helps you by creating columns that are NOT what is wanted.
I have to live with postal code being a float because the person moving data from Access to SQL did not know what they were doing. As long as we only do work in the US it is not a major problem but comparison can be tricky.
|
|
|
|
|
Hello,
We are retiring our older server, not yet, in place going to have a new server. WE need to name the new database server as our current one. Can we have two such database servers at a given time? How can we migrate from one server to another with no lag time, since it is the production server constantly collecting data.
Thank you.
|
|
|
|
|
Hi,
vanikanc wrote: WE need to name the new database server as our current one
First let's separate two totally different things:
- the name of the database server is just an alias for the IP-address. So this means that you cannot have two different machines having the same name (thus the same IP-address) at the same time or you'll have enormous problems in you network
- the name of the SQL Server instance (the service) is used to distinguish separate SQL Server services on the same machine.
So basically your question is client-related. If you want to make the switch-over to the new (physical) server you have to be able to re-configure your clients to start using the new server. For example if your old SQL Server is ServerProduction1\Instance1 (meaning for example 10.1.123.1,1433\Instance1) you would change the client to connect to ServerProduction2\Instance1 (meaning for example 10.1.123.7,1433\Instance1). Of course the instance name can also be changed.
vanikanc wrote: Can we have two such database servers at a given time?
So the answer from the client side point of view is no. Which one would they connect to?
vanikanc wrote: How can we migrate from one server to another with no lag time, since it is the
production server constantly collecting data
You restrict the changes to the original database during the transfer, transfer all the data from server 1 to the server 2, re-configure the clients to connect to server 2 and off you go.
|
|
|
|
|
guys i have a table with a self-referencing relationship.
I want to get the child records listed just below their parent.
just like:
id parent value
--- ------ ------
1 null node 1
4 1 node 1/1
6 4 node 1/1/1
5 1 node 1/2
7 1 node 1/3
2 null node 2
3 null node 3
8 3 node 3/1
any help;
Help people,so poeple can help you.
|
|
|
|
|
Include the parent id and the child id in each record and then include them as the first two fields to sort by.
select p.id
,c.id
, .....
from some_table p
,some_table c
where p.id = c.parent_id_field
sort by p.id, c.id
Chris Meech
I am Canadian. [heard in a local bar]
In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]
posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]
|
|
|
|
|
but sir, what about multi-level threads?
Help people,so poeple can help you.
|
|
|
|
|
You will need to know how many levels deep you want to go and join the table for each level. You might also be able to use a view to help with that.
Chris Meech
I am Canadian. [heard in a local bar]
In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]
posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]
|
|
|
|
|
i can't tie a user hands.
is there "Recursion" in sql server.
Help people,so poeple can help you.
|
|
|
|
|
Ali Al Omairi(Abu AlHassan) wrote: i can't tie a user hands.
Sometimes, I wish I could do that.
Chris Meech
I am Canadian. [heard in a local bar]
In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]
posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]
|
|
|
|
|
|
Over my head, mika;
you are still the best.
100
Help people,so poeple can help you.
|
|
|
|
|
Thanks, but frankly I believe that this site has a bunch of real experts thus making CP so special. No other site I've come across has so positive and professional attitude at the same time as this.
|
|
|
|
|
CREATE TABLE #data
(
ID INT NOT NULL,
PID INT NULL,
VALUE VARCHAR(20) NOT NULL
);
INSERT INTO #data
(ID, PID, VALUE)
VALUES
(1, NULL, 'node 1'),
(4, 1, 'node 1/1'),
(6, 4, 'node 1/1/1'),
(5, 1, 'node 1/2'),
(7, 1, 'node 1/3'),
(2, NULL, 'node 2'),
(3, NULL, 'node 3'),
(8, 3, 'node 3/1');
WITH MyCTE AS
(
SELECT ID, PID, VALUE, 0 AS [LEVEL]
FROM #data
WHERE PID IS NULL
UNION ALL
SELECT D.ID, D.PID, D.VALUE, [LEVEL] + 1
FROM MyCTE M
JOIN #data D
ON D.PID = M.ID
)
SELECT ID, PID, VALUE, [LEVEL]
FROM MyCTE;
DROP TABLE #data;
|
|
|
|
|
thank you Russell.
100
|
|
|
|
|
About me adam763 aadams
CaringIn Action adam763 aadams
LocalBusiness adam763 aadams
From My Desk adam763 aadams
About me agga924 aaggarwal
From My Desk agga924 aaggarwal
LocalBusiness agga924 aaggarwal
About me aldr231 aaldridge
From My Desk aldr231 aaldridge
About me alkh290 aalkhazshvilly
LocalBusiness alkh290 aalkhazshvilly
From My Desk alkh290 aalkhazshvilly
About me alti800 aaltis
From My Desk alti800 aaltis
About me arev258 aarevalo
From My Desk arev258 aarevalo
About me arri922 aarriaga1
From My Desk arri922 aarriaga1
About me bakk607 abakken
bout me bart768 abarton
From My Desk bart768 abarton
i need the data to be present as
in the first column repeated text is there
for suppose Title TitleCount
About Me 23
after this i have to display
Title UserName Usersite
About Me barttt xxxxxx
About Me xxxx xxxxx
About Me xxxx xxxxx
|
|
|
|
|
I may or may not be responsible for my own actions
|
|
|
|
|
what are you trying to say
|
|
|
|
|
Your post makes very little sense. Can you try and better explain what you are trying to do as at the moment all you have is a list of poorly formatted values
I may or may not be responsible for my own actions
|
|
|
|
|
do you mean you want to group data?. if so, use <a href="http://www.w3schools.com/sql/sql_orderby.asp" target="_blank" >order by</a> .
Help people,so poeple can help you.
modified on Friday, March 11, 2011 2:16 PM
|
|
|
|
|
How can ORDER BY help in GROUPING data ? (I think you meant GROUP BY)
|
|
|
|
|
or group by, but why to use it scinse there is no need to use aggregate functhins.
in addition order by also sort data
100
Help people,so poeple can help you.
|
|
|
|
|
Of course he need a aggregate function, for the title count ...
|
|
|
|
|
So, you are the one with the answer below. ok i admit that i misread.
shall you forgive my mistake!
100
Help people,so poeple can help you.
|
|
|
|
|
I'll forgive you )))
Just wondered that you said 'grouping items' and than advise 'order by' - that confused me
Anyway, I'm glad to be able to share your community !
Regards,
kwk
|
|
|
|
|
Klaus-Werner Konrad wrote: that confused me
you shouldn't be (i am not familiar with database)
100
Help people,so poeple can help you.
|
|
|
|