Viewing 15 posts - 946 through 960 (of 2,894 total)
bteraberry (11/9/2012)
I've never had any issue with you whatsoever, but you seem condescendingly rude about some things I don't think you understand. That's not the kind of conversation I...
November 9, 2012 at 3:55 pm
Yep, ISNULL or COALESCE, but...
In order to mix string "No Data" with numerics in the same columns, you will need to convert all of them into varchar. This sort of...
November 9, 2012 at 10:13 am
Given XML sample is a bit strange.
Having <Payees> parent node kind of suggest that it may contain multiple <Payee> nodes, but <DueDates> are outside of <Payee>. So it does look...
November 9, 2012 at 4:38 am
bteraberry (11/8/2012)
Yes I did read it. Why CLR? Because it's awesome compiled code that will run very fast ... much faster than the equivalent in dynamic sql.
It's really...
November 9, 2012 at 4:27 am
bteraberry (11/8/2012)
Eugene Elutin (11/6/2012)
I don't think SEQUENCE feature will help you, as it's going to be a nightmare if you will create a sequence per customer... Also, you will be...
November 8, 2012 at 3:34 pm
DECLARE @Fromdate DATE = '01 Jan 2012'
,@Todate DATE = '30 Dec 2012'
...
November 8, 2012 at 7:29 am
DECLARE @xml XML =
'<ROOT>
<SPECIALNEEDS>
INCLUDE
<NEED>
BLIND
</NEED>
<NEED>
...
November 8, 2012 at 6:45 am
..
actually other columns in tables will be depend upon that.
...
What does this mean?
Is your database designed specifically for reporting, so you need to store formatted numeric Id's?
How business can...
November 8, 2012 at 6:36 am
andrea.mayo (11/8/2012)
Could you please perhaps give a little more detail I am new to SQL
You will need to develop this function in .NET (c# or vb.net).
If you don't know...
November 8, 2012 at 5:45 am
Your best friend here will be CLR function with RegEx.Replace.
November 8, 2012 at 5:20 am
I think that one could be slightly faster:
select t1.id
from @t1 t1
inner join @t2 t2 on t2.Id = t1.Id and t2.X > 0
cross apply (select top (t2.X) 1 from sys.columns) n(n)
November 8, 2012 at 4:00 am
It was not easy to find the difference in the code "noodles" you have, I could not even copy it from browser to my SSMS as it's too wide at...
November 8, 2012 at 3:46 am
If you need to split value in multiple rows (eg. in SELECT query), You better to use [DelimitedSplit8K] or some CLR splitter.
For single value split (let say you pass the...
November 8, 2012 at 3:26 am
sanket kokane (11/7/2012)
My Table structure is like
create table test (id char (8))
I want , whenever user insert value ,lets say 1
it...
November 8, 2012 at 3:11 am
Viewing 15 posts - 946 through 960 (of 2,894 total)