Multilingage/multi Charset (latin/greek...) In 1 DB ?

Nov 12, 2004

Is it possible to have in the same MsSQLServer database several languages:

French, english, german, spanish... (latin langages)
but also langages with different characterset (greek, cyrilic...)

What should be the type of data (char ou nchar(unicode)) ?
what should be the colation ?

Thanks

View 2 Replies


ADVERTISEMENT

Is There One Collation That Includes All The Eastern Europen Languages And Latin 1 Charset.

Jul 13, 2006

Can I specify a collate value for a column in a table that includes all the possible languages in the world or atleast Latin 1 and Eastern European languages.

My DB Collation is set to Latin 1 and the columns in the tables are all nvarchar or ntext, but certain hungarian characters are not displayed correctly.

What do all these collation codes represent:







SQL_EBCDIC037_CP1_CS_AS



211


SQL_EBCDIC273_CP1_CS_AS



212


SQL_EBCDIC277_CP1_CS_AS



213


SQL_EBCDIC278_CP1_CS_AS



214


SQL_EBCDIC280_CP1_CS_AS



215


SQL_EBCDIC284_CP1_CS_AS



216


SQL_EBCDIC285_CP1_CS_AS



217


SQL_EBCDIC297_CP1_CS_AS

They seem generic. Is there one collation that includes all the Eastern Europen Languages and Latin 1 charset. Please let me know.

Thanks,

Manisha

View 6 Replies View Related

Greek Characters Problem

Nov 28, 2007

Hi,

I have a sql db with a table in which I store Greek text. I have changed the collation name of the columns which keep the Greek to "Greek_AI_AS" and the datatype of these columns are nvarchar or ntext.

However whenever I tried to add text from a web form the Greek characters does not show correctly and I get "?????".

The collation name of the sql db is Latin1_Generala_CP1_CI_AS. Do u think there is a collation conflict or the column collation overides the db one? Or there is something else which I don't know?

P.S. I have set the correct Codepage and response.CharSet for Greek language.

Any ideas would by valuable.
Thanks

Dimos

www.tabletennis.gr

View 3 Replies View Related

Greek Characters Problem

Jan 22, 2008

Dear All Hi,

I have installed MS SQL Server 2005 on Windows Server 2003 (regional settings . Server collation is Greek_CI_AS and database collation is Greek_CI_AS. I am using an external application which stores data to this database and I am able to write Greek characters in a field but after i save the record this text is transformed to many ???????. What could be the problem? Thanks in advance

View 4 Replies View Related

Greek Alphabet Ordering

Jul 20, 2005

Got a tough one here for you SQL junkies.I'm working on a website (in ASP) for a national greek/collegeorganization. All it's college chapters have greek chapter names,i.e. Alpha Chapter, Delta Chapter, Delta Iota Chapter, Gamma PhiChapter, ect. ect.I need the SQL to return the chapters in greek alphabet ordering. Seebelow:1. Alpha2. Beta3. Gamma4. Delta5. Epsilon6. Zeta7. Eta8. Theta9. Iota10. Kappa11. Lambda12. Mu13. Nu14. Xi15. Omicron16. Pi17. Rho18. Sigma19. Tau20. Upsilon21. Phi22. Chi23. Psi24. OmegaBasically I need a way to specify this type of presedence for wordingand keep all the results in greek-letter order, so Sigma Upsilon comesbefore Sigma Tau, and so on.Also, to make it even more difficult, these are written words, not theactual greek symbols like α β etc. Everything is stored inthe DB as Alpha Beta Whateva Chapter.Hopefully some of you SQL junkies will be able to help on this one ;)

View 2 Replies View Related

CharSet On Db

Mar 19, 2008

How can I find out what is current character set on all my 300+ databases on one server? (2005)?

View 5 Replies View Related

BCP IN ISO-8859-1 (ISO-LATIN-1) TYPEFACE

May 25, 2006

I NEED TO BCP DATA FROM A TABLE TO BE COMPLIANT WITH THE

ISO-8859-1 (ISO-LATIN-1) TYPEFACE



IS THERE A SWITCH I CAN USE TO TAKE CARE OF THIS.

EMAD

View 1 Replies View Related

Charset Problem

Aug 22, 2005

hi i installed mssql 2000 server today but when i tried to connect it from java i got an error like this

Could not find a Java charset equivalent to DB charset iso_1

