Viewing 15 posts - 1 through 15 (of 32 total)
How about
RIGHT(REPLICATE('0',@size) + CAST(@value as varchar(max)),@size)
July 2, 2015 at 10:14 am
Will this be in sub report?
October 4, 2013 at 7:46 am
This is what I use in RegEx
Regex.Replace(allText, @"""((?:""""|.)*?)""(?!"")", @"|~|$1|~|").Replace("\"\"", "\"")
April 1, 2013 at 8:16 am
I tried all above replies before posted this quetion. And no my csv format is not incorrect. If you cut and paste three lines in notepad and save the file...
March 31, 2013 at 9:25 am
Yeah, I guess that is better option.
Thanks.
January 18, 2013 at 12:48 pm
GilaMonster (8/29/2012)
Expected behaviourhttp://sqlinthewild.co.za/index.php/2010/02/18/not-exists-vs-not-in/
Thanks Gail, your article make sense and I will use EXIST instead of IN now.
August 29, 2012 at 1:09 pm
So there is no way I can store this on my c: drive, right? and its always on server side?
August 28, 2012 at 2:11 pm
GilaMonster (8/28/2012)
Set up a server side trace, save...
August 28, 2012 at 1:35 pm
Oops, missed it. I will try and let you guys know the performance.
Thanks.
April 24, 2012 at 9:27 am
How do I use table-valued UDFs instead of scalar-valued UDF? Can you please show me in my query.
Thanks.
April 23, 2012 at 4:12 pm
Thank Gail and Lynn,
I will have to think more about my function and will rewrite to optimize it.
Gali - I read the article provedied in your link and make...
April 23, 2012 at 3:27 pm
SELECT * from Client Join @tblClientIds ON @tblClientIds.Id = Client.ClientId
November 17, 2011 at 10:14 am
corder (11/15/2011)
You'd probably want to even make it use a join instead of the INCliff
I tried JOIN but gives me same error, can't join with table variable. That is strange;-)
November 16, 2011 at 1:13 pm
Thanks all.
I thought of workaround like counting # of records and use If Else condition. But I wanted to keep Table variable optional, but looks like that is not a...
November 16, 2011 at 8:39 am
Expand the server node, click on Data Transformation Services, Click on Local Packages, Find your package on right panel, right click on the package and click on schedule package and...
February 8, 2011 at 2:54 pm
Viewing 15 posts - 1 through 15 (of 32 total)