Viewing 15 posts - 16 through 30 (of 90 total)
Thanks! I will probably just keep the existing one and ignore the one flagged as missing for now.
February 11, 2014 at 1:29 pm
Yes, I can return data in xml format. The same sproc output is used by the app UI code and the app service code. App UI needs...
August 30, 2013 at 1:32 pm
Jeff,
My apologies for being slow on understanding your question.
Your question is a valid question. I am doing database development for the application teams. The teams services that take...
August 29, 2013 at 10:02 pm
Jeff,
I am not sure why the question was about CSV format? My question is to get a comma delimited string as output.
August 29, 2013 at 2:04 pm
Thank you, Chris. I got to learn the CROSS APPLY from your solution.
Many thanks!
August 28, 2013 at 2:26 pm
Hi Sean,
The solution is perfect. Thank you very much for the help!
I learned about the stuff function from you...
August 27, 2013 at 6:39 pm
Thank you for asking for clarifications. I was definitively unclear.
What I would like is a comma delimited string of order IDs that share the same product.
So when Order 1...
August 27, 2013 at 12:51 pm
Thank you for noticing. I made the correction per recommendation and things are looking good.
July 15, 2013 at 2:18 pm
That is exactly what I am looking for. Many thanks to you, Dwain.
July 12, 2013 at 7:28 pm
Hi Bala,
Thank you for the replies. Typically, the status names won't be used in the final version. The final version will use Status IDs. My sample data...
July 4, 2013 at 8:52 am
This is great, SSCrazy. It is exactly what I am looking for.
Short, simple, easy to read, thus easy to maintain.
Thank you!
July 4, 2013 at 8:49 am
Thank you Elliott. That works like a charm.
June 21, 2013 at 1:09 pm
This is what I came up with. Please help optimize it. Thank you!
declare @x varchar(max)
set @x = '<?xml version="1.0" encoding="utf-16" standalone="yes"?><Schedule xmlns="http://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer"><StartDateTime>2013-03-25T16:05:26</StartDateTime><Timezone>CDT</Timezone><WeeklyRecurrence><WeeksInterval>2</WeeksInterval><DaysOfWeek><Sunday>true</Sunday><Monday>false</Monday><Tuesday>true</Tuesday><Wednesday>false</Wednesday><Thursday>false</Thursday><Friday>false</Friday><Saturday>false</Saturday></DaysOfWeek></WeeklyRecurrence></Schedule>'
declare @StartPos int
SELECT @StartPos= PATINDEX('%<Timezone>%', @x)...
May 23, 2013 at 5:32 pm
Looking at the column data type ( varchar max) I suppose it is safe for me to look for <Timezone> and extract what comes after it up to </Timezone>.
I don't...
May 23, 2013 at 5:16 pm
Viewing 15 posts - 16 through 30 (of 90 total)