i asked it within java forums and they said its because of charset settings of database server so i want to ask you how to change my database charset settings?
Thanks

View 1 Replies View Related

Wrong Greek Characters On Windows 2000

Dec 17, 2007

Hi there,I have a strange problem with an application running on Windows 2000connecting to a SQL Server 2000 with Greek collation.Runnin this query on the SQL"SELECT serverproperty('Collation'),databasepropertyex('mydb', 'Collation')"gives me:SQL_Latin1_General_CP1_CI_AS, Greek_CI_AIWhen I run my application on my Windows XP machine I have no problemswith the characters however when I try the same applicaton on aWindows 2000 platform the Greek characters are lost. For example theGreek characters TI appear as OE.Any help is appreciated,regardsBOB

View 2 Replies View Related

SQL Server 2012 :: Removing Greek Characters From A String

Sep 17, 2015

I have a varchar field which contains some Greek characters (α, β, γ, etc...) among the regular Latin characters. I need to replace these characters with a word (alpha, beta, gamma etc...). When I try to do this, I find that it is also replacing some of the Latin characters.

DECLARE @Letters TABLE (Letter NVARCHAR(10))
INSERT INTO @Letters VALUES ('a'), ('A'), ('b'), ('B'), ('α')
SELECTLetter, REPLACE(Letter,'α','alpha')
FROM@Letters

In this case, the "α" is being replaced, but so are "a" and "A".

I have tried changing the datatype from varchar to nvarchar and also changing the collation.

View 4 Replies View Related

Unable To Retrieve Data When Using Greek Characters In Statement

Apr 26, 2007

Hi,I'm trying to do retrieve some data from a table where the content isin Greek, however, thequery is not working. It's a very simple statement, but I'm missingsomething.Here is the table...if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[REPORT_LOCALE]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[REPORT_LOCALE]GOCREATE TABLE [dbo].[REPORT_LOCALE] ([XL_REPORT_ID] [int] NULL ,[TEXT_NAME] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_ASNULL ,[LOCALE] [int] NULL) ON [PRIMARY]GOThe first statment shows me a number of rows. I copied the content ofthe Text_Name column and pasteit into QA to form the second statement. However, the second statementreturns no data.SELECT * FROM Report_LocaleSELECT * FROM Report_Locale WHERE Text_Name = 'Λογ.Διαχ. – ΤÏ?.-Î*Ï?ουπ.-Διαφ.'Hopefully the Greek characters will display properly within this post,but the idea is basically to take the Greek text and build that into aquery. I can do the remainder later once I understand why this doesnot work as I expect. I realise my expectation is based on doingthings in English so I need to understand the differences. We've donethis for various other languages using other character sets, which iswhy I am puzzled.Any pointers ?ThanksRyan

View 1 Replies View Related

Unwanted Conversion Of Non Latin ASCII Characters

Oct 27, 2006

hi

we get ASCII data inserted into a SQL Server database by ODBC connection from an old UNIX system.

Example: INSERT INTO test.db VALUES ('123abc', '456ПРО')

All characters > 128 are converted to "?" automatically.

We tried to setup the database to the appropriate codepage, but we allways get "?" inserted.



View 2 Replies View Related

Euro Symbol, Charset 850 And Unicode

May 8, 2001

Dear experts,

I'm having a problem with the Euro symbol on my SQLServers which all have characterset 850 and Unicode collation 1033. As far as I can see charset 850 does not contain the € symbol, but if I run a query

DECLARE @nstring nchar(12)
SET @nstring = N'€'
SELECT UNICODE(@nstring), NCHAR(UNICODE(@nstring))

Result: 8364 €

So the Unicode character 8364 is the Euro symbol. My question now is how do I have to write a statement so that the € symbol is shown in the output.
I need to use something like the following:
Select 'Costs:'+ € + convert(money, table1.costs)
Result: € 123.00


I tried several options but never get the right output. Is there any way of doing it or do I have to change the characterset.

Markus

View 1 Replies View Related

MSSQL With Different Charsets, Cyrrilic(macedonian), Latin(Swedish)....

Jan 2, 2008

Hi!
What kind off settings do I use if Iam gone have diffrent languages on the databse?? What kind of collections settings do I use then If Iam going to have macedonia(Cyrillic),  Swedish, and lots of other contries???
What kind of collection Seetings do I use under the installation of the MSSQL Server 2005?
 

View 3 Replies View Related

Ignore Latin And Other Foreign Characters In Text Search.

