patel i see what you are asking, but i don't see the data reflecting something that allows it to beswitched like that;

about all i can suggest is a UNION and...

it's a little tough with denormalized data;

ideally you'll want to change the schema if you can to store dates in date columns, and notes in a seperate column; but we...

where ISDATE(A) = 1

AND CONVERT(datetime,A) > DATEADD(dd,-7,Getdate()) --7 days? 8 days? what's minus one week for you?

--AND CONVERT(datetime,A) > DATEADD(ww,-1,Getdate()) --1 week?

you might want to buy a copy of developer so you can restore and test teh client backup, even if they are using enterprise only stuff like compression;

well it's a table of data now, so you can do your normal queries with group by and stuff like that.

here's a crappy group by example i just tested: like...

it's fairly easy.

first, doa SELECT * FROM sys.traces; you'll probably see traceid = 1(the default trace) plus any other traces you have created (2,3,4 etc)

select the trace id of...

i think a simple test with an EXISTS and correlated subquery will get you want you want:

With YOURTABLE (TICKET,STATUS)

AS

(

SELECT 9543,1 UNION ALL

SELECT 9543,5 UNION ALL

SELECT 9543,5 UNION...

i think it might be easier to jsut change the default paths for the files and backups, wouldn't it?

I did basically what you are saying to another server recently;

added a...

ok here's one solution:

ALTER FUNCTION dbo.fn_parsename

(

@pString VARCHAR(7999),

...

ron there's a built in extended procedure that can tell you what Ad groups an AD login belongs to.

the problem is, you do NOT want to grant everyone access to...

let us know if we can help with the additional issues you are encountering; glad i could get you pointed in a helpful direction.

additinally, since you've deployed it on one server already, you can actually script them out as a binary blob and install them via a script...the script may load slow as...

sounds like an end user comment...it's not an actual error message.

I would guess that someone could not connect or was blocked, and stated that the server must be down, which...

i tried to duplicate this, and couldn't drop any unqiue constraints because of the foreign keys.

is it possible that the database was originally a SQL 2000 database?

in that case, becasue...

Jeff Moden (10/11/2012)

---

I believe the following will do as you ask. I call it a "data smear" (because it "smears" the largest value "down" through the returned rows) for...