DiverMarv, let me see if I understand you problem correctly
You have similar table in different databases
DB1 has table T1 with columns A(identity), B, C
DB2 has table T2 with columns D(identity), B, E
DB3 has table T3 with columns G(identity), B, F
You wish to store all the date of T1,T2 and...
Hi CherrySoda, Beware of being in a position where you have little opportunity to improve yourself. I am glad that you are one of those who take initiative and learn new stuff on your own. Although your situation right now may be far from ideal, you do have the benefit of knowing more than...
thanks for the feedback guys.
Just fyi, I am planning on following SantaMufasa's and RiverGuys's suggestions. I have decided to talk with my friends in other places and see what interests me before jumping ahead for further education.
Dear SQLSister, thanks for reality check. Now that I...
Hi
Just want to get other opinions on my current situation. I did my BS, MS in Comp. Sc. & Engg. and I have been working as an Application Developer (C and Unix) for 2.5 yrs now.
In the past few months, I realized that I have lost a lot of my hunger for new experiences. It feels like I have...
danvlas,
In order to check the number of pages, I would have to run the 'SELECT COUNT(*)...' query to find out what the total number of records are that match my criteria. If possible I would like to avoid duplicating the query within the WITH {} statement since that is a complex query and...
Hi,
I have recently written some stored procedures in sql server and I have run into the following problem for which I cannot find any solution .
Here is the scenario:
I have a table of 100 tickets. the status of a ticket can be open/closed/canceled. It is the duty of 5 people (say...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.