i apologise for i did not see the 'why' you asked ,

i would like to create the duplicates to fulfill a criteria in a broader context of a stored...

yes, i want to create these duplicates.

Theres a column that has a header as Day part and the data like this:

Daypart

FrSu 6A-9P

Mo,Th 10A-3P

Mo,Th 3P-7P

Mo,Th 6A-10A

MoFr 10A-3P

MoFr 3P-7P

I changed the file to a .txt file, see the error i am still getting:

NULL

Starting copy...

SQLState = 22005, NativeError = 0

Error = [Microsoft][SQL Server Native Client 10.0]Invalid character value for...

the fields and the columns are many, if i were to post here, it would be dissarranged,

heres a few of the fields...

Metro rankMetro NameDMA#DMA NameCallsShow NameContract Start DateAdd Date

68Grand...

output

User name not provided, either use -U to provide the user name or use -T for Trusted Connection

usage: BCP {dbtable | query} {in | out | queryout | format} datafile

...

Thanks Allan, this throws an error, i passed the column in the table and set that column as the default value for the variable @time ,

i did this:

DECLARE @Starttime varchar(10)...

Thanks Guys, This is Fixed,

i wrapped it Up in a procedure and it worked just fine.

Thanks

Ed Wagner (8/30/2016)

---

JALLYKAMOZE (8/30/2016)

---

Hello,

I have a problem where i want to get the diffrence in minutes between two times, my datatype is TIME, i have also used the function below...

Grant Fritchey (8/29/2016)

---

You're saying parameters and variables. Let's get real clear, because it matters. Parameters are values defined with the CREATE statement for a stored procedure, as part of the...

hello ,

This is what i came up with:

tested and it worked, but for some reason it is omitting some data from the base table..i am still doing some research on...

drew.allen (8/25/2016)

---

JALLYKAMOZE (8/25/2016)

---

CREATE TABLE DELAYSECONDS(

ProgramID INT, ID INT, ContractHeaderID INT, ContractStartTime TIME, ProgramStartTime TIME ,ContractDetailFirstDay INT ,ProgramFirstDay INT, DelaySeconds INT)

INSERT INTO DELAYSECONDS

VALUES (625, 625, 115278, '18:00:00', '18:00:00', 2, 2,...

J Livingston SQL (8/25/2016)

---

I asked a similar question on one of your earlier posts.....

for example

"ProgramFirstday" = 1

"ContractDetailFirstDay" = 7

how do you determine whether this is 6 day delay OR...

Alvin Ramard (8/25/2016)

---

JALLYKAMOZE (8/25/2016)

---

Alvin Ramard (8/25/2016)

---

It would also help if you provided us with proper information. The SQL logic you provided does not work!

CREATE TABLE DELAYSECONDS(

ProgramID INT, ID INT,...

Alvin Ramard (8/25/2016)

---

It would also help if you provided us with proper information. The SQL logic you provided does not work!

CREATE TABLE DELAYSECONDS(

ProgramID INT, ID INT, ContractHeaderID INT StationID...