I have a scenario in which i receive files from a source and i blindly dump the data in the files to a staging area DB into number of tables. Now i need to translate the data in the Raw Data tables to a format that my Primary database model would understand and eventually do a move of the translated tables to my Primary Database from the...
Hi All my times are in UTC timezone now I need to somehow convert it to the users timezone(I have it stored in the db as well and uses the ids of the windows timezones). How can I do this in SQL Server 2005? Edit So I tried to do that extended stored procedure but with Timezoneinfo I get this error Deploy error SQL01268: .Net Sql...
Hi I use sql server 2005 and I want to find stored procedure option but I can not how can I find it please help me thanks ...
Hi _I use sql server 2005 and I want to execute mu store procedure like exec <procedure_Name> ' ',' ',' ' so for this I need query analyzer window but I can not find please help me _also is there any check syntax box in sql server 2005? thanks ...
I'm adapting a large number of SQL Server 2005 scripts to merge two of our databases together. The scripts are run from a .cmd file which calls sqlcmd to run the scripts in order. However, I'm experiencing one or two issues where the scripts are failing. I'd like a quick way to get a look at the state of some of the scripts where they g...
How to get time part from Sql Server 2005 datetime in HH:mm tt format e.g. 11:25 AM 14:36 PM ...
Not sure how to ask this as I'm a bit of a database noob, What I want to do is the following. table tb_Company table tb_Division I want to return companies that have more than one division and I don't know how to do the where clause. SELECT dbo.tb_Company.CompanyID, dbo.tb_Company.CompanyName, dbo.tb_Division.DivisionName FROM d...
Hello Guys, Do you think having TRANSACTION around every sql statements in stored procedures is a good practice? Just about to optimise this legacy application in my company, one thing I found is that every stored procedures has BEGIN TRANSACTION. Even a simple select and Update statement has one. I thought it would be nice to have BEGI...
I have a large web application using a COM data access layer against an SQL Server 2005 database. By default, the isolation level is READ_COMMITTED. Now I understand how READ_COMMITTED_SNAPSHOT isolation level works, and reading MSDN it says you can turn it on transparently. However, I'm still sceptical. :) Is it guaranteed, in an implem...
In an SSIS package I have a For..Each container that enumerates all (.) the files in a folder. In that For..Each container I have a component-level variable 'fileComments' of DataType 'String'. In that For..Each container I have a script task. With a ReadWrite entry for 'filecomments' (amongst others) In that script task, I have some ...
The debugging experience in SSIS is not what I am expecting. I have a script Task that I have added a Imports System.Diagnostics' at the header of the class, and in the code I have various debug.writeline ("Attemtpting to move file") type messages. But, they are not displaying in the output window. Am I missing something ? ...
I'm having difficulty working out how to 'error handle' as such the following SQL. As part of my SELECT statment I have ((sp.sp_retailprice - sp.sp_wholesaleprice_l1) / (sp.sp_wholesaleprice_l1)) as 'calc test' Which subtracts one column from another then divides the result by the column sp_wholesaleprice_l1. However, the values of...
hi, i want to get column names of table in sys.table using its object_id regards vivek ...
I can access MS Sql from a web application resides in Windows. But it is not possible with a web application reside in Linux. com.microsoft.sqlserver.jdbc.SQLServerDriver is used in this application. Following are the configurations. Tomcat 6 MS SQL 2005 jdk6 Driver :com.microsoft.sqlserver.jdbc.SQLServerDriver ...
Hello all, I am running into a strange problem I don't fully understand. The main symptom is that when I double click a link (that points to a controller action) in my MVC application, my database server connection gets blown, and I get the error : Execution of the command requires an open and available connection. The connection's cur...
I'm tring to create an SSIS package to import some dataset files, however given that I seem to be hitting a brick wall everytime I achieve a small part of the task I need to take a step back and perform a sanity check on what I'm trying to achieve, and if you good people can advise whether SSIS is the way to go about this then I woul...
I hope I'm explaining this well. I'm struggling with this query: I have this table that is something like this: InvoiceNum Amount Type - where type could be item, shipping or tax. So what I want returned is one row per invoice: InvoiceNum, ItemAmount, ShippingAmount, TaxAmount. Here's an example: Invoicenum Amount Type 1 ...
I have a server with multiple databases. I need to loop through these databases and change a value in one record, in one table, in each database. How can this be done? ...
Hi Team, I am trying to generate a series of alphabets, using SQL Server. Suppose I have a tables as follows DECLARE @Funding TABLE (FundingDetailID INT,FundingID INT, DetailDescription VARCHAR(50)) INSERT INTO @Funding (FundingDetailID ,FundingID , DetailDescription) VALUES (1,107,'Desc 1') INSERT INTO @Funding (FundingDetailID ,Fund...
I have table that I want to sum 3 rows of one column how can I do that? ...