Viewing 15 posts - 14,866 through 14,880 (of 26,486 total)
And then there are those responses that are simply confusing. Truely some people have the gift of confusion. (No, I am not providing a link to this one...
January 16, 2011 at 5:53 pm
Gift Peddie (1/16/2011)
Lynn Pettis (1/16/2011)
Gift Peddie (1/16/2011)
I don't know Pascal and I don’t understand what you are saying about your application but transaction in the Microsoft platform is not complicated....
January 16, 2011 at 5:50 pm
paul.beattie (1/16/2011)
January 16, 2011 at 5:47 pm
LutzM (1/16/2011)
Lynn Pettis (1/16/2011)
And then you have those individuals that won't even ask their DBAs for help because they don't know them personally and are in a different building.
Strange he...
January 16, 2011 at 5:38 pm
craigbroadman (1/13/2011)
steveb. (1/13/2011)
If by replayability you mean the ability...
January 16, 2011 at 5:34 pm
Gift Peddie (1/16/2011)
I don't know Pascal and I don’t understand what you are saying about your application but transaction in the Microsoft platform is not complicated. In the application...
January 16, 2011 at 5:31 pm
And then you have those individuals that won't even ask their DBAs for help because they don't know them personally and are in a different building.
January 16, 2011 at 5:08 pm
paul.beattie (1/16/2011)
And it's not really about the database structure as such, the data is there in a...
January 16, 2011 at 5:04 pm
Have you givien us the complete error message you get from the application or just a summary of what it says.
January 16, 2011 at 5:01 pm
Have you tried getting assistance from your DBA (or DBA Group)? They should be the ones you go to first since they know the database better than we do.
January 16, 2011 at 4:52 pm
Will need the DDL for the tables involved (CREATE TABLE statements), sample data that is representative of your problem (a series of select into statements), and the expected results based...
January 16, 2011 at 4:37 pm
Where is the DDL for your tables (both permanent and temporary) used in the queries?
January 16, 2011 at 4:34 pm
Actually, nevermind, what you are looking for is this:
SELECT * FROM #Fundraising
WHERE Fund IN (select Item from dbo.NDelimitedSplit(@Fund,','))
OR
SELECT
fr.*
FROM
#Fundraising fr
...
January 16, 2011 at 4:07 pm
Now we are getting somewhere. Please post the stored proc with the query.
January 16, 2011 at 3:59 pm
Sorry, but when I attempt to view the attachment Demo Data.docx I get a zip file that does not appear to conatain anything useful.
January 16, 2011 at 3:51 pm
Viewing 15 posts - 14,866 through 14,880 (of 26,486 total)