Viewing 15 posts - 31 through 45 (of 507 total)
If you have 3 different databases then you need 3 different DSN's. Use the appropriate DSN for for the table you are linking. I usually have no trouble...
December 29, 2011 at 12:07 pm
nadav (12/28/2011)
the goal is to create a so called querit generator.
say there is a standard database for an ERP system (of any sort) that installed on...
December 29, 2011 at 11:59 am
Tomas,
If you start a transaction then you have to commit it or you will have an open transaction. Normally I put the BEGIN TRAN statement before the BEGIN TRY...
December 29, 2011 at 11:25 am
Don't be fooled by the % of total batch numbers in the execution plan. 8% of a batch that runs in 20 ms is much better than 4% of...
December 26, 2011 at 3:04 pm
There's really no way around compiler errors when using the 3 part naming convention.
What I've been doing when developing cross database queries is get rid of the 3 part naming...
December 26, 2011 at 2:49 pm
Now I'm going to have visions of Sybase dancing in my head.
Todd Fifield
December 23, 2011 at 5:53 pm
SQL Kiwi (12/22/2011)
Only a year too late...http://sqlblog.com/blogs/paul_white/archive/2011/12/23/forcing-a-parallel-query-execution-plan.aspx
Adding in case other Bingooglers find this thread.
Awesome article, Paul. Very informative. I just might try out the QUERYTRACEON and see what...
December 22, 2011 at 7:17 pm
apatel,
Sorry this took so long - I've been buried with work the last couple of days. I'm going to give you an example of using the calendar table described...
December 21, 2011 at 7:15 pm
Once you know which procedure has your search word, you can dump that into a table that has each line of text for the procedure. Then search the table...
December 21, 2011 at 12:37 pm
By the way, I'm in total agreement with that a, b, c stuff. Makes the code terrible to read sometimes. I try to use meaningful aliases line INV...
December 21, 2011 at 12:21 pm
Byron,
I've found that synonyms can be very useful for this sort of thing also. Extract the data from your source, Oracle, massage it in the staging table, then drop...
December 20, 2011 at 12:34 pm
There is a caveat to using such generic temp table names as #Ins and #Del. If the trigger is called from some other procedure or invoked by another trigger...
December 20, 2011 at 12:30 pm
You could also set up the Access database as a linked server. This way you can do pretty much what you want with it from the SQL Server side....
December 20, 2011 at 12:07 pm
apatel 80451 (12/20/2011)
Im successfully getting the YTD figure for the current year, but how can i compare this figure to data for the for the equivalent month the year...
December 20, 2011 at 11:57 am
Tomas,
You could look into TRY/CATCH blocks. I use them all the time. They are especially handy when you want to return a particular message. Something like:
DECLARE @ErrMsg...
December 20, 2011 at 11:38 am
Viewing 15 posts - 31 through 45 (of 507 total)