Database

PIEBALDconsult31-Jul-08 6:45

PIEBALDconsult

31-Jul-08 6:45

What does that mean?

CodalcoholicNBrainy31-Jul-08 21:20

CodalcoholicNBrainy

31-Jul-08 21:20

I mean the proces will happen every night for the data that changed during day time.

CodeManiac
xxxxxxxxxx
xxxxxxxxxx

PIEBALDconsult1-Aug-08 3:14

PIEBALDconsult

1-Aug-08 3:14

Shouldn't be a problem then.

I always try to have the database engine do most of the work.

Blue_Boy31-Jul-08 1:54

Blue_Boy

31-Jul-08 1:54

select FirstTable.*,SecondTable.*<br />
from FirstTable,SecondTable<br />
where SecondTable.FirstTableColumn in (FirstTable.FirstColumn)

I Love T-SQL
"Don't torture yourself,let the life to do it for you."

creating a pivot table

prithaa30-Jul-08 22:06

30-Jul-08 22:06

Hello,

I had posted the question before .Sorry to post it again since I thought my question went to the 2nd page.

I want to write a pivot table query and transfer the results in a table

The following query works but the result doesn't get transferred in a table

Select Cap orderby JobWorker pivot TimePeriod into CrossTabCap

Regards
Pritha

Ashfield30-Jul-08 22:18

30-Jul-08 22:18

Well that is no reason to post again. In the first place, you double posted. Then you didn't include any code, so what do you expect?

I have just done what you could have done, Goggled for SQL Server 2005 Pivot and got loads of results with example code.

Bob
Ashfield Consultants Ltd

prithaa31-Jul-08 2:35

31-Jul-08 2:35

Thank you for all your replies.

prithaa31-Jul-08 3:12

31-Jul-08 3:12

Hello,

Before posing question even I have googled on pivot query,pivot sql query but none of the sites explained the synttax abut making a new table from a pivot query .And that's the reason I asked the question .I know the pivot query but how make a table of the results from the query.
Using INTO for the pivot query didn't work.

The following query works but I want to make a table

TRANSFORM sum(cCapacity) AS SumOfCapacity
SELECT jobworker, sum(cCapacity) AS Total
FROM cCapacity
GROUP BY JObWorker
PIVOT contract into y;

Thanks and sorry.

Pritha

TheFM23431-Jul-08 7:44

TheFM234

31-Jul-08 7:44

Have you tried sub-querying the pivot?

Select *
Into Table
From
(
TRANSFORM sum(cCapacity) AS SumOfCapacity
SELECT jobworker, sum(cCapacity) AS Total
FROM cCapacity
GROUP BY JObWorker
PIVOT contract into y
) t

prithaa31-Jul-08 18:51

How to fetch data from an Excel sheet,for a particular row.?

31-Jul-08 18:51

hello,

thanks for your reply.Itried your sub-query but I get the following error

Cannot use the cross-tab of a non-fixed column as a sub-query

Pritha

guriqbal8730-Jul-08 20:39

guriqbal87

30-Jul-08 20:39

Hi,
I am working on application,which requires fetching data from an Excel sheet,for a particular row.
Please suggest me hw I can do it.

Thanks in advance

G Singh

Cross Post!!

ChandraRam30-Jul-08 23:33

ChandraRam

30-Jul-08 23:33

Don't cross post

SQL table field

kirthikirthi30-Jul-08 19:51

kirthikirthi

30-Jul-08 19:51

Hi all

I am using SQL 2000 ver.

How can i store large text data in my table field .

What are the field propertys i have to use

Thank you

Kirthi

modified on Thursday, July 31, 2008 2:04 AM

Vimalsoft(Pty) Ltd30-Jul-08 20:53

Vimalsoft(Pty) Ltd

30-Jul-08 20:53

e.g
Use

Mystring VarChar(200)

You can add as much string as you can and can increase a dimension.

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

kirthikirthi30-Jul-08 21:14

kirthikirthi

30-Jul-08 21:14

Hi thank you for reply

but i want to put the table field length greater that 10,000

because my data is more to store

thank you

Kirthi

Vimalsoft(Pty) Ltd30-Jul-08 21:36

Vimalsoft(Pty) Ltd

30-Jul-08 21:36

hi

SQL Fields are not like Storing data in a text file. So if you probably tried to add a dimension of 20000 and get an error like this

The size (20000) given to the column 'name' exceeds the maximum allowed for any data type (8000).

You should know that the Limit is "8000", and i dont understand why would you store such a large string in a Database.

So its not Possible with SQL

kirthikirthi30-Jul-08 21:44

kirthikirthi

30-Jul-08 21:44

hi
ya i know the error but

just i am conforming is there any other way is there to store

like acces (memo field)

thank you

Kirthi

Ashfield30-Jul-08 22:26

30-Jul-08 22:26

There is. Try the ntext data type.

ntext
Variable-length Unicode data with a maximum length of 2^30 - 1 (1,073,741,823) characters. Storage size, in bytes, is two times the number of characters entered. The SQL-2003 synonym for ntext is national text.

BUT

Important:
ntext, text, and image data types will be removed in a future version of Microsoft SQL Server. Avoid using these data types in new development work, and plan to modify applications that currently use them. Use nvarchar(max), varchar(max), and varbinary(max) instead. For more information, see Using Large-Value Data Types.

Bob
Ashfield Consultants Ltd

Vimalsoft(Pty) Ltd31-Jul-08 4:43

Vimalsoft(Pty) Ltd

31-Jul-08 4:43

hi Ashfield

Wow is it Possible?

can i see an example code, because ntext even if you try 10000,it will not work, mybe am not doing it right see

create table #test
(
P_ID int  null,
Pname ntext(10000) null
)

Msg 131, Level 15, State 2, Line 5<br />
The size (10000) given to the column 'Pname' exceeds the maximum allowed for any data type (8000).

Thanks

Ashfield31-Jul-08 8:49

31-Jul-08 8:49

If you read up, your syntax is wrong

create table #b(a ntext)

Bob
Ashfield Consultants Ltd

RyanEK31-Jul-08 18:23

RyanEK

31-Jul-08 18:23

Hi Bob,
Do you have more information on the future non-use of those fields you described? Thanks.

Ryan

Ashfield1-Aug-08 9:52