Viewing 15 posts - 6,106 through 6,120 (of 15,381 total)
Minnu (12/17/2013)
Hi Team,Please help in below query, it should return TRUE.
DECLARE @req_1 varchar(50)
DECLARE @req_2 varchar(50)
set @req_1='AAM'
set @req_2='VVE'
if (@req_1 !='AAM' OR @req_2 !='VVE')
print 'TRUE'
ELSE
print 'FALSE'
What is the business rule...
December 17, 2013 at 7:32 am
Here are some excellent ways to get a number of different datetime values. http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/%5B/url%5D
December 17, 2013 at 7:24 am
Yes it sounds like you need to join your tables together. What have you tried so far?
December 17, 2013 at 7:21 am
We can help you but you need to provide way more information for us first. Please see this article about best practices when posting performance issues. http://www.sqlservercentral.com/articles/SQLServerCentral/66909/%5B/url%5D
December 17, 2013 at 7:07 am
Ed Wagner (12/17/2013)
jasona.work (12/17/2013)
Ed Wagner (12/16/2013)
jasona.work (12/13/2013)
Ed Wagner (12/13/2013)
jasona.work (12/13/2013)
I mean seriously, 12 days until X-Mas? It feels like it was only a couple...
December 17, 2013 at 7:04 am
defyant_2004 (12/16/2013)
Not sure what DAC enablement is for? If the server is down, we bring it back up for them.
We just feel the DBAs need...
December 16, 2013 at 3:14 pm
Jeff Moden (12/16/2013)
ChrisM@Work (12/16/2013)
Jeff Moden (12/13/2013)
Sean Lange (12/13/2013)
ChrisM@Work (12/13/2013)
Sean Lange (12/13/2013)
ChrisM@Work (12/13/2013)
Sean Lange (12/12/2013)
December 16, 2013 at 12:28 pm
ScottPletcher (12/16/2013)
Sean Lange (12/16/2013)
December 16, 2013 at 10:42 am
A slight modification to the fine code Luis posted should work for you. I changed the global temp table to instead use a temp table inside the dynamic sql. This...
December 16, 2013 at 9:46 am
hoanggiathanhsingles (12/16/2013)
Dear Sean!Your code is so simple but it very excellent.
It solved all my problem
Thank you so much
You are quite welcome. Glad it worked for you.
December 16, 2013 at 9:30 am
You could probably use the undocumented procedure sp_msforeachtable.
Can't give you much more specifics than that without some details about your tables.
December 16, 2013 at 9:04 am
John Mitchell-245523 (12/16/2013)
December 16, 2013 at 8:37 am
Steve Jones - SSC Editor (12/16/2013)
It snowed last week, still snow on the ground, but supposed to hit 60F...
December 16, 2013 at 8:31 am
John Mitchell-245523 (12/16/2013)
No need for a cte to do this.
The reason for the CTE is because he wants SubName instead of SubID. Also, if SubName isn't unique, that would...
December 16, 2013 at 8:27 am
No need for a cte to do this. Just join from your Marks table to the Subjects table.
December 16, 2013 at 7:50 am
Viewing 15 posts - 6,106 through 6,120 (of 15,381 total)