John Mitchell-245523 (6/30/2016)

---

Please post your amended script. What happens if you run the command from a command line instead of within the batch file? Obviously you'll need to...

yes same issue

Jeff Moden (12/18/2013)

---

I take that back... that's actually an illegal form of update that will sometimes work and sometimes not. I'll explain more after I see the rest of...

Sean Lange (6/20/2013)

---

ali.m.habib (6/20/2013)

---

Sean Lange (6/20/2013)

---

ali.m.habib (6/20/2013)

---

I have stored prcuder like

create proc calcaulateavaerage

@studentid int

as

begin

-- some complecated business and query

return @result -- single decimale value value

end

and then I...

Sean Lange (6/20/2013)

---

ali.m.habib (6/20/2013)

---

I have stored prcuder like

create proc calcaulateavaerage

@studentid int

as

begin

-- some complecated business and query

return @result -- single decimale value value

end

and then I want to

create...

it was stopped and when running it it raise error and by have look on the system log I found

event id :7024

The SQL Server (MSSQLSERVER) service terminated with service-specific...

Yes I did but the same eror appear, is this a problem in collation and if yes how to get the windows collation and sql server collation

Jack Corbett (11/16/2009)

---

Have you...

it's a security issue , and I am not the resposable of the design

how to update the old data such that no repeated time appear

kevriley (8/19/2009)

---

the error simply is complaining that the positioned update failed to update a row

However I'm sure this cursor can be better written - can you post table definition for...

kevriley (8/19/2009)

---

the error simply is complaining that the positioned update failed to update a row

However I'm sure this cursor can be better written - can you post table definition for...

you can't use the case like that in where clause

try this

CREATE PROCEDURE [dbo].[usp_faculty_letters_by_course_type] --usp_faculty_letters_by_course_type 'jumpstart'

@course_type varchar(50)

AS

BEGIN

SET NOCOUNT ON;

SELECT DISTINCT left(lastName, 1) as firstInitial, GRI, JUMPSTART, REMASTERS

INTO #tempFirstInitial...

select [LINKEDSERVER1].DB.dbo.T_DATE('D')

this run the function named...

Jeff Moden (7/8/2009)

---

ali.m.habib (7/8/2009)

---

Jeff Moden (7/7/2009)

---

I've never experienced BCP being slow at anything. Usually, it's the associated query that's slow. Please post both the BCP command and the...

Jeff Moden (7/7/2009)

---

I've never experienced BCP being slow at anything. Usually, it's the associated query that's slow. Please post both the BCP command and the query being executed...