and virtually, because we have a sub-select, we can just filter the results right there in the SQL statement:

SELECT

IndivdualId,

City,

...

how about changing the drop down into an optional text field...that way if the user KNOWS the ID, they can just type it in;

i'm no SSRS expert, but...

one way is to create a view that has one record per Id, then you get jsut the "current" people in TX in your example:

CREATE VIEW CurrentAddresses

AS

SELECT

...

i would swear there was a similar post a few months back, and i seem to remember that if a query uses parallelism, you can see this behavior?

fish that table is for an Oracle definition, and not SQL server.

just creating the table is not enough, don't you need to insert some data into the table before querying...

session is single_user mode, or the database?

if it's the database,

you can look in sys.databases for any databases with user_access_desc = 'single_user', and then compare the results to who's...

npyata (5/2/2013)

---

Here is the code. This is my first step in the process and after this seq_no update I need to update some other columns based on this seq_no.

USE...

there are lots of other functionalities that SSMS assumes you must have sysadmin rights in order to perform actions;

most of the nodes in the Object explorer assume it, ...

thank you Gail!

they are the same query, but with a some expressions to calculate the field values.

test it yourself by looking at the actual execution plans when you run them.

they will both...

Tobar (5/2/2013)

---

Anyone have an idea why the varchar data type is limited to be 1 through 8000 or MAX(2GB) but none of the numbers between 8001 and 2GB?

Just one...

duplicate post.

There's no need to post the same question in multiple forums.

The Recent Topics function most people use shows us your post immediately.

crossposting will wastes people's time and fragments replies....

wow it's been a long time since i had to do this in SQL2000;

SQL 2000 doesn't support row_number() functions either.

if you can go without row_number, it just becomes a sub...

a slight modification if you are using windows authentication:

-- we need a login for the Web To Use:

CREATE LOGIN [DEV223\ASPNET] FROM WINDOWS WITH DEFAULT_DATABASE=[master]

--pick the right db!

USE [WHATEVER]

--now we...

here's an example i adapted from another one I've used int eh forums here:

-- we need a login for the Web To Use:

create login WebUser with password = 'NotTheRealPassword'

--pick the...