Viewing 15 posts - 8,221 through 8,235 (of 10,144 total)
Saravanan T (1/18/2010)
Is it possible to keep my database in RAM????
Having performance issues, Saravan? Can you go into some more detail please?
January 18, 2010 at 7:17 am
Tobar (1/18/2010)
The programmer "intended" it to work the way the programmer thought they were programming it to work. 😀 [this said in the universal sense]
LOL you used to work there...
January 18, 2010 at 7:14 am
Bhuvnesh (1/18/2010)
while running the below query , i m getting the error :"The data types varchar and nvarchar are incompatible in the modulo operator."
Please post the result of the PRINT...
January 18, 2010 at 7:07 am
Stephen Hirsch (1/18/2010)
SELECT 'IN A NOT B' location, a, b, c, d, ...
FROM tablea
EXCEPT
SELECT 'IN A NOT B' location, a, b, c, d, ...
FROM tableb
UNION ALL
SELECT 'IN...
January 18, 2010 at 6:12 am
Biz (1/17/2010)
INSERT INTO [SF].[dbo].[PackageData] ([Package Grp No] ,[Account] ,[SrID],[Update Accept_Offer__c] ,[Offer_Letter_Name__c],[New Stage] ,[Package Item No] ,[Opportunity Name],[Opportunity Stage],[Course Start Date],[Opportunity ID],[Group: ID],[PackageID])...
January 18, 2010 at 3:02 am
Larry Bargers (1/15/2010)
I got it working by adding an Info class and populating that.Thanks again for the help.
You're welcome, Larry, good result.
Can I recommend that for future reference, you read...
January 15, 2010 at 10:04 am
Yeah but...kinda.
This time round, you know exactly why you would put it there, and why you will (almost) always get more results in your final output than you specified...
January 15, 2010 at 9:35 am
This bit...
SELECT Email1,Email2,Email3, Email4,Email5,Email6,Email7,Email8,Email9,Email10 FROM outputresume3
WHERE ((contains (originalresume, '"j2ee" and "java"'))
AND (currentdateout BETWEEN '2000-01-01' AND '2010-01-06'))
change it to
SELECT...
January 15, 2010 at 8:55 am
SELECT u.Email, 'Submitted by' AS UserRole
FROM Bold_FeatureRequest FR
INNER JOIN Users U on FR.UserId = U.UserId
WHERE FR.FeatureId = @featureId
UNION ALL
SELECT u.Email, 'Commented on by' AS UserRole
FROM Bold_FeatureRequestComment FRC...
January 15, 2010 at 8:14 am
SELECT MyString, ASCII(MyString)
FROM (
SELECT '000' AS MyString UNION ALL
SELECT '101' UNION ALL
SELECT '200' UNION ALL
SELECT '201' UNION ALL
SELECT '300' UNION ALL
SELECT '901' UNION ALL
SELECT ' aAA' UNION ALL
SELECT 'AAB'...
January 15, 2010 at 6:37 am
Hello
The UPDATE and the SET apply to the same table.
Ideally the first table listed after FROM is also the target of the update.
In your case, you've aliased the target...
January 15, 2010 at 4:52 am
Please set up your data as a series of INSERT statements, this will help users to begin work on your problem.
Cheers
ChrisM
January 15, 2010 at 3:51 am
ifila (1/14/2010)
After 25 years of dealing with IT people, I guess sometimes one can get cantankerous.Thanks to all the constructive contributors!
Guilty of cantankerism as charged - but hey,...
January 15, 2010 at 2:15 am
Grant Fritchey (1/14/2010)
Chris Morris-439714 (1/14/2010)
Greg Edwards-268690 (1/13/2010)
Grant Fritchey (1/13/2010)
Steve Jones - Editor (1/13/2010)
Grant,I didn't think it was that bad, but when it doubt, doesn't hurt to apologize.
Yep. I agree. As...
January 14, 2010 at 6:07 am
Viewing 15 posts - 8,221 through 8,235 (of 10,144 total)