Viewing 15 posts - 1,741 through 1,755 (of 2,452 total)
Digs (1/6/2013)
First the code...PS: I dont have a Calender table with YYYYMM, unles you know where I can get one ?
Any ideas
plenty of calendar scripts available if you search...heres a...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 6, 2013 at 1:29 pm
select CONVERT(CHAR(6), getdate(), 112)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 6, 2013 at 11:46 am
shohelr2003 (1/6/2013)
I have a table Student(Section, Roll, Subjects, Marks). Now I want to display the results like the following. That means the result will show section and Roll wise Subjects,...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 6, 2013 at 4:40 am
untested...
;with cte as
(
SELECT House_acc
FROM yourtable
GROUP BY House_acc
HAVING (COUNT(DISTINCT repcode) > 1)
)
SELECT A.House_acc ,
A.AccountId ,
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 5, 2013 at 3:50 pm
nitin_456 (1/5/2013)
House_AccAccountidrepcode
123 1 J978A
123 ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 5, 2013 at 3:28 pm
msanchez7 (1/5/2013)
Yeah that's right, I've been trying to figure it out for the past month and I got stressed! That's why I need help 🙂
ok...seems you are new to all...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 5, 2013 at 10:28 am
msanchez7 (1/5/2013)
I just wrote the data As an example. Do you mean staff no: etc...?
appreciate this is in "Design Ideas and Qs"...but have you created any SQL tables yet?
...or we...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 5, 2013 at 10:15 am
msanchez7 (1/5/2013)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 5, 2013 at 10:02 am
steve.pantazis (1/4/2013)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 5, 2013 at 9:45 am
personally I would not try to insert records into your table.
see if this gets anywhere close to what you require....could well be improved I expect.
declare @TP as INT
set @TP =...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 5, 2013 at 5:50 am
opc.three (1/2/2013)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 2, 2013 at 2:30 pm
fabri8989 (12/28/2012)
Hi guys 🙂 ..... My boss has told me to learn sql server 2008, but i haven't knowledge and no experience in this field
A question for you...why has...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
December 28, 2012 at 1:19 pm
cms9651 (12/24/2012)
one of five people have to work a full week, while others are off.
everyone has to work the same number of weeks for year.
know what I...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
December 24, 2012 at 8:24 am
I connect to a progress database (10.1c version)
We installed the odbc driver and connect to Progress via SSIS to import data into SQL
this is how I use it in...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 31, 2012 at 12:59 pm
one method to get you started......others may chime in with alternatives.
please note how I created the set up scripts....makes it so much easier for everyone else to help you....I hope...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 2, 2012 at 2:45 pm
Viewing 15 posts - 1,741 through 1,755 (of 2,452 total)