Apr 22, 2008

Hi, i have a query that goes like this


select *
from Users
where UserName Like =@Username;

the values for 'UserName' go like this

Adrián
Jesús
Fernández
Güero

all of them have spanish accents. is there a way to make the "like" value to ignore the spanish characters? (á, é, í, ó, ú, ü, etc)

That is because the user will not always write "Jesús" they will write "Jesus" or they will not write "Adrián" they will write "Adrian"

so is there any way to tell the SQL Server engine to ignore those characters?

thanks!!!

View 5 Replies View Related

Which Charset For Nvarchar Field In SQL 2005 Database?

Sep 26, 2006

Which charset for nvarchar field in SQL 2005 database? UTF-8, UTF-16...Does normal character such as A, B, C use double-byte in nvarchar field?

View 4 Replies View Related

Default Charset In Sqlserver 2000? / Jtds

Nov 2, 2005

Hi,I am writing to a text column in my SQL Server 2000 database. The textcomes from a web form in my java web application, where the characterencoding is ISO-8859-1. (I have no control over the charset, my app isa plugin inside another app.)Characters such as €(ascii 128) and '(ascii 146) are inserted intothe db as '?'.I'm connecting using the free jtds driver, and I'm not specifying anydetails about charsets in my usage of the driver.Can anyone tell me what the default charset in sqlserver 2000 is?Should I be specifying this charset when using my driver?Thanks.

View 4 Replies View Related

DB Engine :: Chinese Collation That Has Latin Case-insensitive Characters?

Aug 21, 2015

I don't quite understand what I am asking for so hopefully this is enough to get an answer or some explanation.

Using SQL2014 I need to use a Chinese collation. I have been told that even with a Chinese collation Latin characters are there. Is there a Chinese collation that will provide Latin case-insensitive behavior?

View 4 Replies View Related

How To Support Multiple Language(Latin,chinese,japanese,korea) In One Report When Exporting To PDF Format

Feb 28, 2007

We should support multiple language(Latin,chinese,japanese,korea) in one report when exporting to PDF format in reporting service. We have used Arial Unicode as our font. But when we exported the report, the korean language item can not be displayed. Any idea on that? Thanks a lot.

View 3 Replies View Related

Client Found Response Content Type Of 'text/html; Charset=utf-8', But Expected 'text/xml'.

Aug 29, 2007

Hi,

I am getting these errors from Report Manager. It seems that every time after the server has been idling for about 15 minutes, I would get this error message. I can click on other links and I am able to continue to use Report Manager.

Is there a timeout setting to help me resolve this or is this a bug with Report Manager? I just insitalled SP2 on the SQL Server and the Reporting Service.

Error message on browser:

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the error message: -- <html> <head> <title> SQL Server Reporting Services </title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.3042.00" /> <meta name="HTTP Status" content="500" /> <meta name="ProductLocaleID" content="9" /> <meta name="CountryLocaleID" content="1033" /> <style> BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black} H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt} LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline} .ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray} A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR3366CC; TEXT-DECORATION:none} A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLORFF3300; TEXT-DECORATION:underline} A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR3366CC; TEXT-DECORATION:none} A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; colorFF3300; TEXT-DECORATION:underline} </style> </head><body bgcolor="white"> <h1> Reporting Services Error<hr width="100%" size="1" color="silver" /> </h1><ul> <li>An internal error occurred on the report server. See the error log for more details. (rsInternalError) <a href="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsInternalError&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.3042.00" target="_blank">Get Online Help</a></li><ul> <li>For more information about this error navigate to the report server on the local server machine, or enable remote errors</li> </ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span> </ul> </body> --.

Any ideas?
Thanks,
-waslam

View 1 Replies View Related

SQL 2012 :: Disaster Recovery Options For Multi-Database Multi-Instance Environment

Sep 23, 2014

Disaster Recovery Options based on the following criteria.

--Currently running SQL 2012 standard edition
--We have 18000 databases (same schema across databases)- majority of databases are less than 2gb-- across 64 instances approximately
--Recovery needs to happen within 1 hour (Not sure that this is realistic
-- We are building a new data center and building dr from the ground up.

What I have looked into is:

1. Transactional Replication: Too Much Data Not viable
2. AlwaysOn Availability Groups (Need enterprise) Again too many databases and would have to upgrade all instances
3. Log Shipping is a viable option and the only one I can come up with that would work right now. Might be a management nightmare but with this many databases probably all options with be a nightmare.

View 1 Replies View Related

SQL 2012 :: MSDTC In Multi-node / Multi-instanced Cluster

Aug 17, 2015

More often than not, I typically don't touch DTC on clusters anymore; however on a project where the vendor states that it's required. So a couple things here.

1) Do you really need DTC per instance or one for all?
2) Should DTC be in its own resource group or within the instance's group?
2a) If in it's own resource group, how do you tie an instance to an outside resource group? tmMappingSet right?

