per Brians request, here's a parameterized stored proc using the logic i posted above;

there's some cleanup that should be introduced where im arbitrarily doing a REPLACE of vbLf with...

i would call SSMS a developer tool, and don't think it's really a tool for end users to be working with; it doesn't have any place like Access does to...

brian wow it's been a while since i saw this thread.

Today, I actually do the same with regular expressions and a CLR; if that's an option, let me know and...

Krishna1 (4/8/2013)

---

if my table is customer having column col1,col2 ...

in the select query i want all the developners to access it in the query as

select customercode, customername

from mycstomer

instead of

select col1,...

and a bevy of images here:

SSMS 2008 Images/Screenshots

As far as i know, a SYNONYM must point to an object, that is, something that exists in sys.objects. that's typically, a table/view/procedure/function, but could technically be anything that exists...

i think you can streamline it a bit by using a neat technique using SUM(CASE..)

SELECT

SUM(CASE WHEN SALARY BETWEEN 10000 AND 20000 THEN 1 ELSE 0 END) As Range1,

SUM(CASE...

it might not be obvious;

for example, if it's a windows account, ie mydomain\lowell has too much access, it's probably because i'm in a windows group

that has direct or implied access

SQL...

it sounds like the user in question has a LOGIN which was granted sysadmin privileges.

i don't have QA available for SQL2000 anymore, but you can go to the properties of...

i'm not clear ont he question, i may be reading it too fast.

if the question is "how do I execute a stored procedure via OPENQUERY,a dn capture the results, the...

DDL only, or DDL and also the data?

if it's just the DDL , i'd use the SSMS scripting wizard.

IN SSMS Object Explorer,

Right Click on a specific database.

Click Tasks>> Generate...

adinica (4/5/2013)

---

Thank you. It was exactly what i was trying right now. I have a question, how do I refer to the server I am on in the openquery? Is...

if you create a permanent or temp table that has the shape of the data, you can insert into it;

a rough example, but it works on my side, assuming the...

i think the OP should probably just convert the time to seconds, and use DATEADD whenever he needs to fiddle with the values.

at least , as an integer, you could...

doh! now i see it!

i just peeked at my other instances, and the same code is in 2008R2 and...