May 12, 2008 at 11:49 am
SELECT o.NAME, o.LANID, o.FILE_TIMESTAMP, n.NAME AS NEW_NAME, n.LANID AS NEW_LANID, n.FILE_TIMESTAMP AS Expr3
FROM (SELECT NAME, LANID, FILE_TIMESTAMP
FROM dbo.XML_GSK
WHERE (FILE_TIMESTAMP < '2008-05-11')) AS o FULL OUTER JOIN
(SELECT NAME, LANID, FILE_TIMESTAMP
FROM dbo.XML_GSK AS XML_GSK_1
WHERE (FILE_TIMESTAMP = '2008-05-11')) AS n ON o.LANID = n.LANID AND o.NAME = n.NAME
Why when I run this query in Management Studio VIEW it returns
"Unsupported data type" values for "n" table
Where is the good old way to design a query - Right Click table/Query?
VIEW - Is it the only way to construct the query
in GUI now in 2005?
May 12, 2008 at 12:29 pm
can you post the ddl of XML_GSK ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
May 12, 2008 at 2:20 pm
If I understand what you're asking, you can use Management Studio to create a select statement for a table by right-clicking the table name, then "Script Table as", "SELECT to", "New Query Editor Window"/"Clipboard".
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 12, 2008 at 4:08 pm
Instead right click on the "Views" Folder and select "New View", You'll be provided with a GUI to create the query.
May 13, 2008 at 6:16 am
But in SQL Server 2000 I didn't have to create any new objects,views.
I could design a query and close it.
(Highlight table name, right click, query)
May 13, 2008 at 7:09 am
Indeed, you'll spend most of the time getting used to the new GUI with SQL2005.
You can always right click on a table and select "edit" (SP2) then it will show you all data in that table.
Or select the "script table" as option.
But once you're used to it, it is lovely because practicaly every action you want to do is scriptable.
Make sure you are on SP2 ! because of the GUI changes !
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
May 13, 2008 at 7:48 am
Guys,
I'm not talking about scripting what you do.
I'm talking about designing query in GUI.
Sometimes it helps to visualize things. Especially if it's a new database
you are not familiar with.
So far I see there are two options to design it in GUI.
1. Create new view
2. Top toolbar/Query/Design Query in Editor (Ctrl+Shift+Q)
The second option has limitations. You only design the query
but you can not test it in the same window. There is no "Results" pane.
Pretty strange....
May 13, 2008 at 8:25 am
Are you on RTM, SP1 or SP2 ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
May 13, 2008 at 8:42 am
productversionproductleveledition
-----------------------------------------------------
9.00.3175.00SP2 Standard Edition (64-bit)
May 13, 2008 at 9:27 am
I haven't designed a query graphically in so many years that I'm afraid I really can't help you on this one. Sorry.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 13, 2008 at 11:20 am
That's it.
I figured it out.
The only way to have a GUI environment in 2005 that is similar
to Enterprise Manager "Open table/Query" feature
is:
1. right-click on table
2. click on "Open Table" (this will start returning all the records from the table...horrible)
I normally press "Stop retrieving data" icon at the bottom
3. Right-click anywhere in the results grid
4. Go to "Pane"
5. Select Diagram,Criteria,SQL
If you right click on the diagram pane you can add tables like in Enterprise Manager.
At this point you're finally back to the convenient Query Designer environment it used to be in SQL 2000.
In my opinion it's a drawback in query designing capabilities in SQL 2005.
But have what we have.
Rob
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply