If you need items to execute in a specific or then join them click last piece of previous step hold CTRL key and click first piece of next step, keep...

Duplicate message, see responses http://www.sqlservercentral.com/forum/post.asp?method=Reply&TOPIC_ID=3828&FORUM_ID=9&CAT_ID=1&Forum_Title=General&Topic_Title=DTS+Steps+and+Tasks+in+Disconnected+Edit

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Yes, but it was a pain. What exactly are you running into and what do you need to be able to do when you have implemented?

"Don't roll your eyes at...

Which version of sql are you using?

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Not sure, but this should do the trick

CREATE PROCEDURE TestLongParameterValue --(

-- wasn't sure you actually where inserting data and needed this parameter @InpValueList TEXT = ''

--)

AS

SET NOCOUNT ON

CREATE TABLE #tmpText...

Another way would be to use CHARINDEX to parse it into a temp table like so

CREATE TABLE #tblSel (

sels int not null

)

--You will need to test this section, and may...

Have no idea, but it is great to see that you found the issue since I would have never thought of that. Gotta love what you can find out with...

Have you checked the ODBC drive thru another app to make sure you have configured properly? Something simple like Access.

"Don't roll your eyes at me. I will tape them in...

Glad you found your solution.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

You might love this, but after I tested it works you might want to try this instead.

DECLARE @batchno INT --Or whatever datatype you need

UPDATE

BatchTable

SET

Inuseflag = 'Y',

@batchno =...

Index on computed columns is only available in SQL 2000 but it does have some limitations see "Creating Indexes on Computed Columns" in 2000 BOL.

"Don't roll your eyes at me....

You can usually find good examples at http://www.planet-source-code.com .

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Duplicate post see responses in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=3991&FORUM_ID=9&CAT_ID=1&Topic_Title=Import+Blocks+of+Data+into+db+Fields&Forum_Title=General

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Can you give me an example of what is in the file. Not sure I understand. Also please don't cross-post.

"Don't roll your eyes at me. I will tape them in...

Try

SELECT

*

FROM

tblX

WHERE

council_date >= DATEPART(yyyy,DATEADD(mm,-1,GETDATE())) * 100 + DATEPART(mm,DATEADD(mm,-1,GETDATE()))

If council_date is not an int the adjust with CAST(council_date AS INT)

"Don't roll your eyes at me. I will tape them...