Click here to Skip to main content
15,920,030 members
Home / Discussions / Database
   

Database

 
AnswerRe: Could anyone recommend an interactive application for mass data analysis? Pin
Eddy Vluggen25-May-12 0:04
professionalEddy Vluggen25-May-12 0:04 
GeneralRe: Could anyone recommend an interactive application for mass data analysis? Pin
bestbird778827-May-12 23:16
bestbird778827-May-12 23:16 
AnswerRe: Could anyone recommend an interactive application for mass data analysis? Pin
Eddy Vluggen28-May-12 1:25
professionalEddy Vluggen28-May-12 1:25 
AnswerRe: Could anyone recommend an interactive application for mass data analysis? Pin
jschell24-May-12 8:44
jschell24-May-12 8:44 
GeneralRe: Could anyone recommend an interactive application for mass data analysis? Pin
bestbird778824-May-12 17:14
bestbird778824-May-12 17:14 
AnswerRe: Could anyone recommend an interactive application for mass data analysis? Pin
Jörgen Andersson26-May-12 9:43
professionalJörgen Andersson26-May-12 9:43 
GeneralRe: Could anyone recommend an interactive application for mass data analysis? Pin
bestbird778827-May-12 23:24
bestbird778827-May-12 23:24 
QuestionConversion failed when converting the varchar value in SQLSERVER 2008 Pin
ChandrakanthGaddam22-May-12 5:47
ChandrakanthGaddam22-May-12 5:47 
Hi this is Chandra. i have one issue with Sql Stored procedure.

Please find the query below.

declare @Measure varchar(50)
declare @Time varchar(50)
declare @Manufacturer varchar(50)
declare @CategoryID int


SET @Measure ='Value'
SET @Time ='4 Weeks&'
SET @Manufacturer ='Jti Gallaher Ltd'
SET @CategoryID = 377;


Declare @SELECTtQuery1 varchar(1000)
Declare @FromQuery1 varchar(1000)
Declare @GROUPBYQuery1 varchar(1000)
Declare @SQLQuery AS NVarchar(4000)
Declare @ParamDefinition AS NVarchar(2000)

SET @FromQuery1 = 'FROM [dbo].[iView_Data_TCG_Aggregated_Product]
WHERE PeriodName = '''+@Time+'''
AND Manufacturer = '''+@Manufacturer+''' AND CategoryId = '''+ @CategoryID+

print @FromQuery1

When i execute this query i am getting the conversion error. PLease find the error below.

----------------------

Conversion failed when converting the varchar value ' FROM [dbo].[iView_Data_TCG_Aggregated_Product]
WHERE PeriodName = '4 Weeks'
AND Manufacturer = 'Test1' AND CategoryId = '' to data type int.

----------------------------------------------

I am not getting categoryid value when i execute. It is giving error.

Please suggest me wht to do.

Thanks
Chandrakanth
AnswerRe: Conversion failed when converting the varchar value in SQLSERVER 2008 Pin
scottgp22-May-12 6:02
professionalscottgp22-May-12 6:02 
GeneralRe: Conversion failed when converting the varchar value in SQLSERVER 2008 Pin
ChandrakanthGaddam22-May-12 6:20
ChandrakanthGaddam22-May-12 6:20 
QuestionHandling big tables Pin
V.21-May-12 23:28
professionalV.21-May-12 23:28 
AnswerRe: Handling big tables Pin
Mycroft Holmes21-May-12 23:56
professionalMycroft Holmes21-May-12 23:56 
GeneralRe: Handling big tables Pin
V.22-May-12 0:01
professionalV.22-May-12 0:01 
GeneralRe: Handling big tables Pin
Mycroft Holmes22-May-12 14:15
professionalMycroft Holmes22-May-12 14:15 
GeneralRe: Handling big tables Pin
R. Giskard Reventlov22-May-12 6:26
R. Giskard Reventlov22-May-12 6:26 
AnswerRe: Handling big tables Pin
Eddy Vluggen22-May-12 9:32
professionalEddy Vluggen22-May-12 9:32 
AnswerRe: Handling big tables Pin
jschell23-May-12 10:46
jschell23-May-12 10:46 
GeneralRe: Handling big tables Pin
V.23-May-12 20:45
professionalV.23-May-12 20:45 
Questionerd concepts Pin
mido_h_8921-May-12 22:34
mido_h_8921-May-12 22:34 
AnswerRe: erd concepts Pin
Mycroft Holmes21-May-12 23:53
professionalMycroft Holmes21-May-12 23:53 
QuestionError while declaring a cursor Pin
VC_RYK21-May-12 19:16
VC_RYK21-May-12 19:16 
AnswerRe: Error while declaring a cursor Pin
R. Giskard Reventlov22-May-12 6:23
R. Giskard Reventlov22-May-12 6:23 
QuestionHow to get delete/Update row + SQL Pin
jojoba201118-May-12 22:00
jojoba201118-May-12 22:00 
AnswerRe: How to get delete/Update row + SQL Pin
Eddy Vluggen19-May-12 0:42
professionalEddy Vluggen19-May-12 0:42 
QuestionRe: How to get delete/Update row + SQL Pin
jojoba201119-May-12 4:38
jojoba201119-May-12 4:38 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.