Re: SQL SERVER 2005 /Database/Resize - Database Discussion Boards

Re: Dirrerence Between these Two Queries

Jason Lepack (LeppyR64)20-Nov-07 4:27

Jason Lepack (LeppyR64)

20-Nov-07 4:27

Oh, sorry. I misunderstood your question.

This should do what you want then:

SELECT<br />
	A.PROPERTY_KEY - B.[UNITS IN PRO-V]<br />
FROM<br />
	(SELECT<br />
		COUNT(DISTINCT PROPERTY_KEY) PROPERTY_KEY<br />
	FROM<br />
		sde.VW_Toi_Deeds_Vuyiswa<br />
	WHERE<br />
		FUNCTION_KEY like '%GEOSS%') A,<br />
	(SELECT<br />
		COUNT(*) AS [UNITS IN PRO-V]<br />
	FROM<br />
		SDE.PROPERTY<br />
	WHERE<br />
		FUNC_KEY LIKE 'GEOSS%') B

Re: Dirrerence Between these Two Queries

Vimalsoft(Pty) Ltd20-Nov-07 20:27

Vimalsoft(Pty) Ltd

20-Nov-07 20:27

Thanks man it worked Perfectly

Thanks

Vuyiswa Maseko,

Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding

VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za

Re: Dirrerence Between these Two Queries

Vimalsoft(Pty) Ltd20-Nov-07 21:06

Vimalsoft(Pty) Ltd

20-Nov-07 21:06

Hi Leppyr64

i have to Display records not Count, how do i archive this. in the Above Query that you gave me.

SELECT
A.PROPERTY_KEY - B.[UNITS IN PRO-V]
FROM
(SELECT
COUNT(DISTINCT PROPERTY_KEY) PROPERTY_KEY
FROM
sde.VW_Toi_Deeds_Vuyiswa
WHERE
FUNCTION_KEY like '%GEOSS%') A,
(SELECT
COUNT(*) AS [UNITS IN PRO-V]
FROM
SDE.PROPERTY
WHERE
FUNC_KEY LIKE 'GEOSS%') B

Thanks

Re: Dirrerence Between these Two Queries

Jason Lepack (LeppyR64)21-Nov-07 2:33

Jason Lepack (LeppyR64)

21-Nov-07 2:33

I don't understand what you want.

You asked for the difference between two queries that returned a number.

A - B = C

If what I gave you is not what you want then I need an example. I'm done guessing.

Please post DDL, Example Data, and Expected results.

Re: Dirrerence Between these Two Queries

Vimalsoft(Pty) Ltd21-Nov-07 3:46

Vimalsoft(Pty) Ltd

21-Nov-07 3:46

Am Sorry,

Thanks.

TDS buffer length too large

amhase_codeProject20-Nov-07 2:55

amhase_codeProject

20-Nov-07 2:55

I am getting error while fetching the data from sybase to SQL

TDS buffer length too large- oledb driver

Thanks & Regards

Avinash Mhase
Application Development
ZENTA

SQL SERVER 2005 /Database/Resize

gandalf_le_blanc20-Nov-07 2:41

gandalf_le_blanc

20-Nov-07 2:41

Hi,

The actual size of my database isn't enought, autogrow is activate and I can change the parameters but I want to increase from 6Go to 50Go. Do you know if there is a command or a procedure to resize the size of the database without to recreate a database.

Best regards

-- modified at 9:05 Tuesday 20th November, 2007

Re: SQL SERVER 2005 /Database/Resize

Kishore.P21-Nov-07 0:41

Kishore.P

21-Nov-07 0:41

Using enterprise manager you can change the database file grow size or use ALTER DATABASE command.

see SQL Server 2005 BOL.

Help me in Cryastal Report in Visual Studio 2005 using Dataset Method

Mujahid Awan Sindhi20-Nov-07 2:24

Mujahid Awan Sindhi

20-Nov-07 2:24

Hi:

I Mujahid Hussain Awan,I am a software Developer,I have a problem in Crystal Report.First I was working in
Visual Studio 2003(C#).I built many crystal reports using DataSet method,and the Procedure was so simple.First I add
Dataset and then add new element and give all it's attributes,and Datatype of all these attribute.then In Frontend at C#
I add new crystal report then I select Blank Report,then I open Field xplorer Window right Click on Database Fields
then I select Database Expert,a Database window Express Opens then I select Project Data and then I select ADO.net
DataSet a Dataset with the same I created above apears,then I open it and Drag & Drop each Fields in Crystal Report's
Detail Section.and then I Open a Form I initialize Dataset and Crystal report and write quer in Adapter then I Fill
DataSet and set DataSorce Property of Report Object.and set ReportSource property of Crystal report Viewer and run
Project and Record displays in Crystal Report. This is the Procedure of Crystal Report in Visual Studio 2003.
But When I do all these in Visual Studio with same Procedure but no Record Displays in Crystal Report.Can any body
Help me How can I do all this in Visual Studio 2005.

Mujahid Awan

@@ parameters in sql server 2000 stored procedure

Sonia Gupta20-Nov-07 1:34

Sonia Gupta

20-Nov-07 1:34

so far i studied @@error and @@fetch_status , i know their utility.
But i don;t know what's the basic difference between @ and @@ parameters?

Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.

Re: @@ parameters in sql server 2000 stored procedure

Pete O'Hanlon20-Nov-07 1:59

Pete O'Hanlon

20-Nov-07 1:59

Sonia - you've been told this one before. @@ parameters are reserved system parameters. You can supply your own @ parameters.

Deja View - the feeling that you've seen this post before.

My blog | My articles

Re: @@ parameters in sql server 2000 stored procedure

Sonia Gupta20-Nov-07 2:09

Sonia Gupta

20-Nov-07 2:09

ThanQ Pete Smile | :)

Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.