View 9 Replies View Related

The Multi Delete &&amp; Multi Update - Stored Procedure Not Work Ok

Feb 4, 2008

the stored procedure don't delete all the records
need help



Code Snippet
DECLARE @empid varchar(500)
set @empid ='55329429,58830803,309128726,55696314'
DELETE FROM [Table_1]
WHERE charindex(','+CONVERT(varchar,[empid])+',',','+@empid+',') > 0
UPDATE [empList]
SET StartDate = CONVERT(DATETIME, '1900-01-01 00:00:00', 102), val_ok = 0
WHERE charindex(','+CONVERT(varchar,[empid])+',',','+@empid+',') > 0
UPDATE [empList]
SET StartDate = CONVERT(DATETIME, '1900-01-01 00:00:00', 102), val_ok = 0
WHERE charindex(','+CONVERT(varchar,[empid])+',',','+@empid+',') > 0




TNX

View 2 Replies View Related

Deploying A Report Model Gives Client Found Response Content Type Of 'text/html; Charset=utf-8', But Expected 'text/xml'

Jan 22, 2008

Hi,I have setup a report model and am ready to deploy it for the first time. I have had no issues deploying my report definitions so presumably this should be alright.However, trying to deploy it gives this error:

TITLE: Microsoft Semantic Model Designer
------------------------------

A connection could not be made to the report server http://localhost/ReportServer.

------------------------------
ADDITIONAL INFORMATION:

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>
SQL Server Reporting Services
</title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.1399.00" />
<meta name="HTTP Status" content="500" />
<meta name="ProductLocaleID" content="9" />
<meta name="CountryLocaleID" content="1033" />
<meta name="StackTrace" content=" at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load()
at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Construct(String configFileName)
at Microsoft.ReportingServices.Diagnostics.RSConfiguration..ctor(String configFileName, String location)
at Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String configFileName, String configLocation)
at Microsoft.ReportingServices.Library.Global.get_ConfigurationManager()
at Microsoft.ReportingServices.WebServer.Global.StartApp()
at Microsoft.ReportingServices.WebServer.Global.Application_BeginRequest(Object sender, EventArgs e)" />
<style>
BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black}
H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline}
.ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray}
A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR3366CC; TEXT-DECORATION:none}
A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLORFF3300; TEXT-DECORATION:underline}
A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR3366CC; TEXT-DECORATION:none}
A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; colorFF3300; TEXT-DECORATION:underline}

</style>
</head><body bgcolor="white">
<h1>
Reporting Services Error<hr width="100%" size="1" color="silver" />
</h1><ul>
<li>The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) </li><ul>
<li>Access to the path 'C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServerRSReportServer.config' is denied.</li>
</ul>
</ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span>
</body>
</html>
--. (Microsoft.ReportingServices.SemanticQueryDesign)

I'd greatly appreciate any insight you could give me into fixing this problem.ThanksJohn

View 3 Replies View Related

Help With Multi Join Or Multi Tier Select.

Jul 20, 2005

