Don't say sorry! Thank you for the feedback and all the help in other threads! 🙂

Greets

Flo

RBarryYoung (4/10/2009)

---

Unfortunately Flo, the INFORMATION_SCHEMA views do not...

Hi

If you don't have SSMS on your web server try this (sounds strange but works 😉 ):

* Create a new, empty "Text File" in explorer. Rename the file from ".txt"...

Hi Vijaya Kadiyala

I'm...

Hi

Since your count of databases is not too much you can use a VARCHAR(8000) and Barry's suggestion to use the INFORMATION_SCHEMA.TABLES:

DECLARE @sql VARCHAR(8000)

SELECT @sql = CASE WHEN @sql IS NULL...

Hi

I supposed that the "first" row is identified by the MIN(item_key)...

So first update the Consultants and set the SUM of hours to the first Consultant, then delete all other rows:

;...

Hi

I can confirm Monica.

On SQL Server 2008 x64 (I know 2008... but no other x64 available at the moment):

Msg 536, Level 16, State 1, Line 1

Invalid length parameter passed to...

maxine (4/10/2009)

---

Flo this also worked great and in fact I did say I would want all records returned if no parameters were selected but in reality this would be probably...

Hi

My solution would be quiet alike Andrew's first. I just would negate the AND-OR to avoid to get all values if all parameters would be NULL:

WHERE (@LoggedDateFrom IS NOT NULL...

GilaMonster (4/10/2009)

---

Oh, but they can.

'15d1' and '15e1' will cast successfully to float. '10,0' will...

Hi

If your users are connected via domain authentication you can use the sys.dm_exec_sessions. Have a look to the login_name column:

SELECT * FROM sys.dm_exec_sessions WHERE session_id = @@SPID

If not you can...

GilaMonster (4/9/2009)

---

The other potential problem being that there are cases where ISNUMERIC returns true, but the value cannot be cast to decimal. ISNUMERIC means that the value in question can...

Remove all those "DECLARE *** TABLE " parts. Just leave the INSERT statements and add your destination and source columns.

Greets

Flo

I've never seen this error, but I won't doubt. Just an idea:

Is it possible to add an column IsNumber to the table? If yes you can UPDATE once after loading...

Hi sward

Here a little walk-through.

ALTER procedure [dbo].[move_ebs_learner]

(

Remove the brace in the second line.

DECLARE @wce_ilr TABLE (

[Created_date] [smalldatetime] NULL, ...