Viewing 15 posts - 886 through 900 (of 5,504 total)
Why don't you throw in a statement like "Well, we might need to look into alternative tools then. Have you (the vendor) ever heard of RedGate products?" 😛
October 27, 2011 at 10:52 am
It sounds like a Running Total scenario. Google might help to return a more detailed information.
Depending on the SQL skills available, the "quirky update" method might be an option,...
October 25, 2011 at 3:09 pm
LutzM (10/23/2011)
Create a view on the Oracle side and query the data based on the view.
To be a little more specific (and to expand on what Grant mentioned): the view...
October 23, 2011 at 7:21 am
Grant Fritchey (10/23/2011)
I just hope the vendor isn't one near & dear to my heart.
Yeah, there are lots of reasons to use a third party backup method. For example, we...
October 23, 2011 at 6:08 am
Create a view on the Oracle side and query the data based on the view.
October 23, 2011 at 2:46 am
Looks like an oracle syntax error ("ORA-00936: missing expression").
That would be the point to start.
(Un)fortunately, I have no idea about oracle.
October 23, 2011 at 2:44 am
duplicate post. no replies please.
Original post: http://www.sqlservercentral.com/Forums/Topic1194914-363-1.aspx
October 23, 2011 at 2:43 am
I guess it's more an issue of getting a comma delimited list instead of pivoted data.
If that's the case, the FOR XML PATH approach as demonstrated here might be more...
October 23, 2011 at 2:40 am
kstjacques (10/21/2011)
So the good news is the vendor is saying they will look into fixing the issue.
My favorite part of the latest response...
October 22, 2011 at 10:34 am
What exactly are you trying to do?
If there's a conversion error you might use a different data type than int for @tempian.
Other than that it looks like there's a general...
October 22, 2011 at 10:23 am
SQL_By_Chance (10/12/2011)
Try using CTE with ROW_NUMBER() . Delete from CTE where rowNUM > 1
I don't think this will help here since both rows need to be merged (to combine the...
October 12, 2011 at 1:34 pm
Elliott Whitlow (10/12/2011)
You have several options.
...
You could use a linked server using a trigger.
Lots of options, a lot depends...
October 12, 2011 at 1:26 pm
Here's a solution using XQuery to parse the (obviously) xml data. Since I don'T know the data type of the related column, I used a cte to convert it into...
October 12, 2011 at 1:16 pm
Please attach the actual execution plan (not the estimated) as sqlplan files. Jpegs won't help much here...
Also, please post table and index definition of all tables involved and the actual...
October 12, 2011 at 12:59 pm
Jeff Moden (10/9/2011)
October 9, 2011 at 2:44 pm
Viewing 15 posts - 886 through 900 (of 5,504 total)