Viewing 15 posts - 496 through 510 (of 566 total)
Wow - NASA hired Lt. Cmdr. Data? Quite a coup!
(The actor Brent Spiner played both Data in the Star Trek: The Next Generation TV series/movies and the character in...
August 10, 2012 at 3:09 pm
Lynn Pettis (8/9/2012)
You can imaging how this can expand to views joining views, joining...
August 9, 2012 at 11:32 am
NJ-DBA (8/1/2012)
August 9, 2012 at 11:30 am
Have no doubt - joining views to views can be very problematic when the view definitions include JOINs. Typically, joining views that SELECT from only one table (as you might...
August 9, 2012 at 10:40 am
If I read your requirements correctly, you want an XML structure with an <Asset-Details> element that may have many child elements, some of them with child elements of their own....
July 18, 2012 at 12:53 pm
Lowell (3/1/2012)
it's not obvious, but you can create a linked server with...
March 1, 2012 at 11:52 am
mic.con87 (2/29/2012)
What I would like is to create two adjacent...
March 1, 2012 at 11:36 am
Lowell (2/29/2012)
you might consider creating synonyms for the objects. if there is a zillion of them, or dynamic SQL is being...
March 1, 2012 at 11:11 am
aaron.reese (2/29/2012)
I have a 2005 instance with both a DEV and LIVE database with a stored procedure which references a Linked server.
Because the linked server resides at instance level...
March 1, 2012 at 11:04 am
saghbash (1/24/2012)
January 26, 2012 at 1:01 pm
newbieuser (5/10/2011)
We get the below error when using order by clause in the select query using the linked server to Oracle table (LS..USER2.UNIT3)
SELECT U.ABO,U.LED_ID, U.PROJECT_NO, T.WORDC,...
January 25, 2012 at 1:58 pm
newbieuser (5/10/2011)
We get the below error when using order by clause in the select query using the linked server to Oracle table (LS..USER2.UNIT3)
SELECT U.ABO,U.LED_ID, U.PROJECT_NO, T.WORDC,...
January 25, 2012 at 1:49 pm
mphilippopoulos (1/23/2012)
Permissions are configured explicitly for users...
January 25, 2012 at 1:31 pm
Welsh Corgi (1/25/2012)
The function is wrong.Do you have a tested solution with that function?:w00t:
Oh, and by the way, I tested the function you posted earlier. It definitely works properly on...
January 25, 2012 at 1:05 pm
Welsh Corgi (1/25/2012)
The function is wrong.Do you have a tested solution with that function?:w00t:
Here is a function that splits VARCHAR delimited strings up to 8,000 characters in length - as...
January 25, 2012 at 1:03 pm
Viewing 15 posts - 496 through 510 (of 566 total)