How do I go about placing photographs in SQL?

SQL Server Reporting Services

Index ‹ SQL Server

- Previous
  - 1
    - parameterize SSIS package to identify a source file location OK Thanks I will see it Tag: How do I go about placing photographs in SQL?
  - 2
    - Create Table within an IF statement causes error MS SQL has always had a problem with this construct. The solution, as mentioned, is to create the table once, and then use alter table to change the table to what you want. Or just create 2 tables of different names. Tag: How do I go about placing photographs in SQL?
  - 3
    - Strange Behaviour Sort and Merge Join I have encountered an annoying problem which causes the Merge Joins to lose records in the dataflow. The problem is caused by 2 unusual behavoirs. 1/ Sort of SSIS is not sorting the same as ORDER BY in SQL example: Code Snippet CREATE TABLE [dbo].[table_2]( [test] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] With data as following: Code Snippet 1000 1-1.00.00.00 2000 When select this data with an order by like: select test from table_2 order by test The result will be: Code Snippet test 1-1.00.00.00 1000 2000 If you sort the data by the SORT block of the SSIS the result will be: Code Snippet test 1000 1-1.00.00.00 2000 This is annoying and dangerous, because it causes the next bug. 2/ Two datasources sorted by ORDER BY clause can give problems in a Merge Join. If you have 2 data sources both correctly sorted by an order by in the query. When you join these 2 datasources with a Merge Join, you can lose some records in the dataflow. This happens with larger datasets than examples above. http://img340.imageshack.us/my.php image=strangebehavior2tw1.png When I join the datasources (see image ) inside SQL I will get a correct result of 15271 records. Is this a bug which I should report or is there a flaw in my logic Tag: How do I go about placing photographs in SQL?
  - 4
    - Server Agent Jobs: Script job as create to file... NICE Tag: How do I go about placing photographs in SQL?
  - 5
    - comparing two fields Greetings. I am trying to write a sql that identifies all the rows in one table that do not match another. The sql needs to compare the values in two columns of each table. In the past, I've used a where not exists and a subquery to identify missing rows. select a . block_code from BLKPTS_ADDXY a where not exists ( select block_code from allblkzips as s where s . block_code = a . block_code ) I need to add a second column from each table (zip) to the query. For some reason, it doesn't seem as straightforward as I thought it should be. Suggestions are appreciated. Thanks. alan Tag: How do I go about placing photographs in SQL?
  - 6
    - Transaction Question When I run the following in Query Analyzer: SET QUOTED_IDENTIFIER OFF -- allows double quotes (") used as wrapper for dynamic sql. DECLARE @E int BEGIN TRAN T1 PRINT 'Start...' EXEC ( " begin tran T2| raiserror( ' inside proc', 16, 11) PRINT STR(@@ERROR) rollback tran T2 PRINT STR(@@ERROR) return " ) SET @E = @@ERROR IF @E <> 0 BEGIN PRINT 'Error ' + LTRIM ( STR ( @E )) + ' out of here...' ROLLBACK TRAN T1 RETURN END PRINT 'Done.' COMMIT TRAN T1 I get the following output and error: Start... Msg 50000, Level 16, State 11, Line 3 inside proc 50000 Msg 6401, Level 16, State 1, Line 5 Cannot roll back T2. No transaction or savepoint of that name was found. 6401 Msg 266, Level 16, State 2, Line 7 Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 1, current count = 2. Error 266 out of here... Anyone have an idea why I would get the 6401 and 266 error JD Waleska, GA MSBassSingerNO-SPAM@alltel.NO-SPAMnet (just remove the string NO-SPAM) Tag: How do I go about placing photographs in SQL?
  - 7
    - Cannot connect to 2000 from 2005 via linked server Interesting issue.. I think I have 2 linked servers on my dev 2005 instance (sp1-win 2003). My 2005 instance shares the physical server with a 2000 instance. This linked server works fine. The second linked server is on a separate server running sql 2000 sp3. I cannot connect to this server at all. I can connect the other way -- from the 2000 to the 2005. I have tried all kinds of combinations of security and options but nothing works. The only resolutions I have found referenced installing Management Studio on the 2000 server or creating an ODBC connection from the 2005 instance. Any ideas Here is the error I get: OLE DB provider "SQLNCLI" for linked server "ALLFLDB6" returned message "Login timeout expired". OLE DB provider "SQLNCLI" for linked server "ALLFLDB6" returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.". Msg 10061, Level 16, State 1, Line 0 TCP Provider: No connection could be made because the target machine actively refused it. Tag: How do I go about placing photographs in SQL?
  - 8
    - Cube processes OK but no rows appear in the browser I have a small cube that process ok. The message shows that a few hundred rows processed from the fact table and the appropriate number of dimensions processed. When I look at the cube in the browser I get blank cells no matter what dimension or measure. Any wisdom Tag: How do I go about placing photographs in SQL?
  - 9
    - Is there Limitations to Importing data to SQL Server Express djartsinc, Don't take it personally, one way you keep learning is to take the risk of exposing what you don't know. I learn something here almost every day. Some of my 'teachers' are gentle, some are a bit 'rough' -but my learning keeps on... Tag: How do I go about placing photographs in SQL?
  - 10
    - Multi-database Multi-server Report uses datasource structure to connect to a database. Query string in datasource is an expression, so you can write it in such a way that it gives different results depending on user. How exactly you do it is up to you. It may be a hard-coded switch statement or may be you can put it into some table and query this table with applying username as a filter... Many options exist Tag: How do I go about placing photographs in SQL?
  - 11
    - DB does not autogrow Good Morning, I am having a problem where I have a process that seems to fill up the database but the database does not seem to grow like it should. The database is set to autogrow by 10%... the database is around 15-16GB and it is right over 16GB when it fails. This happens once a week lately. nothing on the server has changed. the strange thing is when you look at the database properties through EM it shows as no space available but when you do a shrink file and look at the log and data files there are over almost 2GB free on the data file and 1GB free on the log... it does no make sense... in order for EM to show there is free space I have to add over 5GB to the data file and 1.5 GB to the log file. then processes continue... is there something that I am missing Tag: How do I go about placing photographs in SQL?
  - 12
    - Want Text box font to be inherited from list I want to set properties such as font family, font size, etc as high as possble in the report. Is it possible to have textbox fonts inherited from a container like a list, or report Currently it seems I need to set fonts on every textbox. Similarly, when I use report designer to put a textbox on a report, the textbox decides the Font is Normal, Arial, 10pt, Normal. Where is this setting stored Tag: How do I go about placing photographs in SQL?
  - 13
    - new SSRS install, works great until I try to access Oracle datasource - System.Data.OracleClient requires Oracle client software re: new SSRS install, works great until I try to access Oracle datasource - System.Data.OracleClient requires Oracle client software From my desktop the report accessing an Oracle 9i db with no problem. I've deployed other reports accesing sql server with no problem. Now I deploy the report and try to access my Oracle source and get: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater On the server in question, I know they've installed the oracle client. I can access the db from sql plus with no problem. As the user that I access ssrs credentials, i remote login and am able to write to oracle home.. C:\oracle\ora10g\NETWORK\ADMIN i've confirmed my database is in tnsnames and it works from sqlplus. Tag: How do I go about placing photographs in SQL?
  - 14
    - copying tables DTS vs SSIS - speed!!! Kolf wrote: the problem is that I am using the transfer SQL server object task which it uses SMO by default not OLEDB. unless there is another way to copy the content of a table. p.s. the tables do not exist on the remote server the transfer SQk server objects task, creates the table as well as copying the content. cheers Remember that SSIS is a data manipulation tool - not a schema manipulation tool. Hence, there isn't THAT much support for moving schema objects about. If I were you I would create the tables using conventional methods (i.e. CREATE TABLE scripts run from the Execute SQL Task) and then use data-flows to pump data between them. This will not be slower than DTS. It will be alot more maintainable as well. -Jamie Tag: How do I go about placing photographs in SQL?
  - 15
    - using historical attributes with SCD transform on a table with a PK Phil, thanks for the info. I forgot to include the SCD indicator field in my original post. Well, 6 hours later and here's what I have in this customers table: ID, Lastname, Firstname, SCD_Indicator, SurrogateKey where SurrogateKey is an IDENT (gasp) PK field, ID is defined as a fixed attribute in the SCD transform and Lastname/Firstname are historical. The SCD transform is happy with this arrangement and changes to Lastname/FirstName are stored as new records with a status of 'current' (and the old record as 'expired'). But... This table owns another table (Addresses), i.e. there is a one-to-many relationship between the customers table and the Addresses table, with the SurrogateKey implanted in the Addresses table as the foreign key to the customers table. Storing new records in the parent table (i.e. new 'current' records) does not obviously update the child (addresses) table with the new record surrogate key ident value - so how do I update the child table to use the new parent record with the changed historical attributes thanks again Tag: How do I go about placing photographs in SQL?
  - 16
    - How to validate the parameter values? Hi, Is there any way to validate the input paratemers for the report For example: I want to restrict the value to be less than 100 in one parameter. How to achieve this Thnx in advance. Tag: How do I go about placing photographs in SQL?
- Next
  - 1
    - Average of children Strippy, Feel free to post!! If I can I will help you as other persons help me when I need... this is a comunity! :-) But when your answer is responded, please check as answered!! regards!!! Tag: How do I go about placing photographs in SQL?
  - 2
    - Query Time Limit? I know I can use SET QUERY_GOVERNOR_COST_LIMIT to prevent a query from executing if its estimated execution time exceeds the value of the specified time in seconds, but is there some way to have a query stop executing (and raise an error) if the time exceeds a specified time For example, if the query takes longer than 20 seconds, have it stop executing and raise an error Thanks, -Dave Tag: How do I go about placing photographs in SQL?
  - 3
    - Personal Web Developer Kit SQL Error Hi folks, I get this error message when I try to run my personal web page starter kit (Ctrl + F5) which has come straight out of the box: Server Error in '/WebSite1' Application. Tag: How do I go about placing photographs in SQL?
  - 4
    - SQL Server - using a cursor to find and sum login/logout times Hi all, New to using cursors and i was after some help. We have a trace running to find instances of certain sp's, these basically tell us when someone logs in and someone logs out (1 row per event). Importing into a table basically gives me process, user, datetime e.g. 'login', user1, 2007-02-15 10:21:35.590 'login', user2, 2007-02-15 10:21:36.100 'logout', user1, 2007-02-15 10:22:45.100 'login', user3, 2007-02-15 10:23:23.100 'logout', user2, 2007-02-15 10:27:54.436 'logout', user3, 2007-02-15 10:30:03.237 What i need to do is to basically get to the point where we have user, total time in system' e.g. user1, 1min 10secs (close!) user2, 6mins 18secs user3, 6mins 40secs any help much appreciated. Thanks, Jon Tag: How do I go about placing photographs in SQL?
  - 5
    - Query performance problems with join on UDF-based computed column Have you tried explicitly creating a statistic for the column e.g. create statistics _stats on table1(compute_col) with fullscan, norecompute Tag: How do I go about placing photographs in SQL?
  - 6
    - Pointers to the best documentation on star joins and the optimiser Hi All, We have been doing some pretty extensive testing on star joins and I thought I would share the results we can publicly here......those who want to contact me directly are welcome to at peter@peternolan.com . Or post questions to this thread.... We have made star joins work reliably. What we did was remove clustering create partitioned tables and put indexes containing many of the join columns in them. Once we were up over the 10M mark in the fact tables the start join kicked in pretty reliably. While we were down below 10M...and my early tests were on 5M row tables......the star joins would not kick in....and we never got them to kick in on unpartitioned fact tables....... So, to repeat, the only way we got star joins to work on 2005 was unpartitioned fact tables over 10M rows. Although, it really does not seem to matter..... The other experiment we tried was to follow the DB2 optimiser documentation and set up the SQL Server tables exactly as recommended for DB2......mostly on the basis that if MSFT had copied the DB2 optimiser behavior then SQL Server would work the same way.... And so it was..... So we found that the best way to set up a fact table is to create a partitioned clustered fact table with aligned indexes. And place an index on each of the fact table keys that will be used to join dimension tables on a regular basis. We implemented multiple levels of partitioning on a multi-part 'partitioning column' that is an integer....... We have implemented a template fact table and now we will go forward with all fact tables implemented in exactly the same way....... Even when the optimiser picked the cartesian product for unclustered fact tables the clustered fact table based query ran more quickly...... Though, of course, there is a very severe overhead for inserting and updating clustered fact tables in SQL Server......but it looks like we have to 'pay the piper' on update to get the query performance we are after.... Best Regards Peter Nolan www.peternolan.com (Alas, becoming far too much of an sql server dba) Tag: How do I go about placing photographs in SQL?
  - 7
    - Multiple Select statements + Stored Procedure If there any relation between the tables,you can group them in the gridview Tag: How do I go about placing photographs in SQL?
  - 8
    - hidden views hi , i have created views in database Test, in sqlServer.when i had to export Test to another database Test1, the views become hiddden. i can't see the views and when i try to create them again, i get this msg: There is already an object named 'view1' in the database. so how can i resolve this problem thanks, Tag: How do I go about placing photographs in SQL?
  - 9
    - Login Failed for <domain name>\<Machine Name> For some reason , the report server is trying to login as <domainname>\<machine name> - its supposed to be <domain>\<user name> or ASPNET or Network Service Authority - I have no clue why it is pickin gup machine name. Any ideas and how to fix Tag: How do I go about placing photographs in SQL?
  - 10
    - adding client server aliases How can I import a client alias list in SQL Server 2005 Configuration Manager The tool provides a way to export a list, but not to import a list. Adding 100 SQL Server instances via the GUI is time consuming and agonizing. Thanks, Justin Randall Tag: How do I go about placing photographs in SQL?
  - 11
    - Profiler trace bind variables Hi, Could anyne help me on which options in Profiler could be used to trace the bind variables in DML Given a table, X (col1 number, col2 varchar(10)), where col1 is primary key. Example DML statements: 1) insert into X values (@parameter1, @parameter2) 2) update X set col2 = @parameter2 where col1 = @parameter1 3) delete X where col1 = @parameter1 where @parameter1 and @parameter2 are bind variables. Can Profiler be configured to log the actual values of @parameter1 and @parameter2 in the example statements in trace log Thanks a lot. Tag: How do I go about placing photographs in SQL?
  - 12
    - aspnet_wp.exe crashing intermittently I have an application which is providing printing facility using a custom hardware interface device. Whenever a print is required user punches in his ID number into the hardware device, and hence an underlying application gets the event and it calls a managed DLL, which inturn calls the Reporting services webservice on the same server. Problem starts after some days (typically after 2 -3 days), when the server response becomes slow and the aspnet_wp.exe restarts every now and then and after this sequence of happening, finally it crashes with some event in application in event log which reads: The server was unable to allocate from the system nonpaged pool because the pool was empty. Also many times the applications log file reads : There is an error in XML document (1, 948). I think this error starts when the aspnet_wp.exe is restarting, but I am not sure. The server operating system is Windows 2000 SP-4, MS SQL Server 2000 Standard Edition SP-4, MS Reporting Services 2000 Standard SP-2 with .Net Framework v1.1 The Server is running many applications apart from the ones listed above and there is a moderate usage of TCP/IP sockets for communicating with certain hardware devices. Please help me out! Tag: How do I go about placing photographs in SQL?
  - 13
    - Problem for Calling A Stored Procedure, Please help. ok,the important checkpoint on sys.procedure -> "exec sp_executesql" check with my sample. you'll get what you want. Hint: as you set output varity with value,you shouldn't return any value. it's useless. Reference with Books Online "sp_executesql" Cheers, Hunt alter proc [sp_test1] (@number varchar(30), @numbera varchar(30), @numberb varchar(30), @Total float output, @balance float output) as declare @table varchar(20) declare @freetotal varchar(20) declare @A float declare @SQL nvarchar(4000); declare @SQLparm nvarchar(500); set @table ='car' set @balance = 3.0 set @freetotal = 2.0 --the section below will be the most important. set @SQLparm = N'@A float output' select @sql = ' select @A = 2.0 FROM ' + @table exec sp_executesql @sql,@SQLparm ,@A output set @Total = @balance / @A + @freetotal go declare @tot float declare @free float exec [sp_test1] '1','2','3',@tot output,@free output print '---' print @tot print @free go Tag: How do I go about placing photographs in SQL?
  - 14
    - Data Type Range Hi, When I set a tinyint field as identity, it automatically sets the identity seed as 1. I wonder whether the increment is set to go around in loop. Say, I have the range of 256 numbers for a tinybit. So, an identifier should go from 1 to 255 and then to 0 and then back to 1. Is that right Tag: How do I go about placing photographs in SQL?
  - 15
    - A CLR SVF works on my DB instance but not on the other one Hello, I checked the window settings and I found out that the PC where the SQL server instance that gives me problem, use as Date Time zone: (GMT) Casablanca,Monrovia while my Date time zome is Amsterdam, Rome... The DBA told met that all the server in test and production has this setting and it cannot be changed. Could be this the reason of the difference If yes hor an I make my .net code run as it should Thank you Marina B. Tag: How do I go about placing photographs in SQL?
  - 16
    - Scheduled Profiler I need to get performance stats off a number of live servers. The stats need to cover the time from 07:00 to 19:00 every day. I'm after things like CPU, Memory and IO, but also I want things like transactions and stored procedures. Can profiler provide this kind of information, and can I schedule the jobs The systems are all running on Windows server 2003 and SQL Server 2005. Thanks Gary Tag: How do I go about placing photographs in SQL?

aerospaced

I have SQL 2005 Server and Visual Studio 2005 and I am working in vb. I want to create a database which has photographs.

Top

Re: How do I go about placing photographs in SQL?

Simone

Not sure if this is the best place for the question, but check into the VARBINARY(MAX) datatype for image storage.

Simone

Top

Re: How do I go about placing photographs in SQL?

aerospaced

I found an image data-type.

thanks...

Top