Ok, it ran when I took out everything in the path except the file name.

• This reply was modified 2 years, 10 months ago by  DSNOSPAM.

SQL Server (MSSQLSERVER)Provides storage, processing and controlled access of data, and rapid transaction processing.StartedAutomaticLocal System

SQL Server (SQLEXPRESS)Provides storage, processing and controlled access of data and rapid transaction processing.StartedAutomaticNetwork Service

SQL Server...

Ok, went to control panel, found administrative tools, found servers, but nothing is giving me any version numbers.

Trying to get an image or a list to post.

Sorry for being such a doofus on this. Only place I know to go look at services is under the Task Manager window after hitting CTL ALT DEL.

I've looked...

I can see SQL Server 2014 in my programs list, but can't seem to find an instance of it to connect to from SSMS

version is:

Microsoft SQL Server 2005 - 9.00.5000.00 (Intel X86) Dec 10 2010 10:56:29 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 6.1 (Build...

I've got that script, trying to run it. I have run SQLCMD since 1988!

I created a new query, went to the Query menu choice, and clicked SQLCMD Mode.

It gave...

I think I have 2008 Dev. Edition on my laptop. Problem is, it is R2, or I updated to R2, and when I went to run SSAS stuff, from...

I'll check into that.

Thanks.

I think the problem was that @tbl vs @source_tbl. I was copying code from somewhere else (where I was forced to use dynamic sql for a table name in...

I caught that 'sp' instead of 'fn' and changed that in my code. Oh crap, the problem was that I had two different versions because of that 'sp' vs...

Thanks everyone. I didn't catch those mistakes. However, I'm still getting zero.

alter FUNCTION spGet_Rec_Count

(

@source_tbl varchar(100)

)

RETURNS bigint

AS

BEGIN

-- Declare the return variable here

DECLARE @count...

no chit.

I guess you should let me know what you mean by code.

Unless it's really quick and dirty, there's no time to set up code. I'm just being thrown a...