What is it that you are converting from Text to BigInt?

Please post the query and the data that you are converting.

A String of alphabets can not be converted to BigINT.

For...

I tried the Dynamic pivot but it seems that this approach is very lengthy. Still, here is the code:

--Creating Tables

Create Table Employee

(IDint,

First varchar(max),

Last varchar(max),

ext Varchar(max),

Office Char(2)...

Did you checkout the link in my signature??....If not then please check it out to see how to post Sample Data.

It's good that you have provided DDL of the tables....

Go through the following Links. These would give you the necessary information about how to do it:

Storing and Retrieving Images from SQL Server Using Strored Procedures

How to insert\retrieve image in...

You're Welcome. I'm glad I could help. 🙂

I am guessing that you have already got the images or the path to the images stored in your Database.

In what form do you store them in your Database....as a...

The following Query should do it for you:

--Creating Tables

CREATE TABLE [dbo].[abcd](

[Aid] [int] IDENTITY(1,1) NOT NULL,

[Title] [varchar](50) NULL

)

CREATE TABLE [dbo].[efg](

[Fid] [int] IDENTITY(1,1) NOT NULL,

[Aid] [int] NULL,

[Title] [varchar](50) NULL

)

--Inserting Sample Data

insert into...

+1.

After listening to all your requirements even...

Welcome To SSC.

You need to provide DDL of the tables, some sample Data and the Expected Result Set so that people can have a look at what you are looking...

And where is the Image going to be displayed??.....Don't you need a page for that??...

A few things:

1. Please test your DDL and Sample Data Scripts before you post it. Its not that hard to do it. Its as simple as CTRL C + CTRL...

Anatoly Ukhvanov (6/11/2012)

---

I'm not a pro in this area, but as I understand, «Min(Group_Name)» — isn't a the rigth rule that correctly determines which group corresponds to the style. As I...

Your Sample Data seems inconsistent. Why are there two entries of the same person(Kate Smith) in your table, which completely changes the relationship of the PrimaryId on the MemberId completely...

Is this what you are looking for?

--Creating Tables

CREATE TABLE zzxstylr

(division char(3) PRIMARY KEY,

style char(12),

group_code1 char(9),

group_code2 char(9),

group_code3 char(9),

group_code4 char(9),

group_code6 char(9),

group_code7 char(9),

group_code8 char(9) )

...

I gave you this solution in your other thread as well.

--Creating Table

Create Table Ex

(Name varchar(20),

MemberID int,

PrimaryID int,

Expiration Date )

--Inserting Sample Data

Insert Into Ex

Select 'Mary Smith', ...