timothyawiseman (12/6/2007)

---

Matt Miller (12/6/2007)

---

Total disregard for the physical layer implementing this is precisely why something like this is a bad example of set-based (in my mind not even deserving...

cs_troyk (12/6/2007)

---

Matt Miller (12/6/2007)

---

Well - set-based processing entails a bit more than either description. Jeff's taking issue with the fact that the external query has to be evaluated one...

Assuming you're passing the parameters as strings, you could try...

create proc myproc(@startdatestr as varchar(20),@enddatestr as varchar(20))

as

begin

declare @startdate datetime

declare @enddate datetime

select

@startdate=cast(@startdatestr+' 05:30pm' as datetime),

...

Well - set-based processing entails a bit more than either description. Jeff's taking issue with the fact that the external query has to be evaluated one single row at...

Have you tried:

where

orderDate between '12/5/2007 5:30pm' and '12/6/2007 5:30pm'

you can also use a CAST to make sure it goes into a datetime, but the syntax above will do the CAST...

Also - Backups are just about the heaviest load you can put down on storage volumes. Since RAID-5 is penalized for writes - I wouldn't use that on the...

SQL33 (12/6/2007)

---

As was initially requested (....I want to query the data shown below in the first dataset to return each entire row containing the nth lowest sequence number for each...

screw the physical order - I'm looking...

That's the point isn't it?

3...

Jim Russell (12/6/2007)

---

Interesting. In fact, in Access 2003 this query (where [isDate] is a check box field):

SELECT [Elems - CPMIS].Name, [Elems - CPMIS].Typ

FROM [Elems - CPMIS]

WHERE IsDate;

works fine.

But...

Actually - it's not incorrect. If you SORT by custlink and sequence, you end up with

5432 3

5432 21

5432 22...

Grant Fritchey (12/6/2007)

---

It's never a very popular thing to say, but don't share the SQL Server server with any other process. It's a pretty safe rule of thumb (yeah, there...

For a little levity as to "santa" requests, here's a kind of funny take on one of those "Microsoft'isms" gone bad..... I still haven't fully recovered from the laugh...

I don't know if this will help at all, but here goes:

If you track in the parent table which "table" that particular key exists in, you can get most of...

There are settings in the rsreportserver.config file that might help with that...BOL mentions looking for this setting:

MaxActiveReqForOneUser

Specifies the maximum number of simultaneous and in-progress connections that a single...