Hello,I am trying to construct a query across 5 tables but primarily 3tables. Plan, Provider, ProviderLocation are the three primary tablesthe other tables are lookup tables for values the other tables.PlanID is the primary in Plan andPlanProviderProviderLocationLookups---------------------------------------------PlanIDProviderIDProviderIDLookupTypePlanNamePlanIDProviderStatusLookupKeyRegionIDLastName...LookupValue....FirstName...Given a PlanID I want all the Providers with a ProviderStatus = 0I can get the query to work just fine if there are records but what Iwant is if there are no records then I at least want one record withthe Plan information. Here is a sample of the Query:SELECT pln.PlanName, pln.PlanID, l3.LookupValue as Region,p.ProviderID, p.SSNEIN, pl.DisplayLocationOnPCP,pl.NoDisplayDate, pl.ProviderStatus, pl.InvalidDate,l1.LookupValue as ReasonMain, l2.LookupValue as ReasonSub,pl.InvalidDataFROM Plans plnINNER JOIN Lookups l3 ON l3.LookupType = 'REGN'AND pln.RegionID = l3.Lookupkeyleft outer JOIN Provider p ON pln.PlanID = p.PlanIDleft outer JOIN ProviderLocation pl ON p.ProviderID = pl.ProviderIDleft outer JOIN Lookups l1 ON l1.LookupType = 'PLRM'AND pl.ReasonMain = l1.LookupKeyleft outer JOIN Lookups l2 ON l2.LookupType = 'PLX1'AND pl.ReasonSub = l2.LookupkeyWHERE pln.PlanID = '123456789' AND pl.ProviderStatus = 0ORDER BY p.PlanID, p.ProviderID, pl.SiteLocationNumI know the problew the ProviderStatus on the Where clause is keepingany records from being returned but I'm not good enough at this toanother select.Can anybody give me some suggestions?ThanksDavid

View 5 Replies View Related

Multi-database Multi-server

Mar 27, 2007

I am new to Reporting Services and hope that what I am looking to do is within capabilities :-)



I have many identical schema databases residing on a number of data servers. These support individual clients accessing them via a web interface. What I need to be able to do is run reports across all of the databases. So the layout is:



Dataserver A

Database A1

Database A2

Database A3



Dataserver B

Database B1

Database B2



Dataserver C

Database C1

Database C2

Database C3



I would like to run a report that pulls table data from A1, A2, A3, B1, B2, C1, C2, C3



Now the actual number of servers is 7 and the number of databases is close to 1000. All servers are running SQL2005.



Is this something that Reporting Services is able to handle or do I need to look at some other solution?



Thanks,



Michael

View 5 Replies View Related

DTSRUN: To Multi-tier Or Not To Multi-tier. That Is The Question...

Jul 20, 2005

Greetings,We are trying to set up a set of "Leading Practices" for ourdevelopers, as well as ourselves, and hope some gentle reader canrecommend some documentation in favor of what appears to be the rightposition to take.We do not allow third party applications to run on our SQL Servers. Wewant to include DTS Packages under the definition of third partyapplications, insisting instead that the developers save theirpackages as COM Formatted files into their source code control systemsand run them from their app servers. The devlopers would like to hearthis from someone besides ourselves.While strong recomendations to remove guest access to MSDB altogetherabound, I have been unable to find a straight forward discussion ofthe advantages of structured file storage and app server off load ofDTS packages.Can anyone suggest any articles, white papers, rants, etc attemptingto formulate a solution to the benefits of taking msdb away fromguest, with the advantages of running DTS from an App server orworkstation platform, with the packages protected in source codecontrol?Thank youJohn Pollinsjpollins @ eqt . com

View 2 Replies View Related

SP For Multi DB

Mar 22, 2001

Is it possible to create a stored procedure that can be used on multiple dBs??

For instance, I want to create a stored procedure and use it on DB1 and DB2.
Right now, I can create a stored procedure in DB1 but only I can run it.
I want to run the stored procedures on DB2 that I created in DB1..

I hope this makes sense..
Any insight into the workings of SPs would be most appreciated...

View 3 Replies View Related

Is The Any Better Way To Do Sum For Multi Tables?

Mar 13, 2007

-- declare table declare @Table1 table(ID int, Value int )-- Insert sample data provided into tableinsert into @Table1select 1 , 2 union allselect 2 , 1 union allselect 7 , 2 -- declare table declare @Table2 table(ID int, Value int )-- Insert sample data provided into tableinsert into @Table2select 1 , 2 union allselect 5 , 1 union allselect 3 , 2 -- declare table declare @Table3 table(ID int, Value int )-- Insert sample data provided into tableinsert into @Table3select 1 , 2 union allselect 2 , 1 union allselect 3 , 2 -- declare table declare @Table4 table(ID int, Value int )-- Insert sample data provided into tableinsert into @Table4select 5 , 2 union allselect 2 , 1 union allselect 10 , 2 /*Is there anyway I can write one sql query which will give me the following result:IDs = All unique ID from all tablesSumOfAllValueFromAllTables =for the same ID, value from Table1+for the same ID, value from Table2 + so on ...IDs - SumOfAllValueFromAllTables===============================1 - 62 - 33 - 45 - 37 - 210 - 2*/--I have tried by the following way, but for more tables, it is becoming complicated, because I have 12 tables.--Is there any better way to do it? Thanks for the help.select coalesce(t1.ID,t2.ID) as IDs, coalesce(sum(t1.value),0) +coalesce(sum(t2.value),0) as SumOfAllValueFromAllTablesfrom @Table1 t1full join @Table2 t2 on t1.id=t2.idgroup by t1.ID,t2.IDorder by IDs

