|
|
-
Leonid Koyfman Commented 23 Days ago through Blogs
@ Madhivanan
Thank you for this post. Learnt something new.
I didn' t expect T-SQL Rand() takes parameter.(in other implementations(e.g. in Excel )it doesn't)
@Imran
rand()*number is not the same as rand(number).
It gives the same numbers per g...
|
-
Leonid Koyfman Commented 3 Months ago through Blogs
Hi Divya,
Why don't you build needed Date and Time string in T-SQL when you Execute SqL Task ?
Thanks.
Leonid...
|
-
Leonid Koyfman Commented 5 Months ago through Blogs
@Divya,
If PARSENAME() function is sufficient to tokenize your version pattern(less than 5 tokens)
you can sort your column with versions by each token from left to right in descending order
and pick the topmost value:
DECLARE @Versio...
|
-
Leonid Koyfman Commented 5 Months ago through Blogs
Often overlooked useful application of the modulus operator is extracting a fractional part of the decimal number.
For a number Num it will be Num%1....
|
-
Leonid Koyfman Commented 6 Months ago through Blogs
@dishdy
... and apostrophes around 0.
select 1*right(replace(num,0,space(20)),20)from @t
I believe that's it.
BTW. I learnt about space before 'from' from Madhivanan....
|
-
Leonid Koyfman Commented 6 Months ago through Blogs
@dishdy,
you challenged me. I'm not a big proponent of implicit conversion, but measured in charachters this one is shorter:
select 1*(right(replace(num,'0',space(20)),20))from @t...
|
-
Leonid Koyfman Commented 6 Months ago through Blogs
I'd use the following:
select ltrim(right(replace(num,'0',space(20)),20))
from @t
It doesnt have to be 20 spaces. At most len(num)....
|
-
Leonid Koyfman Liked 9 Months ago through Pages
We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...
|
-
IvanFroilan Question Received 9 Months ago through ASK
Hi, I want to insert sql server 2000 data into dbf file
insert into openrowset ( 'Microsoft.Jet.OLEDB.4.0',
'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\folder;Extended Properties=dBASE IV;',
'Select * from [item.DBF]')
select * from itemfact
...
|
|
|