Viewing 8 posts - 1 through 8 (of 8 total)
Hi David,
Thank you so much for taking all this trouble to help me.
Works really good!!
Regards!
August 27, 2013 at 4:39 am
Do you have an example how to do this with SQL CLR?
August 27, 2013 at 3:13 am
I really loved the article!
So I tried the same with the NS api (www.ns.nl/api), but when I put the url in firefox, I get results, but within my stored procedure...
August 27, 2013 at 1:10 am
Yes, thnx for the tip, this works.
DECLARE @DeleteDate DATETIME = DATEADD(dd,-2,GETDATE());
DECLARE @path VARCHAR(256);
SET @path = '\\myuncloc\BackupDumps\';
print @DeleteDate
EXEC master.sys.xp_delete_file 0,@path,'BAK',@DeleteDate,0;
But anyone any idea why the other code doesn't work?
July 9, 2013 at 6:47 am
Dear old hand,
Thank you for your response! What I actually want is to calculatie the number of items the customer has to buy:
itemBalk1Stof1Stof2Stof3Stof4Stof5Stof6Stof7Stof8
number of items needed46244116124
length of each item (mm)5138,15147820002698,241479,36335080013331473
available...
March 14, 2013 at 6:40 am
Hi,
Did you check the query plan? I'm quessing the new index is not being used. Can you give an example on the query you are using on that table?
Regards!
February 28, 2013 at 2:31 pm
Dear SSCrazy,
I am very impressed by your solution, so i have been looking at it for quite a bit.
What i was wondering (but can't figure it out), if you insert...
February 28, 2013 at 2:26 pm
Wow SSCrazy,
Thanks for your quick answer, this is exactly what i need!!
Thnx a lot!
February 28, 2013 at 6:44 am
Viewing 8 posts - 1 through 8 (of 8 total)