Another option is to store the images in a varbinary(max) column. There are advantages and disadvantages to any of these options.

Kurt mentioned something about storage. Honestly, the storage is going...

Given the ridiculous limitations of no procs or...

Michael Smith-356657 (1/21/2014)

---

I'm reviewing some code that will run on fairly large record sets (~1M records or more). In the code the developer is selecting about 25 columns (mostly...

Need quite a bit more information to be able to normalize this. I would think you have 4 tables maybe?...

pmadhavapeddi22 (1/21/2014)

---

sean,

The requirement is for hierarchy records. (child and parent records, for that I am passing the child id as parameter). I could create table valued function for the same...

I would import this into a staging table and then parse it out into properly normalized tables.

You have been around here long enough to know that what you posted is not enough information. What do you mean by pass a variable to a cte? A cte...

In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form of INSERT INTO statements

3. Expected results...

What does that mean? You seem to be very rich in needing help but very...

Thanks for the inserts. We are now almost a week into this problem and we have ddl and sample data. I know Dwain asked this already but what do you...

What do you mean how do you check the errorlog from CMD? I assume you mean using a command line but what are trying...

I would also recommend one of the free search tools but for this type of sql is fun to write so I provide this.

declare @sql nvarchar(max) = ''

declare @TableName sysname...

A recursive scalar is about the...

Eight (1/20/2014)

---

Hello,

I have to update a string in a column with a specific number for each occurrence of the number in the string.

Like 1 = 2, 2 = 3, 3=4...

Excellent job posting ddl and sample data.

I don't understand your desired output. Also, you have scalar functions which are horrible for performance. The one you posted the code for...