[font="Arial"]Hello,

If you have a copy of Visio, there is a object template that has data flow diagram symbols.

If I had to analyze a 8000 line sproc, I would first take...

[font="Arial"]Hello and Good Morning,

In table JCCI, is JCCo an int and an identity field?

In table JCCI, is Contract a unique value?

In table JCCM is JCCo the value from table JCCI's...

[font="Arial"]

Hello,

Script would look better like this :

SELECT JCCI.Contract AS 'Contract #',

JCCI.Description,

JCCI.Item,

JCCI.Department,

JCCI.RetainPCT,

JCCI.OrigContractAmt,

JCCI.OrigContractUnits,

JCCI.OrigUnitPrice,

JCCI.ContractAmt,

JCCI.ContractUnits,

JCCI.UnitPrice,

JCCI.BilledAmt,

JCCI.BilledUnits,

JCCI.ReceivedAmt,

JCCI.CurrentRetainAmt,

JCCI.BillOriginalUnits,

JCCI.BillOriginalAmt,

JCCI.StartMonth,

JCCM.Description...

[font="Arial"]Hello,

I use convert(varchar(10), datecolumn, 121). This restricts the output from the convert function to 10 characters. The 121 is date format 2008-01-23 for example.

So an update...

[font="Arial"]Hello,

The report builder has to have a link to the table that is providing the drop down list.

You need to look in the sql view port and see if it...

[font="Arial"]Hello

This problem sounds more like an operating system level error. It's timing out when trying to establish the connection.

If I'm interpreting your description, this process runs in...

[font="Arial"]Hello,

Try

declare @start as varchar(11)

-- calculate most recent sunday (past)

set @start = dateadd(d, (1-datepart(dw,getdate())), getdate())

select char(10) + char(13)

,dateadd(d, 0, @start), char(10) + char(13)

, dateadd(d, -7, @start), char(10) + char(13)

,...

[font="Arial"]Hello,

The problem ( or challenge ) is with the operating system.

When you create a sub-directory with a space in the name you have to use quotes to go there.

Like :

mkdir...

[font="Arial"]

Hello,

I tried the following using the explicit conversion.

declare @firstNumber float,

@nbrString varchar(10)

set @nbrString = '123.45'

select @firstNumber = @nbrString

select @firstNumber

Result:

-----------------------------------------------------

123.45

(1 row(s) affected)

Maybe I'm missing something in your question...?

Please advise.

Thanks,

Terry

[/font]

[font="Arial"]

Hello,

Following the suggestion above....

Say you had a table of server names that you wanted to pull data from.

create table server_I_want

( rowid int identity

server_name varchar(40) null )

Then in a...

[font="Arial"]

Hello,

Maybe I'm missing something but it sounds like the debugger is not set up correctly or you are entering into the wrong debug mode at the outset.

In the debugger don't...

[font="Arial"]

Hello,

We use the command line version of bcp from within a .bat to export data from the 'working' tables. Runs quick and works reliably. Since you are in...

[font="Arial"]

Hello,

I would create a working table with a single field to store each word used. I would create an index on it and then using that table, compare the...

Hello

Try creating a table like the following :

Cretate table tenQuarters

( rowId int identity,

Year int null,

Qtr int null,

Weeks...

[font="Arial"]

Hello

Is is possible to convert the date into date part and time part in two varchar defined columns and then output the two columns that way?

Regards,

Terry

[/font]