Viewing 15 posts - 46 through 60 (of 73 total)
It seems like it works! In a single SQL, thats amazing...
Ty, you guys rock!
*christmas hug*
December 12, 2011 at 4:07 am
Cadavre (12/12/2011)
Be aware, this code is different to Jim's because I think he was hitting the tables more than he needed to.
Thank you for your insight. There's a problem though...
December 12, 2011 at 3:27 am
Jim-720070 (12/9/2011)
Hmmm... I have to disagree with you...
Oh, i just run the code without removing the "WHERE RecentJob = 1" part.
The code works exellent and has alot better execution...
December 12, 2011 at 1:04 am
Jim-720070 (12/9/2011)
I fear there's been a certain amount of 'scope creep' in this request..Can I ask what is the purpose of using the modulo operator?
Yes definitely scope creep problem, sorry...
December 9, 2011 at 4:20 am
Jim-720070 (12/8/2011)
Are we getting warmer???
Wow, yes, we certainly are!
There's a couple details left...
If Noah gets an ongoing job, he's still going to be drafted by the query. (Users having ongoing...
December 8, 2011 at 1:54 pm
First and foremost ty for the input, both solutions worked!
I understand that our dates structure is not optimal, unfortunatly it's already in use and its not possible to change it...
December 7, 2011 at 2:12 pm
Cadavre (12/1/2011)
Not sure I know what you're asking. Does this help?
Ty, that was exactly what i was looking for!
December 1, 2011 at 7:40 am
Im kinda new to sqlserver myself, but this kinda worked for me
SELECT DISTINCT [yourtable].[RegisterNo] FROM [yourtable] INNER JOIN [yourtable] as [yourtable2] ON [yourtable].[RegisterNo] =[yourtable2].[RegisterNo]+1 WHERE [yourtable].[CourseID]=08027 AND [yourtable].[ExtMark]=96
UNION
SELECT DISTINCT [yourtable].[RegisterNo]-1...
November 25, 2011 at 5:36 am
Oh, ty so much, it actually worked after all. I realize now that i've missed a couple of html errors in my prototype version! Which XML noticed and threw up...
November 25, 2011 at 3:27 am
Adi Cohn-120898 (11/24/2011)
Why are you using an XML in the select with for xml clause?
I used it to demonstrate the problem. The actual code looks like this:
declare @clikesstring varchar(MAX)
SELECT...
November 25, 2011 at 2:23 am
That's really exciting, wasn't aware of the FOR XML option! SQLServer surprises me on daily basis with it's functionality.
@Lowell
Ty for the example it will help me out alot.
@drew.allen
Wait, so,...
November 23, 2011 at 7:52 am
Lowell (11/23/2011)
Your example involving user and Education tables is really at odds with an email campaign.
here's a rough example i just sketched out that woudl use a cursor to send...
November 23, 2011 at 6:48 am
Sean Lange (11/22/2011)
You know looping is absolutely horrible for performance (and you have nested loops which is even worse).
Yes, i am aware of that. I am trying to build a...
November 23, 2011 at 12:48 am
Oh great, i got it! Did'nt really know what rowcount did, changed it around and it works 😀
declare @u_id char( 11 )
declare @e_id char( 11 )
set rowcount 0
select TOP 10...
November 22, 2011 at 5:59 am
Cadavre (11/10/2011)
What happens if you add COLLATE ?
IF @MyEmail COLLATE SQL_Latin1_General_CP1_CI_AS = 'mymail@gmail.com'
This worked great ty.
November 22, 2011 at 3:14 am
Viewing 15 posts - 46 through 60 (of 73 total)