Help for a one year fresher to enter the software industry

Dear Freinds,
I am hoping a postive answer from this group. I have done my
graduation currently and looking for a break in programming in C# or
VB.NET with SQL Server. After graduation i joined a computer institute
and did a one year course there. For first six months i was nearly
taught nothing. But later some how i started to read things on my own.
After one year i have started attending interviews. But the questions
asked are so much out of topic sometimes. I can completed sample
projects. What should i do because after one year i have come to know
that questions in interviews are so different from actual projects.
For instance i was asked about SOA , damn it i have no idea about that
stuff. I am also reading interview questions and answers from
http://www.questpond.com but i am still not able to cope up.
Please help what approach should i take now. 1 year is a big time
freinds.<mrnagrajan@.yahoo.co.in> wrote in message
news:1192384727.480633.43080@.y27g2000pre.googlegroups.com...
> Dear Freinds,
> I am hoping a postive answer from this group. I have done my
> graduation currently and looking for a break in programming in C# or
> VB.NET with SQL Server. After graduation i joined a computer institute
> and did a one year course there. For first six months i was nearly
> taught nothing. But later some how i started to read things on my own.
> After one year i have started attending interviews. But the questions
> asked are so much out of topic sometimes. I can completed sample
> projects. What should i do because after one year i have come to know
> that questions in interviews are so different from actual projects.
> For instance i was asked about SOA , damn it i have no idea about that
> stuff. I am also reading interview questions and answers from
> http://www.questpond.com but i am still not able to cope up.
> Please help what approach should i take now. 1 year is a big time
> freinds.
>
Welcome to the real world. (You didn't mention what part of it. That might
help. You may have to leave.)
Landing a first job with no employment experience is tough. Beyond the
obvious -take a shower, clean your nails, and look interested - there is no
simple answer.
You will be hired eventually because an employer thinks you can be a benefit
for him and he likes you. Sometimes all you need is to be likeable. Do
whatever you can to be likeable and appear useful.
For how to be likeable, getting some books, attending some emploment
seminars, etc. may help. Researching as much as you can about the employer
and the job will help you to appear useful.
Beyond that it is all BS, and gaming with a slightly irrational opponent in
charge of the rules. But if you keep plugging it will happen. That's the
positive.
-ralph|||On Oct 14, 1:58 pm, mrnagra...@.yahoo.co.in wrote:
> Dear Freinds,
> I am hoping a postive answer from this group. I have done my
> graduation currently and looking for a break in programming in C# or
> VB.NET with SQL Server. After graduation i joined a computer institute
> and did a one year course there. For first six months i was nearly
> taught nothing. But later some how i started to read things on my own.
> After one year i have started attending interviews. But the questions
> asked are so much out of topic sometimes. I can completed sample
> projects. What should i do because after one year i have come to know
> that questions in interviews are so different from actual projects.
> For instance i was asked about SOA , damn it i have no idea about that
> stuff. I am also reading interview questions and answers fromhttp://www.questpond.combut i am still not able to cope up.
> Please help what approach should i take now. 1 year is a big time
> freinds.
Two Things.
Firstly, try to go through as many interviews as possible. Usually for
every 15-20 resumes that you send out, you should expect a response of
1. And that is assuming your resume is in line with the job you are
applying for. Keep a track of the jobs you are applying to, what
skills are required, do you show case them in your interview, etc.
You don't have to have experience. But you have to know your stuff. So
e.g. for SOA, try spending a few hours every day learning new
technology. Read an article on WIKI about what SOA is. Then read about
web services. Maybe try building, and consuming a web service in C#.
Learn something new that you see on job listings, but you are not too
sure or confident about.
Stop wasting your money and time going to institutes. At the end of
the day, you will learn the most from your own practice.
Secondly, it is generally easier to get into a entry level QA or
Application Support role than is to get into development. You need to
have good communication skills though, so if you need, work on that as
well. Again, go through as many interviews as possible. The more you
get turned down, the harder you will become, and the better you will
be at the next interview.
I got a job at Bell Canada (Customer Service) working as a Sales Rep
selling TV channels to subscribers. I was making $10 an hour. I kept
giving interviews and stayed sharp with my tech skills. I ended up
getting a job as a Support Analyst with a Bank's IT firm next. I was
making $16 an hour. I still kept updating my skills. I am now an
Intermediate .Net developer with a multi national, making a lot more
than that :)
Keep at it, you will find your way.|||Ralph wrote:
> <mrnagrajan@.yahoo.co.in> wrote in message
> news:1192384727.480633.43080@.y27g2000pre.googlegroups.com...
>> Dear Freinds,
>> I am hoping a postive answer from this group. I have done my
>> graduation currently and looking for a break in programming in C# or
>> VB.NET with SQL Server. After graduation i joined a computer
>> institute and did a one year course there. For first six months i
>> was nearly taught nothing. But later some how i started to read
>> things on my own. After one year i have started attending
>> interviews. But the questions asked are so much out of topic
>> sometimes. I can completed sample projects. What should i do because
>> after one year i have come to know that questions in interviews are
>> so different from actual projects.
>> For instance i was asked about SOA , damn it i have no idea about
>> that stuff. I am also reading interview questions and answers from
>> http://www.questpond.com but i am still not able to cope up.
>> Please help what approach should i take now. 1 year is a big time
>> freinds.
> Welcome to the real world. (You didn't mention what part of it. That
> might help. You may have to leave.)
> Landing a first job with no employment experience is tough. Beyond the
> obvious -take a shower, clean your nails, and look interested - there
> is no simple answer.
> You will be hired eventually because an employer thinks you can be a
> benefit for him and he likes you. Sometimes all you need is to be
> likeable. Do whatever you can to be likeable and appear useful.
> For how to be likeable, getting some books, attending some emploment
> seminars, etc. may help. Researching as much as you can about the
> employer and the job will help you to appear useful.
> Beyond that it is all BS, and gaming with a slightly irrational
> opponent in charge of the rules. But if you keep plugging it will
> happen. That's the positive.
> -ralph
Lots of good advice in the two response so far. I second most everything
they said.
That said, I'd like to add:
English apparently isn't your native language, so you should get used to
using spell checks whenever you even come close to anything/anyone related
to the job market.
To more fully grab interest of the readers, you should add such things as
what degrees you have, in what, and where you earned them, along with any
work blocks and/or part time jobs relevant to your goals that you had while
you were in school.
It's tough to gain experience without a job, and tough to get a job without
experience, but it's a catch-22 you can overcome with patience and
perseverance. The comments so far about taking all the interviews you can
get were good ones. The more interview experience the better you'll be
prepared as you work you way through them all. Besides, you might just come
across an entry level job you weren't expecting to find and if it has any
advancement possibilities at all, it can be a good starting point for a
first job.
One thing I don't think was directly mentioned about sending out resumes
is, try to write a cover letter specific for each industry you apply to.
That gives you a chance to expose your goals and your work ethics, things
that aren't part of the resume as a rule. Ideally a cover letter should
only be one page long and do as good a job selling yourself as you can.
Unless you're strapped for cash, don't instantly grab the first offer you
receive. Most places will understand that you need to "think about it" for
a week or so, giving you time to do more research and think about the
overall prospects. But at the same time, don't overlook one that's just
exactly what you want.
A log book or notebook and some samples of your work are often handy at
interviews too, even if they don't look at them. Just having them is an
indicator of your preparedness.
And lastly, try to appear level-headed as possible, even when something
seriously surprises you or excites you to no end<g>. Those who can see
surprises and unexpected events as challenges are usually at the head of the
line. And then, after all that, "Be Yourself" and show a strong work
ethic.
Best of luck,
Pop`|||On Sun, 14 Oct 2007 10:58:47 -0700, mrnagrajan@.yahoo.co.in wrote:
>Dear Freinds,
>I am hoping a postive answer from this group. I have done my
>graduation currently and looking for a break in programming in C# or
>VB.NET with SQL Server. After graduation i joined a computer institute
>and did a one year course there. For first six months i was nearly
>taught nothing. But later some how i started to read things on my own.
>After one year i have started attending interviews. But the questions
>asked are so much out of topic sometimes. I can completed sample
>projects. What should i do because after one year i have come to know
>that questions in interviews are so different from actual projects.
>For instance i was asked about SOA , damn it i have no idea about that
>stuff. I am also reading interview questions and answers from
>http://www.questpond.com but i am still not able to cope up.
>Please help what approach should i take now. 1 year is a big time
>freinds.
I think I see your problem...
Where did you graduate from?|||Hi,
So are you new a team leader? Do you write documentation?
Do you sit any MCIT or other MS cert?
> Secondly, it is generally easier to get into a entry level QA or
> Application Support role than is to get into development. You need to
> have good communication skills though, so if you need, work on that as
> well. Again, go through as many interviews as possible. The more you
> get turned down, the harder you will become, and the better you will
> be at the next interview.
> I got a job at Bell Canada (Customer Service) working as a Sales Rep
> selling TV channels to subscribers. I was making $10 an hour. I kept
> giving interviews and stayed sharp with my tech skills. I ended up
> getting a job as a Support Analyst with a Bank's IT firm next. I was
> making $16 an hour. I still kept updating my skills. I am now an
> Intermediate .Net developer with a multi national, making a lot more
> than that :)
> Keep at it, you will find your way.|||<mrnagrajan@.yahoo.co.in> wrote in message
news:1192384727.480633.43080@.y27g2000pre.googlegroups.com...
> Please help what approach should i take now. 1 year is a big time
> freinds.
1 year is not a long time especially seeing you say you didn't learn
anything for the first 6 months. Did you do any programming before this
year? If not I wouldn't hire you with your current level of training. If
this is your only experience then go back and do some more schooling. There
are a lot of people trying to get into the IT industry with minimal
expericence or training.
Michael|||"Michael C" <mike@.nospam.com> wrote in message
news:%23V2Ho4sDIHA.4584@.TK2MSFTNGP03.phx.gbl...
> .
> There are a lot of people trying to get into the IT industry with minimal
> expericence or training.
And they have succeeded.
www.beyondsql.blogspot.com|||"Steve Dassin" <rac4sqlnospam@.net> wrote in message
news:uvoReBtDIHA.1204@.TK2MSFTNGP03.phx.gbl...
> "Michael C" <mike@.nospam.com> wrote in message
> news:%23V2Ho4sDIHA.4584@.TK2MSFTNGP03.phx.gbl...
>> .
>> There are a lot of people trying to get into the IT industry with minimal
>> expericence or training.
> And they have succeeded.
> www.beyondsql.blogspot.com
You've been involved in IT for some time, right? The IT industry used to be
so desperate for people they'd hire anyone. Now it requires a little more
knowledge :-)
Michael|||"Michael C" <mike@.nospam.com> wrote in message
news:OoSoZQtDIHA.3332@.TK2MSFTNGP04.phx.gbl...
> You've been involved in IT for some time, right? The IT industry used to
> be so desperate for people they'd hire anyone. Now it requires a little
> more knowledge :-)
Oops, I din't mean that to sound like it did :-) I started the same way and
suspect I might have trouble getting in now if I tried with my initial
experience.
> Michael
>|||On Oct 14, 10:51 pm, "Michael C" <m...@.nospam.com> wrote:
> "Michael C" <m...@.nospam.com> wrote in message
> news:OoSoZQtDIHA.3332@.TK2MSFTNGP04.phx.gbl...
> > You've been involved in IT for some time, right? The IT industry used to
> > be so desperate for people they'd hire anyone. Now it requires a little
> > more knowledge :-)
> Oops, I din't mean that to sound like it did :-) I started the same way and
> suspect I might have trouble getting in now if I tried with my initial
> experience.
>
>
> > Michael- Hide quoted text -
> - Show quoted text -
I won't suggest going back to school to this individual. The guy has
already spent some hefty amounts I am sure. He needs to practice and
hone his skills. I also won't say that I would not hire him given his
current technical skills. Maybe he just needs to showcase what he
knows better. I remember when I was starting out, I knew a lot, but I
just didn't have enough interview experience, and I would get sweaty
hands and be nervous.
You need to take all of this advice, see what you think are potential
roadblocks for you, and work them out. Stick it out, take it easy, and
have a strategy.
Asad|||"Michael C" <mike@.nospam.com> wrote in message
news:%23k%230PZtDIHA.4028@.TK2MSFTNGP05.phx.gbl...
> "Michael C" <mike@.nospam.com> wrote in message
> news:OoSoZQtDIHA.3332@.TK2MSFTNGP04.phx.gbl...
> > You've been involved in IT for some time, right? The IT industry used to
> > be so desperate for people they'd hire anyone. Now it requires a little
> > more knowledge :-)
> Oops, I din't mean that to sound like it did :-) I started the same way
and
> suspect I might have trouble getting in now if I tried with my initial
> experience.
Nah, I bet most people would be comfortable with the inference from
the first response :)
Sure, just look into this forum for proof that you need a higher
level of knowledge and understanding today than 10 years ago.
It used to be when the smoke clears you could see what's really
going on. But the ability to blow smoke exceeds the patience
of waiting. So now the industry demands a higher level of knowledge
for what is really nothing more than a blow job. Are you kidding me?
Like Elvis, common sense seems to have left the building :-).
www.beyondsql.blogspot.com|||"Steve Dassin" <rac4sqlnospam@.net> wrote in message
news:uf9xnfuDIHA.4360@.TK2MSFTNGP06.phx.gbl...
> Nah, I bet most people would be comfortable with the inference from
> the first response :)
> Sure, just look into this forum for proof that you need a higher
> level of knowledge and understanding today than 10 years ago.
> It used to be when the smoke clears you could see what's really
> going on. But the ability to blow smoke exceeds the patience
> of waiting. So now the industry demands a higher level of knowledge
> for what is really nothing more than a blow job. Are you kidding me?
> Like Elvis, common sense seems to have left the building :-).
Dunno, common sense seems to have settled in a little bit. Some of the
people I used see get hired....
Michael|||mrnagrajan@.yahoo.co.in's wild thoughts were released on Sun,
14 Oct 2007 10:58:47 -0700 bearing the following fruit:
>Dear Freinds,
>I am hoping a postive answer from this group. I have done my
>graduation currently and looking for a break in programming in C# or
>VB.NET with SQL Server. After graduation i joined a computer institute
>and did a one year course there. For first six months i was nearly
>taught nothing. But later some how i started to read things on my own.
>After one year i have started attending interviews. But the questions
>asked are so much out of topic sometimes. I can completed sample
>projects. What should i do because after one year i have come to know
>that questions in interviews are so different from actual projects.
>For instance i was asked about SOA , damn it i have no idea about that
>stuff. I am also reading interview questions and answers from
>http://www.questpond.com but i am still not able to cope up.
>Please help what approach should i take now. 1 year is a big time
>freinds.
Be prepared to take a low paid trainee position. Getting
some experience is more importany initially than the wage.
Jan Hyde
https://mvp.support.microsoft.com/profile/Jan.Hyde|||Some helpful tips
http://www.itjobfeed.com/secrets-of-getting-an-IT-job.asp
<mrnagrajan@.yahoo.co.in> wrote in message
news:1192384727.480633.43080@.y27g2000pre.googlegroups.com...
> Dear Freinds,
> I am hoping a postive answer from this group. I have done my
> graduation currently and looking for a break in programming in C# or
> VB.NET with SQL Server. After graduation i joined a computer institute
> and did a one year course there. For first six months i was nearly
> taught nothing. But later some how i started to read things on my own.
> After one year i have started attending interviews. But the questions
> asked are so much out of topic sometimes. I can completed sample
> projects. What should i do because after one year i have come to know
> that questions in interviews are so different from actual projects.
> For instance i was asked about SOA , damn it i have no idea about that
> stuff. I am also reading interview questions and answers from
> http://www.questpond.com but i am still not able to cope up.
> Please help what approach should i take now. 1 year is a big time
> freinds.
>|||s'pose no one thinks the cadence of the vernacular of the OP is pretty close to
the opening Paragraph of the link....
<mrnagrajan@.yahoo.co.in> wrote in message
news:1192384727.480633.43080@.y27g2000pre.googlegroups.com...
> Dear Freinds,
> I am hoping a postive answer from this group. I have done my
> graduation currently and looking for a break in programming in C# or
> VB.NET with SQL Server. After graduation i joined a computer institute
> and did a one year course there. For first six months i was nearly
> taught nothing. But later some how i started to read things on my own.
> After one year i have started attending interviews. But the questions
> asked are so much out of topic sometimes. I can completed sample
> projects. What should i do because after one year i have come to know
> that questions in interviews are so different from actual projects.
> For instance i was asked about SOA , damn it i have no idea about that
> stuff. I am also reading interview questions and answers from
> http://www.questpond.com but i am still not able to cope up.
> Please help what approach should i take now. 1 year is a big time
> freinds.
>|||"MikeB" <m.byerleyATVerizonDottieNettie> wrote in message
news:%23qyZo$xDIHA.4296@.TK2MSFTNGP04.phx.gbl...
> s'pose no one thinks the cadence of the vernacular of the OP is pretty
> close to the opening Paragraph of the link....
Dunno, I didn't click any links.
Michael

Help finding group totals for year end

My SQLServer 2k database has the following tables:
Transaction
Customer
Employee
Every Transaction is assigned a customerId
Every Customer is assigned an employee id
All Transactions have a total
What I am trying to do is calculate the top 5 customers by total for each
employee
I have the following which gives me the top 5 customers, but how do I get
the top 5 for each employee?
WB
Syntax:
SELECT t.CustomerId, sum(t.total)
FROM tblTransaction t
WHERE Year(t.TransactionDate) = 2005
GROUP BY t.CustomerId
ORDER BY sum(t.total) DESCSELECT t.employeeid, sum(t.total)
FROM tblTransaction t INNER JOIN employee e
on t.customerid = e.customerid
WHERE Year(t.TransactionDate) = 2005
GROUP BY t.employeeid
ORDER BY sum(t.total) DESC
"WB" wrote:

> My SQLServer 2k database has the following tables:
> Transaction
> Customer
> Employee
> Every Transaction is assigned a customerId
> Every Customer is assigned an employee id
> All Transactions have a total
> What I am trying to do is calculate the top 5 customers by total for each
> employee
> I have the following which gives me the top 5 customers, but how do I get
> the top 5 for each employee?
>
> WB
> Syntax:
> SELECT t.CustomerId, sum(t.total)
> FROM tblTransaction t
> WHERE Year(t.TransactionDate) = 2005
> GROUP BY t.CustomerId
> ORDER BY sum(t.total) DESC
>
>|||Is there any uniqueness about the TransAction table like an IDENTITY
Column..? I've assumed there is :-
select * from tblTransAction t1 WHERE PK_TranID IN
(SELECT TOP 5 t2.PK_TranID
FROM tblTransAction as t2
WHERE t2.CustomerID = t1.CustomerID
GROUP BY t2.CustomerID, t2.TransactionID, t2.Total
ORDER BY SUM(t2.Total) DESC)
HTH. Ryan
"WB" <none> wrote in message news:eiqpObVFGHA.376@.TK2MSFTNGP12.phx.gbl...
> My SQLServer 2k database has the following tables:
> Transaction
> Customer
> Employee
> Every Transaction is assigned a customerId
> Every Customer is assigned an employee id
> All Transactions have a total
> What I am trying to do is calculate the top 5 customers by total for each
> employee
> I have the following which gives me the top 5 customers, but how do I get
> the top 5 for each employee?
>
> WB
> Syntax:
> SELECT t.CustomerId, sum(t.total)
> FROM tblTransaction t
> WHERE Year(t.TransactionDate) = 2005
> GROUP BY t.CustomerId
> ORDER BY sum(t.total) DESC
>
>

Help expanding a query .. group By

Im using vb code to generate a SQL query to return a recordset. The follwing
query returns 2 records as follows.
Select a.BHYEAR_MOVEDATE,
Case b.BTYear_TransCode
WHEN '17' THEN 'DD'
WHEN '01' THEN 'DD'
WHEN '18' THEN 'DD'
Else 'AUD' END AS 'TYPE'
from dbo.BacsHdrYearly as a
LEFT JOIN dbo.BacsTrnYear as b
on a.BHYear_LedgerKey = b.BTYear_LedgerKey
Where (a.BHYEAR_LICENCE = '217000' AND a.BHYEAR_SERIALNUMBER = '128')
OR (a.BHYEAR_LICENCE = '217000' AND a.BHYEAR_SERIALNUMBER = '134')
OR (a.BHYEAR_LICENCE = '217000' AND a.BHYEAR_SERIALNUMBER = '135')
OR (a.BHYEAR_LICENCE = '217001' AND a.BHYEAR_SERIALNUMBER = '136')
GROUP BY a.BHYEAR_MOVEDATE , b.BTYear_TransCode
BHYEAR_MOVEDATE TYPE
--- --
2005-04-21 00:00:00 DD
2005-04-21 00:00:00 DD
I need it to only return one record as for each date and type ( may be
multiple dates and types ).
BHYEAR_MOVEDATE TYPE
--- --
2005-04-21 00:00:00 DD
any suggestions on how to rephrase this query ?What ABout DISTINCT ?

> Select DISTINCT a.BHYEAR_MOVEDATE,
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Peter Newman" <PeterNewman@.discussions.microsoft.com> schrieb im
Newsbeitrag news:5AEEE5BB-67B2-4DEC-A918-F6C32E79312C@.microsoft.com...
> Im using vb code to generate a SQL query to return a recordset. The
> follwing
> query returns 2 records as follows.
> Select a.BHYEAR_MOVEDATE,
> Case b.BTYear_TransCode
> WHEN '17' THEN 'DD'
> WHEN '01' THEN 'DD'
> WHEN '18' THEN 'DD'
> Else 'AUD' END AS 'TYPE'
> from dbo.BacsHdrYearly as a
> LEFT JOIN dbo.BacsTrnYear as b
> on a.BHYear_LedgerKey = b.BTYear_LedgerKey
> Where (a.BHYEAR_LICENCE = '217000' AND a.BHYEAR_SERIALNUMBER = '128')
> OR (a.BHYEAR_LICENCE = '217000' AND a.BHYEAR_SERIALNUMBER = '134')
> OR (a.BHYEAR_LICENCE = '217000' AND a.BHYEAR_SERIALNUMBER = '135')
> OR (a.BHYEAR_LICENCE = '217001' AND a.BHYEAR_SERIALNUMBER = '136')
> GROUP BY a.BHYEAR_MOVEDATE , b.BTYear_TransCode
>
> BHYEAR_MOVEDATE TYPE
> --- --
> 2005-04-21 00:00:00 DD
> 2005-04-21 00:00:00 DD
>
> I need it to only return one record as for each date and type ( may be
> multiple dates and types ).
> BHYEAR_MOVEDATE TYPE
> --- --
> 2005-04-21 00:00:00 DD
> any suggestions on how to rephrase this query ?|||or
GROUP BY clause
"Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:OoaGSMNRFHA.204@.TK2MSFTNGP15.phx.gbl...
> What ABout DISTINCT ?
>
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "Peter Newman" <PeterNewman@.discussions.microsoft.com> schrieb im
> Newsbeitrag news:5AEEE5BB-67B2-4DEC-A918-F6C32E79312C@.microsoft.com...
>|||Of couse ;-)
"Uri Dimant" <urid@.iscar.co.il> schrieb im Newsbeitrag
news:e$TxrUNRFHA.3076@.TK2MSFTNGP14.phx.gbl...
> or
> GROUP BY clause
>
> "Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote
> in
> message news:OoaGSMNRFHA.204@.TK2MSFTNGP15.phx.gbl...
>|||Peter,
Your statement is correct, except that in the GROUP BY clause you have to us
e:
...
GROUP BY
a.BHYEAR_MOVEDATE,
Case b.BTYear_TransCode
WHEN '17' THEN 'DD'
WHEN '01' THEN 'DD'
WHEN '18' THEN 'DD'
Else 'AUD' END;
AMB
"Peter Newman" wrote:

> Im using vb code to generate a SQL query to return a recordset. The follwi
ng
> query returns 2 records as follows.
> Select a.BHYEAR_MOVEDATE,
> Case b.BTYear_TransCode
> WHEN '17' THEN 'DD'
> WHEN '01' THEN 'DD'
> WHEN '18' THEN 'DD'
> Else 'AUD' END AS 'TYPE'
> from dbo.BacsHdrYearly as a
> LEFT JOIN dbo.BacsTrnYear as b
> on a.BHYear_LedgerKey = b.BTYear_LedgerKey
> Where (a.BHYEAR_LICENCE = '217000' AND a.BHYEAR_SERIALNUMBER = '128')
> OR (a.BHYEAR_LICENCE = '217000' AND a.BHYEAR_SERIALNUMBER = '134')
> OR (a.BHYEAR_LICENCE = '217000' AND a.BHYEAR_SERIALNUMBER = '135')
> OR (a.BHYEAR_LICENCE = '217001' AND a.BHYEAR_SERIALNUMBER = '136')
> GROUP BY a.BHYEAR_MOVEDATE , b.BTYear_TransCode
>
> BHYEAR_MOVEDATE TYPE
> --- --
> 2005-04-21 00:00:00 DD
> 2005-04-21 00:00:00 DD
>
> I need it to only return one record as for each date and type ( may be
> multiple dates and types ).
> BHYEAR_MOVEDATE TYPE
> --- --
> 2005-04-21 00:00:00 DD
> any suggestions on how to rephrase this query ?sql

HELP - Page break after 2 groups, 2 groups per page

I have a requirement to condense my report length. Each group is about 40%
of the page length, so 2 per page would fit nicely...
...but I can't figure out a way. For performance reasons, I have the data
filtered in the table object.
I have tried several things:
1. (Runningvalue(Fields!StoreID.Value,CountDistinct,nothing)-1) \ 2 counts
my groups correctly, but I am not able to use it RunningValue in a SRS
grouping.
2. Created a counter with code found in this newsgroup. This also counts my
groups correctly, and I can use it in a Group, but it doesnt seem to help me
no matter where I put the IncrelentCounter or GetCounter statements.
Public GroupRowCounter As Integer = 0
Function IncrementCounter() As Integer
GroupRowCounter += 1
Return GroupRowCounter
End Function
Function GetCounter() As Integer
Return GroupRowCounter
End Function
3. I've tried putting the Increment in group2 and the Get in group1, and
that didnt help. I tried putting the increment in group1 and the get in
group2 and nothing changes. I admit I may be putting the Increment and Get in
the wrong places, but I can't seem to see it.
Can anyone help me?Ok, I found a way, and thought I'd shart
"Rob 'Spike' Stevens" wrote:
> I have a requirement to condense my report length. Each group is about 40%
> of the page length, so 2 per page would fit nicely...
> ...but I can't figure out a way. For performance reasons, I have the data
> filtered in the table object.
> I have tried several things:
> 1. (Runningvalue(Fields!StoreID.Value,CountDistinct,nothing)-1) \ 2 counts
> my groups correctly, but I am not able to use it RunningValue in a SRS
> grouping.
> 2. Created a counter with code found in this newsgroup. This also counts my
> groups correctly, and I can use it in a Group, but it doesnt seem to help me
> no matter where I put the IncrelentCounter or GetCounter statements.
> Public GroupRowCounter As Integer = 0
> Function IncrementCounter() As Integer
> GroupRowCounter += 1
> Return GroupRowCounter
> End Function
> Function GetCounter() As Integer
> Return GroupRowCounter
> End Function
> 3. I've tried putting the Increment in group2 and the Get in group1, and
> that didnt help. I tried putting the increment in group1 and the get in
> group2 and nothing changes. I admit I may be putting the Increment and Get in
> the wrong places, but I can't seem to see it.
> Can anyone help me?
>|||Ok, I figured it out, and thought I would share it with you.
1. Placed code below in the Code section of your report properties:
Public GroupRowCounter As Integer = 0
Public GroupName as string =""'
Function IncrementCounter(strGroup as string) As string
if GroupName <> strGroup then
GroupRowCounter += 1
GroupName = strGroup
end if
Return (GroupRowCounter -1)\2
End Function
2. In the dataset for you Report, add a calculated field, I called mine
Grouper.
3. Code.IncrementCounter(Fields.TheOneYoureTryingToGroupNperPage.value)
4. On your report, add a group immideately above the group level you want
per page using Grouper. Set page break at end.
5. Remove page breaks from any internal grouping that no loner need them.
"Rob 'Spike' Stevens" wrote:
> I have a requirement to condense my report length. Each group is about 40%
> of the page length, so 2 per page would fit nicely...
> ...but I can't figure out a way. For performance reasons, I have the data
> filtered in the table object.
> I have tried several things:
> 1. (Runningvalue(Fields!StoreID.Value,CountDistinct,nothing)-1) \ 2 counts
> my groups correctly, but I am not able to use it RunningValue in a SRS
> grouping.
> 2. Created a counter with code found in this newsgroup. This also counts my
> groups correctly, and I can use it in a Group, but it doesnt seem to help me
> no matter where I put the IncrelentCounter or GetCounter statements.
> Public GroupRowCounter As Integer = 0
> Function IncrementCounter() As Integer
> GroupRowCounter += 1
> Return GroupRowCounter
> End Function
> Function GetCounter() As Integer
> Return GroupRowCounter
> End Function
> 3. I've tried putting the Increment in group2 and the Get in group1, and
> that didnt help. I tried putting the increment in group1 and the get in
> group2 and nothing changes. I admit I may be putting the Increment and Get in
> the wrong places, but I can't seem to see it.
> Can anyone help me?
>

Help - Formulas with Functions across Databases

I'm trying to build a table that uses a formula with a function in another database on the same server group. Enterprise Manager validates the formula, then when I save the table, an ODBC error pops up stating that the function is an invalid object name. I'm calling the function in the formula as follows: ([OtherDatabase].[dbo].[FunctionName](parameters)). Any ideas?

-- JakeAre you running at least sp2 ?

-PatP|||Yes, I'm running SP2.

-- Jake|||I know that certain situations do force you to use cross-database DML. But if you're creating a calculated field (is that what you're trying to do?) with a function in another database this means that both databases, AND THEIR NAMES (!!!) must go together, right? Why don't you move the function to the same database as the table? And if the function does reference objects in another database, then it would be transparent for the table. If you want to apply "reusability" and you happen to have a table(-s) in another database that has a calculated field that utilizes the same function, then you can just reference that function within the function wrapper.|||The Database I'm working on is a template that will be replicated for numerous individual projects, so I'm trying to reduce the number of locations the generalized Function code will be stored in. Otherwise, I was curious why I can put ([OtherDatabase].[dbo].[FunctionName](parameters)) in a View (for example) and get the desired result, yet have it not recognize the object when said code is placed in the Formula field (even after it supposedly validates the code). If I'm missing something syntax-wise, please let me know.

HELP - Designing a Subscripion System for a Group of Reports

We're developing an ASP.NET 2.0 (C#) application that will act as a
front-end to SQL Server 2005 Reporting Services. We have an interesting
requirement that [we believe] can't be solved using RS out-of-the-box. So,
I'm writing today to get some ideas on possible solutions.
The requirement is that the app. needs to support, what we're calling, a
report group. A report group is simply a group of similar reports that can
be executed as a single unit (instead of having to execute each report
individually). This was not too bad to solve. We simply created our own
database tables that track which report group contains which reports.
The tricky part is that we now have to figure out a way to create a
subscription that executes the report group (thereby executing each
individual report in the report group automatically). Creating a
subscription for a single report is fairly straightforward, but it appears
this concept of a report group is not a part of RS.
Does anyone out there have any good ideas/suggestions on how we can
implement such functionality?
The best thought we have so far is to write another application that manages
the execution of each report in a report group. So, the SQL Server 2005 job
would call this additional little application, this additional app. would
lookup which reports are in the report group, and then it would loop through
all the reports and execute them one-by-one. But, this has some issues-like
how do we handle the output type (PDF, Excel, etc.) and how do we handle the
destination (e-mail, printer, etc.) of each report. Plus, it seems like we
would be somewhat reinventing the wheel as far as subscriptions go.
Thanks.Why aren't you using one master report with all the other reports as
sub-reports?
Tom Bizannes
oiduts wrote:
> We're developing an ASP.NET 2.0 (C#) application that will act as a
> front-end to SQL Server 2005 Reporting Services. We have an interesting
> requirement that [we believe] can't be solved using RS out-of-the-box. So,
> I'm writing today to get some ideas on possible solutions.
> The requirement is that the app. needs to support, what we're calling, a
> report group. A report group is simply a group of similar reports that can
> be executed as a single unit (instead of having to execute each report
> individually). This was not too bad to solve. We simply created our own
> database tables that track which report group contains which reports.
> The tricky part is that we now have to figure out a way to create a
> subscription that executes the report group (thereby executing each
> individual report in the report group automatically). Creating a
> subscription for a single report is fairly straightforward, but it appears
> this concept of a report group is not a part of RS.
> Does anyone out there have any good ideas/suggestions on how we can
> implement such functionality?
> The best thought we have so far is to write another application that manages
> the execution of each report in a report group. So, the SQL Server 2005 job
> would call this additional little application, this additional app. would
> lookup which reports are in the report group, and then it would loop through
> all the reports and execute them one-by-one. But, this has some issues-like
> how do we handle the output type (PDF, Excel, etc.) and how do we handle the
> destination (e-mail, printer, etc.) of each report. Plus, it seems like we
> would be somewhat reinventing the wheel as far as subscriptions go.
> Thanks.|||You could try setting up a shared schedule. It would still require
individual subscriptions for each report but they would all start
firing at the same scheduled time.

Help - "Could not allocate space for object as the secondary group is full" error

Hello Peers,
We have a database in SqlServer 2K with a following settings:
Primary Group Size: 1024MB
Secondary Group Size: 1023 MB
Transaction Log size: 236 MB
File Growth: 10%
Recover Model: Simple
Auto Shrink: OFF
Recovery Model: Simple
We have a table "TestTable' that has 400,000 records. All the indexes
for the table is on the Secondary group.
The problem is, when we alter a size of the column and save the
changes in EnterPriseManager, we get the error "Could not allocate
space for object 'TestTable' in database 'TestDb' because the
'Secondary' filegroup is full." We get the same error when we use
"Alter Column" command in Query Analyzer as well(We have run "Dbcc
ShrinkFile" before running the alter table command).
Could anyone throw some light on altering the size of columns on a
table with 400000+records without any problems like the one above?
TIA for any help.
Regards
Pradeep.L
On May 11, 11:56 am, pradee...@.hotmail.com wrote:
> Hello Peers,
> We have a database in SqlServer 2K with a following settings:
> Primary Group Size: 1024MB
> Secondary Group Size: 1023 MB
> Transaction Log size: 236 MB
> File Growth: 10%
> Recover Model: Simple
> Auto Shrink: OFF
> Recovery Model: Simple
> We have a table "TestTable' that has 400,000 records. All the indexes
> for the table is on the Secondary group.
> The problem is, when we alter a size of the column and save the
> changes in EnterPriseManager, we get the error "Could not allocate
> space for object 'TestTable' in database 'TestDb' because the
> 'Secondary' filegroup is full." We get the same error when we use
> "Alter Column" command in Query Analyzer as well(We have run "Dbcc
> ShrinkFile" before running the alter table command).
> Could anyone throw some light on altering the size of columns on a
> table with 400000+records without any problems like the one above?
> TIA for any help.
> Regards
> Pradeep.L
Pradeep.L,
If you right click on your database in EM and select "Properties" and
"Data File tab" what do you see? Is the "restrict file growth" radio
button checked? Are you trying to make the db bigger than is allowed?
Or are you running out of disc space on the drive where this db/file
group is stored?
Kristina
|||Hello Kristina,
[vbcol=seagreen]
No. It is set to "Unrestricted File Growth" for Datafile and
Transaction log.
[vbcol=seagreen]
I'm not sure about this. The maximum db size that is permitted in our
machine is 2GB and it complains that the cumulative size should not
exceed 2048 MB due to the license policy.
[vbcol=seagreen]
group is stored?
There is 15GB free space in the partition in which sql server is
installed -
BTW, The purpose of trying out this issue is we need to increase the
size of quite a few columns in our production server.
Most of the columns are part of composite primary key/Index. We would
like to ensure that we don't land in sticky waters
when we go out with the change in our production server -
|||<pradeepln@.hotmail.com> wrote in message
news:1178942162.311166.101130@.e65g2000hsc.googlegr oups.com...
> Hello Kristina,
> No. It is set to "Unrestricted File Growth" for Datafile and
> Transaction log.
> I'm not sure about this. The maximum db size that is permitted in our
> machine is 2GB and it complains that the cumulative size should not
> exceed 2048 MB due to the license policy.
Ummm, 2048 MB IS 2GB.
Sounds like you've reached your max. Or I'm misunderstanding you.

> group is stored?
> There is 15GB free space in the partition in which sql server is
> installed -
> BTW, The purpose of trying out this issue is we need to increase the
> size of quite a few columns in our production server.
> Most of the columns are part of composite primary key/Index. We would
> like to ensure that we don't land in sticky waters
> when we go out with the change in our production server -
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

HELP

SQL will not allow me to create a secondary file group that replaces the
primary. I have no space to run queries.
--
Regards,
Jamie
"thejamie" wrote:

> When we setup SQL 2005, it was setup to house the log files on a larger
> drive. It was not setup to house the tempdb files when they grow to a la
rge
> size. We are running out of disk space on the C:\ drive. Is it possible
to
> move this without reinstalling SQL Server 2005? For that matter, if I mus
t
> reinstall, can the tempdb be placed in an alternate location (other than t
he
> C drive)?
> --
> Regards,
> JamieHey, I am also facing the similar problem, how can I resolve this, please I
need your urgent response.
I am working on this now.. I got this problem as a result of migrating the d
ata from one data base to another back up database.
From http://www.developmentnow.com/g/118...467001/HELP.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com

help

hi

i have table with folowing columns (subid,itemid)

i want to write select stmt to get subid where itemid =all group of value('1','2')

like this

Select subid from subscriptionItem where itemId in all('1','2')

but this stmt not work

help me

Somthing like this ?

Select SubID From SubscriptionItem Where ItemID in ('1','2')|||

Hi,

If you mean you want those SubID that have both ItemID 1 and 2, then the above will not work.

what you should is..

Select SubID From subscriptionItem Where ItemID in (1,2) group by SubID Having count(0) =2

Assuming that the combination SubID and ItemID is primary (unique).

If they are not unique, which I doubt, then try:

Select SubID FROM (Select distinct SubID, ItemID from SubscriptionItem where ItemID in (1,2)) si Group by SubID having count(0) = 2

Hope this helps