Hi,

I unistalled sql and reinstalled it and it worked. Thank you very much

You are right the file doesn't exist. Is it not supposed to copy the file during installation ? Do I have to re-install or I have to copty the file...

These are the startup parameters in my Sql Server Configuration path

-dC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf

Dump Directory - C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG

I'm not sure if this...

Thanks ....Silly mistake on my part

this is the table

when I select

select @Col1

select @Col2

select @Col3 I get the right values. But when I execute the script it gives me

Msg 207, Level 16,...

It returns zero rows

Hi I did a check the non date valuse are zeros ......used isdate to determine non valid dates

--select distinct Firstdisbursementdate

--from tbSales

--where isdate(Firstdisbursementdate) =1

--select distinct Firstdisbursementdate

--from tbSales...

I tried using

FROM

dbo.tbSales

WHERE Case When ISDATE(Firstdisbursementdate) = 1 AND LEN(Firstdisbursementdate)>= 8

Then CONVERT(DATETIME,Firstdisbursementdate,120)

...

I have imported the file into the Xml data type and can view it as well.

How do I turn the imported XML Into A Relational Format and insert into my...

The tables have been reduced in size and I have listed the new tables. Can Bcp work on these ?

They are two separate databases are on seperate servers and drives. So I have Server 1 as the source and Server 2 as the reporting server.

I've attached the the spreadsheet with the tables I want to bcp out

I know its wrong because when I look at my output and try and work it out manually its wrong. Thats why I'm wondering if my query is giving me...

USE EDW_Stage

DECLARE @Col1 VARCHAR(10),@Col2 VARCHAR(10),@Col3 VARCHAR(10)

SET @Col1 = (SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS

...

ENDED UP RE-WRITING IT

SET @Records = (SELECT COUNT(*) FROM EDW_STAGE..tbComm_3Months_Ago)