how to see source file of system function

nibabug20-Nov-07 1:03

nibabug

20-Nov-07 1:03

like avg(),sum(),and so on
i would like to see the source files
where exist these files?
thanks a lot Big Grin | :-D

wuhuaiji

Re: how to see source file of system function

Pete O'Hanlon20-Nov-07 11:01

Pete O'Hanlon

20-Nov-07 11:01

nibabug wrote:
like avg(),sum(),and so on
i would like to see the source files
where exist these files?

Assuming you are using SQL Server, these files are part of the sourcecode so if you don't work for Microsoft then chances are you aren't going to have access to them. These functions are part of the SQL standard, not stored procedures.

Deja View - the feeling that you've seen this post before.

My blog | My articles

a problem about datatype

nibabug20-Nov-07 0:54

nibabug

20-Nov-07 0:54

hello everyone Smile | :)

i define a datatype float, but when i write a value, for exsample '1.123',to the table, then i find that the value in the table changed to '1.123999999999999', what's the problem?

thanks a lot Big Grin | :-D

wuhuaiji

Re: a problem about datatype

N a v a n e e t h20-Nov-07 1:00

N a v a n e e t h

20-Nov-07 1:00

By default float size will be 8. Try reducing it

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

Re: a problem about datatype

nibabug20-Nov-07 1:06

nibabug

20-Nov-07 1:06

thanks ,
but it can not be reduced

wuhuaiji

Re: a problem about datatype

N a v a n e e t h20-Nov-07 2:36

N a v a n e e t h

20-Nov-07 2:36

nibabug wrote:
but it can not be reduced

I guess you tried through enterprise manager right ? Try through query analyzer, you can change it.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

Re: a problem about datatype

Marek Grzenkowicz20-Nov-07 2:19

Marek Grzenkowicz

20-Nov-07 2:19

Read about floating-point[^] and then use decimal and numeric data type.

how to write and use my function

nibabug20-Nov-07 0:48

nibabug

20-Nov-07 0:48

i have a problem, that i want to write a function like avg(),count().....

but the parameter i want to pass to the function is a row-name,

for exsample:
i have a table, which includes 1000 values of temperature, i want to calculate the variance of all the 1000 values.

wuhuaiji

Re: how to write and use my function

Marek Grzenkowicz20-Nov-07 2:13

Marek Grzenkowicz

20-Nov-07 2:13

I think this[^] should be helpful.

extrem large insert query

baerten19-Nov-07 21:56

baerten

19-Nov-07 21:56

Hi everybody,

i save eMails into a table. Easy.
A BLOB Field saves the whole mail including attachments into MIME Format.

Now the problem ... a 5MB JPG-File Sigh | :sigh:

So i have a 5MB INSERT Query D'Oh! | :doh:

I changed already the max_allowed_packet=10M but the connection breaks down each times.

Some programmers sayed me that's possible to add a such query...

Such a huge mail is an exception, normally all mails which should be added
have a size of some KB...

Is it possible to add a 5MB single INSERT query? If yes, how?

Big thanks Smile | :)

Re: extrem large insert query

baerten20-Nov-07 0:14

baerten

20-Nov-07 0:14

max_allowed_packet was not saved Sniff | :^)

I changed his value in MySQL Administrator, then via set max_allowed_packet = 10000000; in a SQL-Query
and in the .ini File.

After re-changing these values, it worked D'Oh! | :doh:

Now i can add those huge inserts easily Roll eyes | :rolleyes:

Temporary tables and performance

N a v a n e e t h19-Nov-07 20:43

N a v a n e e t h

19-Nov-07 20:43

Will you recommend the usage of temporary tables in a SQL server database ? AFAIK, it boosts the performance. But recently I read one article in SQL Server performance.com[^] which confused me. Any insights on this would be helpful ?

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

Re: Temporary tables and performance

GuyThiebaut19-Nov-07 22:42

GuyThiebaut

19-Nov-07 22:42

I have also read that temporary tables can slow performance.

In my experience however - if you do not go overboard in terms of how many rows you load into a temporary table you should not notice any performance issues.

IMHO from a programming side it is always more beautiful to use joins than lots of temporary tables - if you can manage without temporary tables.

You always pass failure on the way to success.

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