Typo in the question!!

Daniel,

Thanks so much for the information. I will develop this with the look up functionality in a separate report.

Daniel, Thanks very much for responding. I'm wondering now if this is a normal way reporting gets done? It works for a web application, but doesn't appear to translate very...

Ok, I figuired out a solution.

You need to convert the DateTime into ShortDate string format and then convert it back to a Date. The example code I posted also picks...

I was just gonna ask if your numbers were always formatted like '15,28' with commas then you could use

declare @string1 char(20), @string2 float

set @string1 = '152,23'

print @string1

set @string2 =...

converting a char to a float will only work if the char string is in fact a valid number.

declare @string1 char(20), @string2 float

set @string1 = '15,76' -- THIS WILL FAIL

--set...

Just search your code base for the tablename?

1. for database objects like views, triggers and udf's:

select * from syscomments where text like '%TableNameHere%'

2. then search other code that accesses...

Hi, can you post the stored procedure code?

fyi, the last name and the firstname columns in the temp table are really not needed. i had them in there in case the table you are selecting from does...

Okay, this assumes that the table you are selecting from has a primary key column.

declare @maxId int -- this is the largest UserId ALREADY in the Targeted Table

select @maxId =...

Lowell, thanks for the 'Or' thing, I changed it a bit and now I'm getting what I need.

Normalization is awesome! But considering this is a 'flattened' out table for a 'reporting' data mart it was deemed necessary for 'denormalize' the information for performance reasons. Thanks for the...

wow, thanks. It works like a charm!

Anyone have ideas as to why SSMS behaves this way with SQL 2k connections?

Jerry Hung (3/23/2009)

---

That is my behavior as well

Depending on where my selection is (say I have 2 servers connected, and my selection focus is on Server #2), the newly opened...