Hi,
I need to realize multicolumn cell in table for grouping fields, but i don't know how to do that. Help me please.
1col. 2 col. 3 col.
long text grouping field
first second third
data data data
Thank you.
Is it possible? And if yes what's the correct syntax?
I tried both
Declare @expired TABLE (
JdtID Int PRIMARY KEY,
SiteID Int PRIMARY KEY,
PackageId Int,
PackageControlsExpiration Bit,
IsSlot Bit,
MembershipPoints SmallInt,
SupportsAutopost Bit
);
and
Declare @expired TABLE (
JdtID Int,
SiteID Int,
PackageId Int,
PackageControlsExpiration Bit,
IsSlot Bit,
MembershipPoints SmallInt,
SupportsAutopost Bit,
CONSTRAINT Expired_PK PRIMARY KEY (JdtId, SiteId)
);
and neither works.
Thanks, Jenda
Hi,
I'm working with MRS and I've got a table with a lot of entries. For each value in the table I'm trying to get the text colour to be set to 'red' when the value of the cell is less than 0. Otherwise remain black.
I can do this by setting the colour property cell by cell. But I have a lot of cells in the table. Is there a way to set the statement to apply to ALL cells in the table?
Basically I'm asking if there is a way to set the property in bulk instead of going through tediously cell by cell.
Any help would be much appreciated. Thanks!
Hi!
What I'd like to do is:
UPDATE table1
SET
A_TEXT_COLUMN = (SELECT another_text_column
FROM table2
WHERE table2_id = @precomputed_id_1)
WHERE table1_ID = @precomputed_id_2
Since the cells are text, this does not work. Since the cell to be updated is in an already exitant row, it's not possible to simply use insert.
I'd like to do something like (PSEUDOcode):
WRITETEXT(table1.A_TEXT_COLUMN, READTEXT(@textptr_initialised_to_point_at_target_c ell))
But the *actual* synatx of WRITETEXT and READTEXT seem totally inappropriate for any such trick...
Any hints or pointers HUGELY appreciated... THANX
I have a column defined as smalldatetime. Default length (4), and "allow NULLS" is checked.In the Enterprise Manager UI, when i enter data into that table row, if i just tab past that column, all is well, and the value is represented in the UI as <NULL>.The problem comes once i ever enter a date into that column. Say i have entered a date (all is well), and now i want to remove that entry and go back to NULL (after the date value has been committed, different entry session, say).How is that done?It seems to me, once a date has ever been entered into that column, now, if i try to remove it, i get the error "The value you entered is not consistant with the data type or length of the column, or over grid buffer limit". I have tried deleting the value, entering spaces, entering the string NULL or the string <NULL>; maybe some other tries as well, but none works, i always get that error message and am not allowed to proceed past that cell until i restore a date value to it. I want to get back to <NULL>.Anybody know?Thank you.Tom
View 1 Replies View RelatedI have a report where in I want to show each record on a separate page.
So, to achieve that I took a single cell from table control, expanded it and used all the controls in that single cell. This looks nice so far.
Now, I also have to show a sub grid on each record. So I took a table control and added on the same single cell and tried to add a parent group to the table row.
When I preview, it throws this error.
"The tablix has a detail member with inner members. Detail members can only contain static inner members."
What am I doing wrong? How can I achieve table grouping inside a table cell?
Hello, I have a report that has 2 fields only and takes about 4 pages. I want to create a multicolumn report so, it would not take more the 2 pages.
I went to report properties, layout, changed number of columns to 2 and it does not work.
Am I missing something here? Could anyone help me, please?
Thank you.
HI,I HAVE AN EXCEL SHEET WITH SOME DATA, I WANT TO IMPORT THAT DATA (CELLBY CELL WITH MANIPULATION) INTO THE SQL SERVER TABLES BY USING STOREDPROCEDURE(IF POSSIBLE).IF ANYBODY HAVE DONE SIMILER TYPE OF JOB OR KNOWING ABOUT IT, PLS. LETME KNOW.THANKS IN ADV.T.S.NEGI
View 4 Replies View RelatedI'm trying out this database layout under MS SQL (de), with primary multicolomn key, but ....
Let's say table A, has primary KEY on the field PK_A
Let's say table B, has primary KEY on the field PK_B
Now table C, has fields ID_A and ID_B, defined as multicolomn primary key, referencing obviuosly to the PK_A and PK_B values.
NOW THE PROBLEM !! :(
Let present you table D , with his beautiful field ID_C. :)
How can I succed in referencing with the ID_C field the primary multicolomn key of table C ??
I' designing the whole thing with access97+mde, but dragging the PK key of table C (ID_A & ID_B) over the table D (ID_C) doesn't work !!
Any help ??
Thanks in advance !!
H2O
Hi,I have a history table with about 400 million rows, with a uniquecomposite nonclustered index on two columns (object id and time period)which is used for most of the queries into the table, and an identitycolumn for the clustered primary key.Many of my queries use correlated subqueries to pull unique historyrows from the history table for each of a set of objects from theobject table, for instance, pulling the earliest history row for eachobject in a set. These correlated subqueries reference the object tableand return the primary key of the history table, e.g.:select *from lp_object linner join lp_object_history hon h.lp_object_id = l.lp_idwhere l.lp_set_id = 'SOME_LITERAL'and h.lp_id = (select top 1 lp_idfrom lp_object_historywhere lp_object_id = l.lp_idand lp_some_column > 0order by lp_time_period)Now, if lp_some_column is not indexed, this query has no choice but toread the entirety of every single history row for every object in theset where lp_set_id = 'SOME_LITERAL', so that it can determine iflp_some_column > 0, and because the history table is clustered by theidentity column rather than the ID of the relevant object whose historywe're tracking, the reads take forever - they have to bop all aroundthe disk. The sets I deal with tend to have about 5K objects in themand about 200K associated history rows.I'm considering reclustering by the (object id, time period) index, butthen my queries will need an extra bookmark lookup step to get the rowdata from the identity value returned by the correlated subquery. Ithink it will still be faster, though, so I will probably build a copyof the table with the alternative clustering scheme to run someperformance tests.What I'm wondering is, if I were to dispense with the identity columnaltogether and replace it with a composite primary key of (object id,time period), would I be still be able to use my correlated subqueries?Because then there wouldn't be a single column that uniquely identifieseach row in the history table and I don't think SQL Server supportsmulticolumn correlated subqueries.Thanks for reading,Seth
View 4 Replies View Related I'm looking at a system where formulas have been added into fields in a table and I need to look at the field to see what formula to use when selecting eg: eg this + this, this / this etc.Here's a basic table I have knocked up to try different things...
CREATE TABLE #HeaderOrder(
[HeaderCode] [varchar](10) NOT NULL,
[HeaderCode2] [varchar](10) NOT NULL,
[FormulaCode] [varchar](10) NOT NULL
[code]...
Hi,
A few months back i saw a sample rds file where there was a kind of line graph in a table cell
that indicated how much percent a sales person had to the complete sale figure.
But i cannot find the link anymore.
I would like to have such a linge graph next to all my agents that indicates a value againts a total value.
Does anybody has any pointers where i could find that info ?
Greetings
Vinnie
Hello,
In my .NET.ASP application I generate a random five digit password, like so:
string password = Membership.GeneratePassword(5, 1);
The result could be a password like "0l$IE" and I the save this password to an SQL server. The problem is however that with the generated password five blanks are also added. Instead of "0l$IE" I get "0l$IE ". I hope you understand what I mean? Is there an easy way to correct this?
I appreciate any help!
This is embarasing.I'm creating a 500 line query from XML, CSV's, etc. and I can't fingure this out. I'm building a very complex "SELECT" query and then shoving it into the [Select] column in a SQL 2005 table. I want to call a stored procedure that just "executes" that query and returns the results....Any help would rock.
View 3 Replies View RelatedI am converting a site from asp to .net and the previus writer did something I never saw.(I am somewhat new to programming all together). He put multiple values in a single cell of the database. I have always learned to use a seperate column for each value.
Is this a classic asp thing and there are better ways now? Or is this something I should do myself? The columns type is text and the contents look like this:<Details Expertise="bla bla" Description="We are a three-divisional company ...," WebSite="www.blabla.com" AccountLevel="Free" AccountStatus="Active" WorkHomeZIP="22222" ContractStartDate="01/01/2003" ContractEndDate="12/31/2003"><Address Location="Work" State="Oh" ZIP="22222"/><Email Location="Work" Value=""/><Phone Location="Fax" Code="9801" Ext=""/></Details>
I really want to update just one cell without notify the others in record ,but i can not.
example; my table like this.
ID
Increasingnumber
LastModified
1
15
1/1/1900
i want to modify the "increasingnumber" cell only and also not let "LastModify" cell being updated. Can anyone help me solve this problem?
I'm trying to use DTS to import data from an XLS into a SQL table.It works fine in that it INSERT's the data. However, I need it toUPDATE the table, based upon a ProjectID. Can this be done?Can a DTS package be fired from a SP using parameters?Eg UPDATE tProjects SET MyField1=XLS.Sheet1.CellA1,MyField2=XLS.Sheet2.CellA1 WHERE ProjectID = @ProjectID.Also, it must handle dynamic XLS file names, eg 981-Budget.xls,513-Budget.xls, xyz-Budget.xlsIs this the best way to go? Other suggestions most welcome?Thanks everyone in advance!
View 2 Replies View RelatedHella all,
Is it possible to stack two images on top of each other in a table ?
Let me clarify where i'm going to.
I have a report where in one table i would like to display (in a graphical way) how much a sales person has sold towards
the whole sales amount.
To do so i would like to set my background of my cell to yellow and then use an image (just a green rectangle)
where i adjust the padding according to the percentage.
When i set my background to yellow and i insert my image in the cell, the textbox cell properties disapear and are
replaced with the image properties. So also my background that was defined in my textbox is gone.
Now i was thinking if i could set two images on top of each other (a yellow rectangle and a green rectangle). But when
i do that, one image is replaced with another.
Am i doing something wrong or is there another way to achieve what i want to do?
Greetz
Vinnie
Hello All,
I uploaded custtable under the database, the data looks fine except that the name that apprears has a lot of distance e.g
it should be :
firstname lastname however the format appears very strange:
firstname lastname
firstname lastname
fistname lastname
Same is the case with the address, I need to adjust or format the apperance that appears on the cell. Is there a way/ sql statement to format the data under the table so that the apprearence looks okay.
I will really appreciate any sort of help on this one.
Thanks,
Rashi
need help
condition 1
replace characters on condition in table and cells
but only if
how to do it - if i put * (asterisk) like in employee 111 in day1 - the the upper characters the (A S B)
i replace characters with '-'
and it must work dynamically
condition 2
replace characters on condition in table and cells
but only if
if i put number or 1 , 2 , 3 , 4 above any cell for example( employee id=222 name =bbbb day1)
i replace characters with '0' and '#'
and it must work dynamically
table before the replace
id
fname
val
day1
day11
day111
day2
day22
day222
day3
day33
day333
day4
day44
day444
day5
day55
day555
111
aaaa
2
A
S
B
e
t
y
R
Y
M
j
o
p
111
aaaa
1
*
*
*
*
222
bbbb
2
1
1
222
bbbb
1
A
-
-
-
B
-
333
cccc
2
333
cccc
1
444
dddd
2
3
4
444
dddd
1
-
-
C
C
555
EEE
2
A
G
C
555
EEE
1
*
table after the replace
id
fname
val
day1
day11
day111
day2
day22
day222
day3
day33
day333
day4
day44
day444
day5
day55
day555
111
aaaa
2
-
-
-
-
-
-
-
-
-
-
-
-
111
aaaa
1
null
null
null
null
222
bbbb
2
0
0
222
bbbb
1
#
-
-
-
#
-
333
cccc
2
333
cccc
1
444
dddd
2
0
0
444
dddd
1
-
-
#
#
555
EEE
2
-
-
-
555
EEE
1
null
tnx for the help
Is there any way I can set the background colour for an image in a table cell (or even for a non-embedded image for that matter)? I always seem to get a white background.
It is a GIF image file.
Thanks
What would be an equivalent expression for ISNULL(datafield, 0) for a table/matrix cell? I am using iif( Len().. to find out if there is something in the cell, and displaying zero in the cell if the length of cell item is 0, however am wondering if there is any better/elegant way of doing that?
Hi all
I have two cells,having first cell 0 and other cell 5.
How can i add these two cell values.
I used following expression
=Fields!LITMIN.Value + Fields!NUMMIN.Value
But i am getting Concatenated result ie:05
But i need 5.
How can i do it.Pls help me
Is there any option to set auto fit the cell size of a table in SSRS 2005?
Thanks
Does anyone know if it is possible to have text in a single table cell where the first field is formatted in italics and the second is in normal?
eg: = Fields!firstname.Value(as italic) & " " & Fields!lastname.Value(as normal)?
shidot
I need help with a simple query. We have 86 entries with the City of O'Fallon in our db. How do I do this with the apostrophe in O'Fallon? Below is just to give an idea of what I want. Thanks.
SELECT *
FROM Organization
WHERE City=O'Fallon
Hello All, i am trying to create a normal ASP.NET application using VS2005. Yesterday i was adding tables.. entering data from within "View Table Data" tab, but today i am unable to do any data insertion or updating except by entering the insert or update statement by hand. When updating data of existing record or trying to add new data, it reports that "Cell is readonly!". I did not modify any settings or configuration and actually did nothing to set it to readonly! I am quite confused to be honest and writing sql statements by hand is kinda time consuming for me if i want to update a single field. What can i do to re-enable data modifications from VS2005 without reporting readonly? Thanks,Rakan
View 1 Replies View RelatedSECURITY USING CELL-SECURITY:
From what i've read cell security s enforced on the client. If someone is able to gain access to a machine running the client (for example an application server or a web server) he is able to get cell values independently of the fact that those values will be defined as #N/A in the secured cell value property. The real value is travelling between theAnalysis Server and the application server. Is this true ? How can we effectively garantee true security ?
Hi,
I updated my db system from access to sql 2005.
But, i can not add new recors to database.
I'm receiving this error:
"""Invalid value for cell (row 3914, column 2).
The changed value in this cell was not recognized as valid.
.Net Framework Data Type: Int32
Error Message: Input str?ng was not in a correct format.
Type a value appropriate for the data type or press ESC to cancel the change."""
It can not open new id number. DataType was Auto Number in Access. Which can I select in SQL 2005?
Thank you.
hi all
im really have a problem in my project.
i have server and client side each side contain SQL Server DB.
and i have excel file on the server side this excel file conected with another server, this file changed data in continuosly each less than 1 sec by data feed.
now i need to read each changed data cell from this file to save it on server DB and Client DB (just changed data).
my problem :
u know changed event is not fired when change cell by data feed or not edit manually, just calc event is rised . but calc event do not specify the changed cell range (address).
so i do this to know changed cell range:
when run the program saved all excel tabel into SQL server table.
and then check row by row between excel and sql if any change , when i get any change, i update the excel row insted this DB row.
and rise event to send this row to client by socket over internet to update the row in client side too.
but i tell u that the excel file updated each less than 1 sec, and i noted that many changed excel data missed until checked row by row for whole excel sheet with DB tabel and updated change.
this is my problem ( please help me as soon as posible coz i have dead line to Delivered this program)
and if u recomended me for another techneque to be easy or quickly to solve this problem i will thaks so much for u)
thank u.
AL-Khateeb
Hi,
In SQL 2000 I used to be able to open a table in Enterprise Manager and make changes or Update with Query Analyser. Now when I attempt this in SQL 2005 I am told that the Cell is Read Only.
How do I update this column as I cannot find a read-only or allow updates property anywhere?
Please help,
A very frustrated user
HI All,
I changed the join type and did some modifications to the query in the query designer. Then I executed the query. Resutls are shown in query designer. But it says Cell is read only. Therefore when I change the tap from data to preview , I can not view the report.
This happens only when I use generic query builder.
Does anybody know how to change the read only option ?
Thanks
I am trying to implement row-security in SQL 2005 but i make a query to make a view