Viewing 13 posts - 16 through 28 (of 28 total)
Thanks, as usual you guys are awesome.
June 23, 2008 at 9:49 am
I was actually able to figure it out on my own, but thanks for the help. I did it differently but will keep the above code in mind for the...
June 18, 2008 at 1:45 pm
nevermind, just read up on it again. Looks like it will do.
May 27, 2008 at 10:08 am
as I understand it nvarchar is for unicode, so each character will take up 2 bytes. so rather than having about 8000 characters for a varchar, I've got about 4000...
May 27, 2008 at 10:03 am
Okay, this is about as far as I can go. I am not sure what happens next, or what the impact would be on the email side if I edited...
May 27, 2008 at 9:36 am
Okay, I've looked into sp_send_dbmail further and can see I send the vaule of @body into sysmail_mailitems which is also [body] [nvarchar](max) NULL, so I know I would have to...
May 27, 2008 at 9:34 am
GilaMonster (5/21/2008)
From the sound of things, the inner cursor may be removable. Can you post just that bit please?
Sure, but I think the poster above is correct. This is an...
May 21, 2008 at 1:45 pm
Well, my proc is currently 3422 lines long (no joke) so I don't think I can just post a chunk of it and have it make sense.
Essentially I am sending...
May 21, 2008 at 1:19 pm
Many thanks for your reply. . .
So then in addition to my Clustered of (COUNTRY, ACCOUNT), then I would need a non-clustered of (ACCOUNT, COUNTRY). . .
May 21, 2008 at 10:15 am
What did you mean by this?
--===== Gives the correct answer but can't use an index properly.
-- Will only do an Index SCAN, no chance of...
May 21, 2008 at 9:42 am
How do they limit the use of Indexes? I've never heard of this before.
May 21, 2008 at 9:37 am
Viewing 13 posts - 16 through 28 (of 28 total)