Try this:

DECLARE @Tab TABLE

( emp_id INT

,att_day INT

,lve_day INT

)

;

INSERT INTO @Tab

...

sbj1411 (4/5/2012)

---

Sorry, if my post looks weired. I was looking to get the CSV seperated values or seperated by '\' for the 'Day of the Week' column...based on the...

Welcome to sqlservercentral.com!

Please read through the following article on how to provide information to get the question answered.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Your request will involve usage of XML and some GROUP BY clauses. Please...

This?

SELECT C.CustomerName, Qty = SUM( S.Quantity ) ,Prc = SUM( P.Price)

FROM Customers AS C

INNER JOIN Sales AS S

ON C.CustomerName = S.CustomerName

INNER JOIN Products As P

ON S.ProductName = P.ProductName

GROUP BY C.CustomerName

Can you populate the tables with some data? And to go with it, your expected result based off of that sample data!

Jeff Moden (4/4/2012)

---

ColdCoffee (4/4/2012)

---

True, Jeff. Thats why in my code, i used -3 for milliseconds. OP posted this in 2008 forums, so i think its better to ask him to...

Jeff Moden (4/4/2012)

---

Boy, are you...

Aw no!!! Dont concatenate values into a single column. Normalize and seperate them out as columns which will save u time and money!

Will all the rows follow the same pattern?

Country:<Countryname>, City:<cityname>

There wont be any extra data in that Location column, would it?

My solution did not use CTEs, the CTE is built to hold your sample data! 😀

Or this?

; WITH CTE(Strings) AS

(

SELECT 'AIT_FIT_projecto and moonbeat'

UNION ALL SELECT 'OEMR_FIT_projectofile where handled'

UNION ALL SELECT 'LO_FIT_pritibabe every way'

)

SELECT Strings,

Stuffed = STUFF(Strings,1,...

Jeff, it was posted by Cadavre (If cadavre's original name is Craig, i apologize for the nit-pick) 🙂

REPLACE function

Extending the code:

DECLARE @InputDate DATETIME

-- Possible values 'DY' / 'WK' / 'MT' / 'YR'

...

How about this?

DECLARE @InputDate DATETIME

SELECT @InputDate = '2012-04-08'

SELECT @InputDate = DATEADD(DD,DATEDIFF(DD,0, @InputDate),0)

;WITH OffsetCalendar (DayNam , StartIndex, EndIndex ) AS

(

...