plenty of calendar scripts available if you search...heres a...

select CONVERT(CHAR(6), getdate(), 112)

shohelr2003 (1/6/2013)

---

Dear,

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,...

untested...

;with cte as

(

SELECT House_acc

FROM yourtable

GROUP BY House_acc

HAVING (COUNT(DISTINCT repcode) > 1)

)

SELECT A.House_acc ,

A.AccountId ,

...

nitin_456 (1/5/2013)

---

Hi ,

House_AccAccountidrepcode

123 1 J978A

123 ...

ok...seems you are new to all...

appreciate this is in "Design Ideas and Qs"...but have you created any SQL tables yet?

...or we...

msanchez7 (1/5/2013)

---

I am so confused I have to normalise these form 1 and 2 together, 2 and 4 together and the rest separately into 3nf. Can somebody help. On the...

steve.pantazis (1/4/2013)

---

I need to find a way to do an INSERT into the same table (named ResultsHistory) by summing up the child row totals without using a CURSOR in MSSQL....

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 =...

opc.three (1/2/2013)

---

Your request could be taken multiple ways, I think. If you have a moment to spare please post a table definition (CREATE TABLE statement), some sample data (INSERT statements),...

A question for you...why has...

cms9651 (12/24/2012)

---

thank you for reply.

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...

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...

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...