Viewing 15 posts - 2,491 through 2,505 (of 18,926 total)
Why not do a delete first?
September 20, 2011 at 3:31 pm
That's not where I'd start but I guess you're way down on the rabbit whole?
Any proof of memory pressure or io read issues? If not I probably wouldn't waste...
September 20, 2011 at 3:30 pm
Sean Lange (9/20/2011)
And don't add an accidental space into Lowells naming convention. (WHORE SULTS). :w00t:Which when I first read it i transposed the U and L in the second word....sheesh!!!
Same...
September 20, 2011 at 3:25 pm
#1 Select rank
#2 Use #1 as cte or derived table (not sub query)
#3 Apply filter THEN only on studentid
#4 Move on to next task
September 20, 2011 at 3:24 pm
Ninja FINALLY overtakes Lowell!
:-D:w00t::cool:
September 20, 2011 at 3:22 pm
Then insert both columns, or join on the name. Assuming they actually match.
September 20, 2011 at 3:18 pm
GilaMonster (9/20/2011)
uncle_boris (9/19/2011)
September 20, 2011 at 3:17 pm
Well you need a group on year for the columns
and a group for recipient on rows.
Then the data is sum(whatever).
This assume that you didn't pivot the data sql server side.
If...
September 20, 2011 at 3:16 pm
sp_send_dbmail
can send an e-mail (scheduled via job).
You can send file or attach the results of a query as file.
September 20, 2011 at 3:14 pm
drew.allen (9/20/2011)
Ninja's_RGR'us (9/20/2011)
Nice use of a short-circuit!Then you just have to find a way to remove the rtrim in the where clause and this then has a chance to fly!
Isn't...
September 20, 2011 at 3:13 pm
Error #?
What were you doing when it happened?
Anything usefull in the logs?
September 20, 2011 at 3:09 pm
Nice use of a short-circuit!
Then you just have to find a way to remove the rtrim in the where clause and this then has a chance to fly!
September 20, 2011 at 3:05 pm
You need to join on something.
Right now you are doing a cross join and basically putting a random guid in the update.
What's commun in both tables you can join on?
September 20, 2011 at 3:04 pm
tfifield (9/20/2011)
September 20, 2011 at 3:01 pm
daveriya (9/20/2011)
this function is the only my problem,nothing else
No your problem is that you ask for help and are not willing to give us what we need to give you...
September 20, 2011 at 2:41 pm
Viewing 15 posts - 2,491 through 2,505 (of 18,926 total)