Thanks for the reply Craig. As mentioned in my previous post, I don't need to worry about SQL injection in this case.

Look up using the delimitedsplit8k function here. It...

Thanks for the reply Calibear. That's what I figured - I wound up using the syntax from the last query I posted which is exactly what you suggested:

AVG(a.RatingValue) FOR...

Hello,

It's also worth noting that when declaring variables, the scope of the variable is dependent upon where you recently clicked your mouse. For instance, if you...

Hello,

Well one way to do this is to find out which stored procedures are referring to the table that contains the trigger. Once you...

Hello,

The :: syntax is also used to call the static Geometry and Geography data type methods. For instance:

Declare @test-2 Geometry

Set @test-2 =...

Paul,

The reason that BCP does not log these rows into the error file is because they are not considered errors. BCP will do one of 2...

Hi,

It's also worth mentioning that if you need to re-enable your foreign keys, you have the option of verifying the integrity of these keys. For example:

Alter Table...

The following links provide good tutorials for creating an SSIS package programmatically using VB or C#:

To call an existing package:

http://www.codeproject.com/KB/database/CallSSISFromCSharp.aspx

To create a new package from scratch, as well...

As an alternative, you can also enable xp_cmdshell in code by running the following:

exec sp_configure 'xp_cmdshell', 1

Reconfigure

Bob Pinella

David,

Based on the information you have provided, you may just want to import your data using the BULK INSERT statement with a format file. ...

I don't believe that you can use a format file to ignore quotes. It is simply used to map the columns from the data file to the SQL Table...

Thanks ALZDBA - These forums have helped me a great deal in the past, so it's nice to give back once in a while!

Bob Pinella

Also, on a side note, it is not recommended to use the prefix "sp" for user-defined stored procedures. This prefix is used with system stored procedures and can affect...

Hi,

As pduplessis mentioned, you may be able to reduce the table size by modifying the data types of the fields in the table. If you...

Hi,

You have to register the linked server in order to use OPENQUERY. Here is a simple example for the use of OPENQUERY:

...