Viewing 15 posts - 571 through 585 (of 1,473 total)
3 different people have now responded with 4 different guesses as to what you're trying to do here. 😛 Please try to explain better.
It is often a...
October 2, 2009 at 3:31 pm
shalyn_bronson22 (9/29/2009)
(UnitPrice * Quantity) as Order_Cost
FROM Customers, Orders, [Order Details]
...
October 2, 2009 at 3:22 pm
Try this. Note that criteria in your WHERE clause applies to your entire query. Moving it to the left join stops these rows from being filtered.
SELECT officename...
October 2, 2009 at 3:10 pm
Of course you did, that's what you selected :hehe:.
Are you trying to build a string that is FirstName + MiddleName + LastName?
If so, you're using the wrong function.
SELECT FirstName +...
October 2, 2009 at 2:39 pm
I'm not familiar with Jasper, but the usual way around this is to split the string into 4000 character chunks and concatenate them in your dynamic sql.
So you'd split your...
October 2, 2009 at 2:34 pm
What's the error? Also, why are you selecting a variable from a table?
This works fine:
declare @string1 varchar(100)
set @string1 ='FirstName MiddleNameLastName '
select substring(@string1,1,10) FIRST
October 2, 2009 at 2:21 pm
Patindex works on varchar(max). (I just tested it on strings over 10k)
Are you certain that is what's causing the truncation? Patindex doesn't truncate anything, it just searches and...
October 2, 2009 at 2:17 pm
The double quotes might be messing you up. Use single quotes.
October 2, 2009 at 12:43 pm
This fails on my 2K8 server on 80/90/100 Compatibility levels. I'm honestly not sure how you have it working on yours.
--CREATE DATABASE Test
--GO
ALTER DATABASE Test SET COMPATIBILITY_LEVEL = 100
GO
USE...
October 2, 2009 at 10:48 am
See below.
October 2, 2009 at 10:03 am
PP-564103 (10/2/2009)
Roust_m (10/1/2009)
bitbucket-25253 (10/1/2009)
CREATE PROCEDURE...
October 2, 2009 at 7:25 am
J-F Bergeron (10/1/2009)
Here's how you can do it:
SELECT *
FROM ...
October 1, 2009 at 4:32 pm
This is a stab in the dark. It likely won't work(or be obnoxiously slow), but try it.
SELECT DISTINCT
RTRIM(F.Fund_Number) AS Fund_Number,
...
October 1, 2009 at 2:08 pm
Yikes.
Is the date you're looking to pass in always going to be a date only? (ie. no time)
October 1, 2009 at 1:55 pm
Matt Whitfield (10/1/2009)
As Richard says (and I did in a previous post), CommandBehaviour.SchemaOnly does SET FMTONLY ON behind the scenes for you.
Nice, I wondered if it might do that. ...
October 1, 2009 at 1:14 pm
Viewing 15 posts - 571 through 585 (of 1,473 total)