davidandrews13 (12/21/2012)

---

talking of being SARGable, i was reading this article:

http://en.wikipedia.org/wiki/Sargable

and didn't quite understand this line

The typical thing that will make a sql query non-sargable is to include a function in...

Without way more information than that (see this article for what is missing[/url]), I'd be extremely surprised if anyone is able to give you an answer that doesn't just mean...

I guess I'd do it like this: -

SELECT year, week, value, ISNULL(AvgVal,0) AS AvgVal

FROM (SELECT year, week, value, ROW_NUMBER() OVER(ORDER BY year,week)

FROM year_week_value) a(year,week,value,pos)

OUTER...

Another data smudge question, seem to come in waves 🙂

SELECT currency_to, currency_from, tradedate, ad.traderate

FROM test a

CROSS APPLY (SELECT TOP 1 traderate

...

Couple of issues.

1) You've replied to a thread that is over a year old.

2) You've posted a recursive CTE counting method. See this article --> http://www.sqlservercentral.com/articles/T-SQL/74118/%5B/url%5D, for...

The error is saying that there is no EMAIL column in the table User_Information.

Try this: -

SELECT name

FROM sys.columns

WHERE [object_id] = OBJECT_ID('dbo.User_Information');

That should list all of your column names for that...

If you execute this, it's at your own risk. Do it in a test environment first and make sure you understand what is going on.

DECLARE @Table_Name VARCHAR(20) = 'table 1',...

Don't suppose you still have the test scripts?...

SELECT a.Shift+b.Shift

FROM [dbo].[Mas_Shift] a

CROSS JOIN [dbo].[Mas_Shift] b

WHERE a.ShiftId < b.ShiftId;

I must admit to only having had a quick glance at this, but couldn't you do something like this instead?

SELECT EmployeeId, MIN(LoginTime) AS LoginTime, MAX(LogOutTime) AS LogOutTime

FROM (SELECT DENSE_RANK() OVER(PARTITION...

10e5x (12/12/2012)

---

Hi Cadavre,

Thank you v much for ur help. Btw may i tried and your method returned my all 1 as numberofdays.

Oh yes u are right, i should have uploaded...

Lots, but...

Assuming I've understood what you want, then something like this: -

SELECT StaffId,

MIN(EntryDate) AS firstDateEntrySequence, MAX(EntryDate) AS lastDateEntrySequence,

DATEDIFF(dd,MIN(EntryDate),MAX(EntryDate))+1 AS NumberOfDaysInSequence

FROM (SELECT StaffId, EntryDate,

DATEADD(dd, - ROW_NUMBER()...

murthyvs (12/11/2012)

---

Thanks Cadavre. This is cool stuff.

Can your code take two row terminators? pipe (|) and line break ()?

Example data:

field1;field2|

30;38469|

31;38469|

32;38469|

33;38469|

34;38469|

I didn't notice the line break in the original data. Very...

olivia.forde (12/11/2012)

---

I am getting an error on near join

Msg 156, Level 15, State 1, Line 6

Incorrect syntax near the keyword 'join'.

Msg 102, Level 15, State 1, Line 14

Incorrect syntax near...