Re: Customize color coding in SQL editor window - Database Discussion Boards

Mycroft Holmes15-Jan-13 22:57

15-Jan-13 22:57

What database are you using, [?] as a parameter looks like Access, the code looks like TSQL and you are mixing the parameter types. A TSQL parameter would be @Date

Never underestimate the power of human stupidity
RAH

Re: Totals of each transaction type

Richard.Berry10016-Jan-13 0:36

Richard.Berry100

16-Jan-13 0:36

Oops sorry - SQL Server 2008 R2 - MS Query - Excel

Seem to have got a liitle further:

This works:

SELECT user_id, SUM(CASE WHEN stkhstm.transaction_type = 'RECP' then 1 else 0 end) , 
SUM(CASE WHEN stkhstm.transaction_type = 'SRET' then 1 else 0 end)  
FROM vektron.scheme.stkhstm stkhstm
GROUP BY user_id

Then I tried to add a restriction on the dates:

SELECT user_id, SUM(CASE WHEN stkhstm.transaction_type = 'RECP' then 1 else 0 end) * 
SUM(CASE WHEN stkhstm.movement_date > #01/01/2012# then 1 else 0 end) * sum(CASE WHEN stkhstm.movement_date < #01/01/2013# then 1 else 0 end), 
SUM(CASE WHEN stkhstm.transaction_type = 'SRET' then 1 else 0 end)  
FROM vektron.scheme.stkhstm stkhstm
GROUP BY user_id

But get the same error as before

Re: Totals of each transaction type

PIEBALDconsult16-Jan-13 3:42

PIEBALDconsult

16-Jan-13 3:42

As to the dates, you probably want to use BETWEEN -- I do hope you are storing dates as DATE or DATETIME, not strings.

If you execute your command in SSMS, what line does it tell you the error is on?

Re: Totals of each transaction type

Richard.Berry10016-Jan-13 5:36

Richard.Berry100

16-Jan-13 5:36

Thanks PIEBALDconsult

The problem was amongst other things the dates !!

This works now:

SELECT user_id, 
SUM(CASE WHEN (stkhstm.transaction_type = 'RECP' AND stkhstm.movement_date >= {ts '2012-01-01 00:00:00'} AND stkhstm.movement_date < {ts '2013-01-01 00:00:00'})  then 1 else 0 end)  , 
SUM(CASE WHEN (stkhstm.transaction_type = 'SRET' AND stkhstm.movement_date >= {ts '2012-01-01 00:00:00'} AND stkhstm.movement_date < {ts '2013-01-01 00:00:00'}) then 1 else 0 end)  
FROM vektron.scheme.stkhstm stkhstm
GROUP BY user_id

'BETWEEN' would be a bit more elegant I guess Smile | :)

Customize color coding in SQL editor window

biop.codeproject15-Jan-13 20:04

biop.codeproject

15-Jan-13 20:04

I just wonder is there a visual guide in customizing the color coding.

Problem I face with is that I need to change the color for column name. I have tried changing many items, but with no luck.

modified 23-Jan-13 3:27am.

Re: Customize color coding in SQL editor window

Mycroft Holmes15-Jan-13 22:51

Mycroft Holmes

15-Jan-13 22:51

You can change the colours in options => text editor. Make sure you save and backup the setting if you customise it, losing them is a bitch!

Never underestimate the power of human stupidity
RAH

Message Closed

16-Jan-13 19:26

biop.codeproject

16-Jan-13 19:26

Message Closed

Re: Customize color coding in SQL editor window

Mycroft Holmes16-Jan-13 19:34

Mycroft Holmes

16-Jan-13 19:34

Sure I read your question, I just was not interested in spoon feeding you like a baby. I did point out where to look for the change, now you need to do what the rest of us did and rat through the configurations and find out what you need change to get the effect you want!

Had there been a more relevant answer posted I would not have had to help at all, I gave you the pointer to where to find make the changes because there was no better help offered!

Never underestimate the power of human stupidity
RAH

Re: Customize color coding in SQL editor window

Shameel22-Jan-13 4:41

Shameel

22-Jan-13 4:41

Thanks God you didn't expect anyone here to remote connect to your computer and change the colors for you.

query..

vishal.v.patil14-Jan-13 17:49

vishal.v.patil

14-Jan-13 17:49

i want the SQL query for getting single column from two different tables column....

i have two tables...vendor and labour, In that Vendor_Name and Labour_name columns..

i want all names in one single column...

Thnks....

Vishal V Patil
(M. C. A.)

Re: query..

Mycroft Holmes14-Jan-13 17:54

Mycroft Holmes

14-Jan-13 17:54

Do some reading around the UNION keyword.

SQL

Select Vendor_Name from Vendor
UNION
Select Labour_Name from Labour

Never underestimate the power of human stupidity
RAH

Re: query..

vishal.v.patil14-Jan-13 18:21

