Viewing 15 posts - 61 through 75 (of 2,894 total)
Alan.B (12/10/2014)
Wouldn't this be faster?
-- the function
CREATE FUNCTION dbo.DIGITSONLYAB(@pstring varchar(8000))
RETURNS TABLE WITH SCHEMABINDING AS
RETURN SELECT ISALLDIGITS = CASE PATINDEX('%[^0-9]%',@pstring) WHEN 0 THEN 1...
December 11, 2014 at 9:07 am
Luis Cazares (10/8/2014)
That's weird, I'm sure that integers would be implicitly converted into strings as shown on the examples from BOL.
You are absolutely right, CONCAT works without any conversion. So,...
October 8, 2014 at 10:17 am
TSQL Tryer (10/8/2014)
I'm trying to cast/Convert the whole of the concatenation result. I take it you cant' do that?
You can, but in your case it will fail before getting there...
October 8, 2014 at 9:50 am
mballentine (10/8/2014)
This is the URL for the screenshot of the rdl filehttp://i62.tinypic.com/f9mxi1.jpg
This is the URL for the screenshot of the report
http://i60.tinypic.com/16av09k.jpg
Thank You
Cool links, thank you!
Guys, you will love these...
October 8, 2014 at 9:47 am
nto very clear what exactly you want to CAST or CONVERT, but lets assume it;'s a ROW_NUMBER...
CONCAT(PER.[PERSON-REF]
,CAST(ROW_NUMBER()...
October 8, 2014 at 9:44 am
select StudentID
,ClassId
,StartTime
,EndTime
...
October 8, 2014 at 9:24 am
pkjsh13 (10/7/2014)
@Eirikur yes a join would have been more efficient but I was trying to understand this particular behavior and not focus on...
October 8, 2014 at 3:00 am
Looks like course work to me...
So, would you post whatever you alreday tried so far, and we will help you to learn other than give you straight answer which will...
October 8, 2014 at 2:41 am
That is very easy to explain, try:
select max(sal) as sal from b where id = 99999
over
select sal as sal from b where id = 99999
See the difference?
The first...
October 7, 2014 at 10:39 am
Untill you clearly and accurately specify what is your input sample and what is expected output based on that exact input sample, it is really hard to understand what you...
October 7, 2014 at 10:32 am
you can try:
DECLARE @sql NVARCHAR(MAX) = ''
CREATE TABLE #tResults (TableName VARCHAR(50))
SELECT @sql = @sql + 'INSERT #tResults SELECT ''' + st.name + ''' WHERE ' +
...
October 7, 2014 at 8:59 am
Herpington_McDerpington (10/7/2014)
In the simplest of terms I am trying to retrieve a list of tables, but only tables that meet a condition.
DB1 has 13,000...
October 7, 2014 at 8:19 am
serg-52 (10/7/2014)
Eugene Elutin (10/7/2014)
UPDATE t1 SET CustomerLink = 0
FROM @tmp t1
JOIN @tmp t2
ON t2.CustomerID = t1.CustomerLink...
October 7, 2014 at 7:28 am
The problem with cross reference is that it leads to indefinite recurisvenes...
So, solution would be to resolve corss reference before going to recursive query.
I have added one more test...
October 7, 2014 at 5:29 am
Viewing 15 posts - 61 through 75 (of 2,894 total)
