Hi..

According to me the XML generates behind the package in 2008 is different from 2005.

So, the package u had made in 2005 can be used in 2008, but once it...

ifila (12/15/2008)

---

That worked great! Many Thanks.

I used a CSV input file.

Is it possible to read multiple CSV files by referencing a folder ?

I have a bunch of text files i...

msreddyn (9/15/2008)

---

Hi friends,

I have a table with two columns FromLocation and ToLocation ,these columns may contain same data or also distinct data . now i want query

data such that...

Below is a general form of a query, along with step numbers assigned according to the order in which the different clauses are logically processed:

(8) SELECT (9) DISTINCT (11)...

cdun2 (2/14/2008)

---

Hello,

I forget. How can PATINDEX be used to find column values where the data is all numeric? I've tried, the following:

select distinct acct from tbl_CYProcessedSales

where PatIndex('%[0-9]%',Acct) > 0

order by...

You can refer BULK INSERT Statement in BOL:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/be3984e1-5ab3-4226-a539-a9f58e1e01e2.htm

I've used the below code to import data thru BULK...

Hello Hari...

Hari.Sharma (7/22/2008)

---

Hi Rosh,

Thanks for reply.

I know that temp tables get created into system DB (tempdb).

Can you write a query for that?

Suppose my stored procedure looks like this:

CREATE PROC...

U can do tht by using Cursors, as like:

DECLARE @OldColumn INT

DECLARE @NewCount INT

SET @NewCount = 1

DECLARE MyCursor CURSOR

FOR

SELECT AccountNum FROM Cleansing.Customer GROUP BY AccountNum

OPEN MyCursor

FETCH...

Either re-design ur Database or jst add Identity columns in each of ur table, so tht u can easily put joins between them.

Hi...

As per my thinking, by default Trailing Spaces are not considered in strings.

So there are many ways to handle out tht... as like...

Examples below will return correct Length including Trailing...

elaine (7/17/2008)

---

We have several asp pages querying the same table, just different columns. I'm moving these queries into stored procedures. I had thought of writing just one stored...

This can also work... hav a look:

DECLARE @a VARCHAR(10)

DECLARE @b-2 VARCHAR(10)

SET @a = 'ab'

SET @b-2 = 'ab '

IF...