Viewing 15 posts - 1 through 15 (of 30 total)
I figured it out that's why.
Thanks
July 23, 2015 at 3:40 pm
Yes if the row has the same ID i want to Concatenate the Identifier column with the Name column
July 23, 2015 at 2:32 pm
Thanks for your Help. It worked. 🙂
April 13, 2012 at 2:01 pm
The columns are not going to be same for concert and festival tables. I cannot do a UNION.
When i run ur query i get the results in one row....
April 13, 2012 at 1:35 pm
CREATE TABLE [dbo].[UserInfo](
[ID] [int] IDENTITY(1,1) NOT NULL,
[FirstName] [varchar](max) NULL,
[LastName] [varchar](50) NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[Festival](
[Event_ID] [int] IDENTITY(1,1) NOT NULL,
[ID] [int] NULL,
[EventType] [varchar](50) NULL,
[EventLocation] [varchar](50) NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[Concert](
[Event_ID] [int]...
April 13, 2012 at 1:11 pm
My mistake parade table should be named festival.
This is the SQL
SELECT dbo.UserINfo.FirstName, dbo.Concert.EventType, dbo.Festival.EventType AS Expr1, dbo.Concert.EventLocation, dbo.Festival.EventLocation AS Expr2
FROM ...
April 13, 2012 at 12:44 pm
I had to redesign the database. I took your help for the tables. Thanks:-)
August 5, 2010 at 4:41 pm
Survey Table has the Survey. Every survey has questions attached to it(SurveyQuestions). Every questions has choices attached to it(SurveyChoices). Tables attachment file
I am trying to copy a previous survey(all of...
August 4, 2010 at 5:10 pm
This is how the data looks like before i insert the new survey automatically.
Survey
surveyid= 1 (Auto number)
title= test title
description= test title
surveystatus=1
CreatedBy=test
date= today's date
SurveyQuestions
Questionsid= 1 (autonumber)
SurveyID=1
Questions="Good Work"
AnswerType= M
Questionsid= 2 (autonumber)
SurveyID=1
Questions="bad Work"
AnswerType=...
August 4, 2010 at 1:51 pm
Thanks it worked. 🙂
August 27, 2009 at 10:11 am
How will i use in my query. kInd of confused. it is sql server 2005
June 26, 2009 at 4:46 pm
Viewing 15 posts - 1 through 15 (of 30 total)