If these are flat files, you could also create stored procedures using bulk insert.

If names and schedules (possibly format/columns) are different, why don't you create 2 packages with the correspondent schedules?

For the names, just set the connection string as an Expression and use...

You need to run it multiple times or if the output is the same, just copy the file.

SQL!$@w$0ME (1/8/2016)

---

Hi Guys,

What tool should I use to create tables as part of a db design(from logical/conceptual model). I'm new to development/design.

DB model has been created on Visio 2010.

Please...

Ed Wagner (1/8/2016)

---

Brandie Tarvin (1/8/2016)

---

rodjkidd (1/8/2016)

---

Brandie Tarvin (1/8/2016)

---

Here's a funny. The notification algorithm sent me an email from askssc.sqlservercentral.com telling me that I'd been mentioned in someone's query. But I...

guy 1966 (1/7/2016)

---

I try this :

UPDATE `categories` SET `parent_id`= 0 [2055] WHERE `sort_order`= 1

the 2055 is the value to try to applie, but I have error syntax... I use...

Here are 2 options. Analyse them, test them and choose.

UPDATE t

SET PROV_NBR = x.PROV_NBR

FROM PARTB t

CROSS APPLY ( SELECT TOP (1) p.PROV_NBR

...

guy 1966 (1/7/2016)

---

So here I would like to insert a value X in a column that `parent_id` conditionally called in the column which is called` sort_order` the value 1 is...

You might have some problems with your network making you lose connectivity with the server or someone (or something) is killing your connection.

I agree on staying with tested solutions. However, I just wanted to leave an idea on how it can be done by using a starting date (I chose the first...

I've seen that several times. It happens with...

Sergiy (1/6/2016)

---

Lynn Pettis (1/6/2016)

---

Unfortunately you failed to recreate the function as originally coded. You are relying on the existence of a tally table in the database. The original...

Unfortunately, they're hiring people from India instead of the southern neighbors. However, I always remember a meme about this: http://i.imgur.com/shDmF0L.jpg

I hope I don't offend anyone in here.

Sergiy (1/6/2016)

---

You know, people been splitting delimited lists for many...

Been following this discussion, but I didn't feel like getting in it.

I believe that over use of CTEs is as bad as the lack of CTEs. I'd rather hire a...