View 1 Replies View Related

Multi-Value Query

Jul 7, 2004

I have a search form that takes 5 inputs from textboxes or Drop Down Lists.

I built a query that works just fine in Analyizer, but the second i try to turn it into a sproc that takes parameters I can only get it to work with one parameter so far....

Here is the query that works just fine

Select ftr_location.loc_name, ftr_file.loc_id, ftr_file.file_date, ftr_file.file_type_id, ftr_file.acct_no,
ftr_file.cust_fname, ftr_file.cust_lname, ftr_status.status_name, ftr_file.destruction_date

FROM dbo.ftr_file

Inner Join ftr_location On ftr_location.loc_id = ftr_file.loc_id
Inner Join ftr_Status On ftr_status.status_id = ftr_file.status_id
Inner Join ftr_doc_types on ftr_doc_types.file_type_id = ftr_file.file_type_id

WHERE ftr_file.Loc_id = 18 and ftr_file.file_date= '12/4/2004'

GO


The sproc version that I cant get to work is:


CREATE PROCEDURE dbo.usp_ftr_searchfile_s

(
@ResultLocation int = null,
@ResultFileDate datetime = null
)

AS

DECLARE @SQLString VARCHAR(4000)

SET @SQLString = 'Select ftr_location.loc_name, ftr_file.loc_id, ftr_file.file_date, ftr_file.file_type_id, ftr_file.acct_no,'+
'ftr_file.cust_fname, ftr_file.cust_lname, ftr_status.status_name, ftr_file.destruction_date' +

' FROM dbo.ftr_file' +

' Inner Join ftr_location On ftr_location.loc_id = ftr_file.loc_id' +
' Inner Join ftr_Status On ftr_status.status_id = ftr_file.status_id' +
' Inner Join ftr_doc_types on ftr_doc_types.file_type_id = ftr_file.file_type_id' +
' WHERE 1=1 '

If @ResultLocation Is Not Null
Set @SQLString = @SQLString + 'And ftr_file.loc_id=' + cast @ResultLocation
If @ResultLocation Is Not Null
Set @SQLString = @SQLString + 'And ftr_file.file_date=' + cast @ResultFileDate


EXEC (@SQLString)
GO


Any feedback would be most helpful, as I can get it to work with one parameter but not when I add teh second in the mix.

View 1 Replies View Related

Multi-Value Parameters

Apr 12, 2005

 I have a dataadapter on my asp.net page and am having issues passing values to the sql statement.  See below:
 
SELECT tblTemp.SensorID, tblSensor.SensorNum, tblTemp.TempTime, tblTemp.TempVal FROM tblTemp
INNER JOIN tblSensor ON tblTemp.SensorID = tblSensor.SensorID
WHERE (tblTemp.TempTime BETWEEN @From AND @To)
AND (tblTemp.SensorID IN (@Sensor))
ORDER BY tblTemp.TempTime
 
@Sensor is populated in vb with the selected values from a checkboxlist control.  I attempted to test this in the "Data Adapter Preview" window, but continually get an error.  Is there a way to pass multiple values to a parameter?
Any help would be appreciated, thanks!

View 2 Replies View Related

Multi Row Update

Jan 5, 2004

Hi All,

I am trying to update a huge table with about 70 million records and the table do not have a primary key.

I want to update a "FLAG" field in the table with value 'N' default value of flag fields for all records is NULL.

I want to update the whole table in chunks say 50,000 records a time...

like
update tablename (first 50000)
set flag = 'N' where flag = NULL.

Hope I am clear..:-)

thanks
hardlyworking..

View 7 Replies View Related

Multi Threads

Jul 21, 2004

I have an app that is critical to our business. It handles and syncronises several SQL Servers, checks integrety etc. I need to make the app so it can run a few things at once. Does anyone have any experience with this? Currently we use Delphi and ADO. I have been fiddling with DMO to get more performance - I am not sure ADO is very quick for some I tasks I need to do.

I suppose my main question *really* is does ADO/DMO multi-thread and has anyone tried it. If not how do people do it?

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved