I have one question -

I posed a question on our technical tests for new DBA/Developers and I asked

"Name All Types of join you are aware of"

The question was deliberatly loosely...

apologies - i went from varchar(1) to varchar(2)

i'd had too much coffee

yes - my column was populated

i converted it from 'a' to 'bb' 39 million rows

if you are using management tools then this will be very slow as management studio will work on the principle of making this backwards compatible (to sql7 i think -...

you could do several things here

1st - disallow recursive triggers using

sp_configure 'nested triggers',0

but this might break other DB functionality

possibly i might suggest performing a check on the columns...

ok - let me be clear

the original post indicated that i wanted an Efficient method of getting the max value from Rown_number()

but the query inside the CTE/subquery may have...

lynn thanks - i will review this

but to note - changeing my original requirements??:-P LOL -

i think you'll find the original post said

"In this instance and send that back...

that's not really do-able for me

as i said, this might be a huge query with maybe 15 tables

so your example of

with PagedData as (

select

row_number() over...

ok - slight modification to my post

i can't supply it as an extra row in the result set - sorry

one additional thing that might make it easy (on top of the last post)

create a schema for your procs

set the schema as the new users default schema and grant permissions...

Karsten (7/7/2009)

---

I am a user for SQL Server with Wonderware InTouch. InTouch is a process visualization tool. InTouch is using the SQL Server for the Alarmdatabases and recipe handling.

I...

hold on - if they're linked servers then go to your target server, create a new login and then change the linked server login to use the new username and...

you can't script the login to the linked server - microsoft put a lovely feature in that strips out the password and replaces it with '########'

there are a few brute...

I've done loads of this and it could be any number of issues

when you're dealing with backups etc in 2008 (not sure about 2005) you'll need to make a credential...

you'll need to post your query and table structure for us to help you more.

i suspect your null values are being removed by aggregation, or if you have no entries...