Mohit (3/7/2009)

---

Yaa probably "c.id *= o.customer_id" causes me alot of heach though when upgrading old SQL 6.5 applications to newer version. I always always trying to talk to my...

Yeah there is no other language more flexible than SQL... I'm doing that since about ten years now and I'm still learning 🙂

For the SQL formatting:

I saw this first time...

Hi Mohit

No, they are not always same. If you use a LEFT JOIN the criteria within the JOIN part will only be used to restrict the right side.

I extended my...

Hello

It is possible to swap conditions between FROM and WHERE if you are using an INNER JOIN. This makes sometimes sense for a faster execution.

But sure there are also own...

Hi

Did you add the windows user account to the server logins and the database users (e.g. with roles db_datareader, db_datawriter)?

Greets

Flo

Well

[font="Courier New"]

IF (OBJECT_ID('old_table') IS NOT NULL)

   DROP TABLE old_table

CREATE TABLE old_table (id INT, oldField VARCHAR(100))

IF (OBJECT_ID('new_table') IS NOT NULL)

   DROP TABLE new_table

CREATE TABLE new_table (id INT, oldField VARCHAR(100), newField VARCHAR(100))

GO

INSERT...

You need the linked server and the authentication information for the remote server.

Here is a working SQL example. You only have to put the information into your VB code.

[font="Courier New"]--...

Hello Simon

If you want to create incremental values in an existing table the fastest (and most simple 😉 ) way would be:

[font="Courier New"]

DECLARE @rank INT

SET @rank = 0

UPDATE #Table SET...

Hi

Change "SQLNCLI" to "SQLOLEDB" than it should work.

Greets

Flo

Maybe the most simple way would be to create views for all the tables you have to handle and let the users JOIN this view instead of the tables. So...

Hi Al

If your binary is less than or equal to 10 bytes you can use the not documented Microsoft function fn_cdc_hexstrtobin 😉

SELECT master.sys.fn_cdc_hexstrtobin('AE01')

Greets

Flo

Hello

Some information would be useful:

* Can you post some sample data of the file?

* Can you post the message returned by BCP?

* Can you post your table structure?

Greets

Flo

Try the statement on one of the old tables which do not have the columns "Available" and "RevCode". The difference is the quoted Y.

Select RevID,JoinDt,Budget,'Y' as Available,5 as RevCode...

Yes, why don't you just try? Just quote the Y with "'" as...

Hello Franco

That's the needed information 🙂

A little sample:

[font="Courier New"]IF (OBJECT_ID('tempdb..#dest') IS NOT NULL)

   DROP TABLE #dest

CREATE TABLE #dest (id INT IDENTITY, phone VARCHAR(100))

DECLARE @content VARCHAR(MAX)

SELECT @content = BulkColumn

   FROM OPENROWSET(BULK...