vishal.v.patil

14-Jan-13 18:21

Thnks for rply....but, It will show last two records from both two tables....

Vishal V Patil
(M. C. A.)

Re: query..

Blue_Boy15-Jan-13 3:11

Blue_Boy

15-Jan-13 3:11

SQL

select * from vendor where id in (select top 2 id from vendor order by id desc)
union all
select * from labour where id in (select top 2 id from labour order by id desc)

I Love T-SQL
"VB.NET is developed with C#.NET"
If my post helps you kindly save my time by voting my post.

Building dictionary translation

Y@ssco14-Jan-13 16:19

Y@ssco

14-Jan-13 16:19

Hi friends,
I have a requirements to build a data base with bilingual dictionary. Upto certin limit i found many threads on how to structure the DB table. But from where i can get the dictionary itself? I need The raw material (in excell or xml) to fill the DB. Any one can help with this?
Thanks.

Re: Building dictionary translation

Mycroft Holmes14-Jan-13 17:52

Mycroft Holmes

14-Jan-13 17:52

A simple goggle [^]search seems to indicate there are plenty of sources out there!

Never underestimate the power of human stupidity
RAH

Re: Building dictionary translation

Y@ssco14-Jan-13 18:41

Y@ssco

14-Jan-13 18:41

Thanks RAH for your reply, I guess i was not clear maybe in my previous question, I have few sources for the English dictionary, and other languages. But what I want to build is a kind of Offline Translator:

- Language 1 --> Stored in DB.
- Language 2 --> Stored in DB.
- Language 3 --> .....

And as am typing a word in my application it will search for the translation in the DB.

The challenge no is From where i can get the source of the Bilingual Dictionary for example (English - Spain) in xml or excell.

any advice?!

Re: Building dictionary translation

Mycroft Holmes14-Jan-13 18:52

Mycroft Holmes

14-Jan-13 18:52

Ah I see, not going to be able to help, the few times I have done multi lingual apps I have forced the client to supply the translations, publicly available info was inadequate to the requirements especially when dealing with a technical subject.

Never underestimate the power of human stupidity
RAH

Re: Building dictionary translation

Corporal Agarn15-Jan-13 1:51

Corporal Agarn

15-Jan-13 1:51

You may be able to purchase such a thing. Be careful of downloading information for copy-write laws.

Re: Building dictionary translation

Y@ssco15-Jan-13 18:23

Y@ssco

15-Jan-13 18:23

I Totally Agree, but really am not yet able to find any company I can purchase from them the files. It is really hard Frown | :(

Re: Building dictionary translation

Eddy Vluggen16-Jan-13 2:41

Eddy Vluggen

16-Jan-13 2:41

Y@ssco wrote:
But from where i can get the dictionary itself?

http://www.freedict.org/nl/[^], or search for the Ergane-database. IIRC, it's a (free) MS-Access database which uses the Esperanto-language as intermediate to go from one language to another.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]
They hate us for our freedom![^]

embedding sql server express in application

Danzy8313-Jan-13 16:48

Danzy83

13-Jan-13 16:48

Hi all! Is it possible to embed sql server express in an application without installing it like it is in mysql and sqlite3? I would like to link my application to a static or dynamic library if Microsoft makes that provision so that I will not install the server on the user machine.

I tried to do this using mysql but for three days now I have not been able to initialize the server as library initialization fails. SQLite3 makes that provision but does not encrypt the data. I don't know if it is possible with Microsoft SQL server. I will be writing the application in C++. Thanks in advance.

Re: embedding sql server express in application

PIEBALDconsult13-Jan-13 17:02

PIEBALDconsult

13-Jan-13 17:02

No, even Express has to be installed.

You might want SQL Server CE http://www.microsoft.com/en-us/download/details.aspx?id=17876[^]

Or possibly SQL Server LocalDB http://msdn.microsoft.com/en-us/library/hh510202.aspx[^]

Re: embedding sql server express in application

Eddy Vluggen14-Jan-13 2:07

Eddy Vluggen

14-Jan-13 2:07

Danzy83 wrote:
SQLite3 makes that provision but does not encrypt the data.

It does[^];

Encryption Support
The entire database file can be encrypted. Binary and cleartext passwords are supported.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]
They hate us for our freedom![^]

SQL Query For String Searching

lhsunshine10-Jan-13 3:35

lhsunshine

10-Jan-13 3:35

My case is
Input is "abdknmgbm".
BUT
The record in database that i want to query out is "abkdnmgmb"
The input and database record is quite similar.
String length is same, only some arrangement of character are not same.
In the above case, dk and kd ; bm and mb.
How i write query for this string searching?
Help and Thanks.

Re: SQL Query For String Searching

Corporal Agarn10-Jan-13 4:40

Corporal Agarn

10-Jan-13 4:40

If you are using SQL server try SOUNDEX. Do not know if it will work though.

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