The article referenced in the editorial is just too good.

I was simply smiling through the article wondering how can an article be so accurate.

saurabh_goel_86 (6/19/2013)

---

HI,

Thanks for the assistance..

I need to import this and send it over to client.

A .csv format or excel format which ever would be suitable..

I was wondering which one...

There is a table which has entries coming to it every day. I need to check which all entries came on Monday.

Create a table with a column to store date...

Log shipping should be possible if the primary instance is of a lower version(say, SQL Server 2005) and the secondary instance is of a higher version(say, SQL Server 2008)

It will...

Sai Viswanath (6/19/2013)

---

Hi All,

One more doubt on partitioning.

- Do we need to have a primary key in the table which needs to be partitioned?

- Can I use a composite...

This should give you a start

SELECTMONTH,

SUM( CASE WHEN RN = 1 THEN MEASURE ELSE 0 END ) AS MEASURE1,

SUM( CASE WHEN RN = 2 THEN MEASURE ELSE 0 END )...

ajayvinay1979 (6/18/2013)

---

Hi ,

You can do as

declare @table as table

(id int)

INSERT INTO @table

SELECT 100 UNION ALL

SELECT 101 UNION ALL

SELECT 102 UNION ALL

SELECT 103 UNION ALL

SELECT...

immaduddinahmed (6/18/2013)

---

actullay i am fresh in this field so its ok(LATE HALFDAY). i have to learn more from the internet and the forum like sql server central

yes your query is...

Is your solution not the same as the one posted above yours?

immaduddinahmed (6/18/2013)

---

i do like this

when convert(varchar(10),t.[Timein],108) >= convert(varchar(10),t4.ltime,108) and

spendtime is not null then 'LATE '

else '' end

+ case when (t4.minute- Time_Minutes) >= 120 then + 'HALF...

Great. I am glad you got it yourself.

Anyways here is what I came up with

SELECTCASE

WHEN CONVERT(VARCHAR(10), t.[Timein], 108) >= CONVERT(VARCHAR(10), t4.ltime, 108) AND spendtime IS NOT...

immaduddinahmed (6/18/2013)

---

yes this is what i want Thanks

but it gives me like this

Remarks

LateHALFDAY

i want this

late / halfday

when only halfday remarks show this Halfday

and when late and halfday remark...

Its not possible to explain this in a forum post

Please check for articles on Google or Books Inline and I am sure you will...

ChrisM@Work (6/18/2013)

---

sagesmith (6/18/2013)

---

Please post the times each approach takes, this is the only basis for a conclusion. As others have already mentioned, in many scenarios the cursor far outperforms...

You will have to create 2 separate triggers on the 2 tables

Inside the trigger you can write the code to update the new table