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...

here's a CTE of your data that is inte ready-to-use format my friend Cadavre suggested:

WITH myCTE ([Branch],[Year],[Count of All who failed],[Count of all right handed who failed])

AS

...

how much memory does your developer machine have?

I find VS2010 is very resource intensive; a single isntance devenv.exe is currently 1.4 gig or ram for a big project, and two...

well, ideally, your scalar UDF can be converted to an inline table funciton instead.

Create FUNCTION fnAdjustDateTime_itv (@date datetime, @timezone int)

RETURNS table

AS

RETURN

SELECT DateAdd(hh,CASE

...

bulk insert expects raw data, and not formatted INSERT...statements.

if your file looked like this isntead:

1,Apr 27 2012 12:00AM

2,Apr 27 2012 12:00AM

bulk insert would insert into a two column table witht...