Viewing 15 posts - 5,896 through 5,910 (of 15,381 total)
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...
January 21, 2014 at 10:10 am
pmadhavapeddi22 (1/21/2014)
thanks prasad, i tried with parameterized view but again my value is dynamic, so still trying to get some solution 🙂
Given the ridiculous limitations of no procs or...
January 21, 2014 at 8:51 am
Michael Smith-356657 (1/21/2014)
January 21, 2014 at 8:47 am
kalyan.ch (1/21/2014)
I agree.The normalised table design is what am looking for.
Need quite a bit more information to be able to normalize this. I would think you have 4 tables maybe?...
January 21, 2014 at 8:44 am
pmadhavapeddi22 (1/21/2014)
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...
January 21, 2014 at 8:36 am
I would import this into a staging table and then parse it out into properly normalized tables.
January 21, 2014 at 7:59 am
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...
January 21, 2014 at 7:57 am
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...
January 21, 2014 at 7:53 am
raghuldrag (1/21/2014)
Hi friends,as the same table how to separate lowest value only.
What does that mean? You seem to be very rich in needing help but very...
January 21, 2014 at 7:43 am
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...
January 21, 2014 at 7:22 am
rajeshjaiswalraj (1/20/2014)
How to check errorlog from CMD.
What do you mean how do you check the errorlog from CMD? I assume you mean using a command line but what are trying...
January 20, 2014 at 1:44 pm
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...
January 20, 2014 at 10:21 am
Shanmuga Raj (1/20/2014)
Sorry,I was not able to find the soultion with the above cte code and i need to use recusive function for the same.
A recursive scalar is about the...
January 20, 2014 at 10:01 am
Eight (1/20/2014)
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...
January 20, 2014 at 8:40 am
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...
January 20, 2014 at 8:09 am
Viewing 15 posts - 5,896 through 5,910 (of 15,381 total)