I am looking to find a web hosting provider that provides ASP.NET and PHP hosting. The purpose is pretty much just a programming playground for me to develop in and possible show some of my work. As I use ASP.NET and PHP I am looking for a provider that provides hosting for both of these technologies as well as access to MS SQL Server a...
I have dts package in 2008. It was a ftp task and a mail task. i want to send an email with the task execution results (exact error messages) Is there a way to receive previous task's error codes/messages in the send email task? ...
I have a pending project that may or may not be a good candidate for leveraging SQL Server Analysis Services. The project is based around business metric calculations. Does anyone have some good recommended reading for a crash course in SQL Server Analysis Services that'll let me catch up to speed on what the capabilities and uses are ...
Hi. Is it possible to generated ALTER sql script from the changes you perform in Server Studio. This is possible in different tools for mysql, basically you get the log of executed statements. Is similar thing possible here, or how do you go about finding out what the modification (ALTER) script is? Thanks. -- MB ...
I currently use PluralSight for online video training on .net related technologies. Their videos on .net technology are awesome but I am not satisfied with SQL Server related videos. Could some one please recommend some paid or free training online video site for SQL Server. If this is not the right forum to ask this question then wh...
I have a table that originates in an old legacy system that was case senstive, in particular a status column where 's' = 'Schedule import' and 'S' = 'Schedule management'. This table eventually makes its way into a SQL Server 2000 database which I can query against. My query is relatively simple just going for counts... Select trans_typ...
I'm trying to insert trailing spaces into a VARCHAR(50) column and the SQL insert seems to be cutting them off. Here's my code: create table #temp (field varchar(10)); insert into #temp select ' '; select LEN(field) from #temp; Unfortunately, this returns a length of zero, meaning the ' ' was inserted as a ''. I need a blank space to ...
SQL Server 2008 running on Windows Server Enterprise(?) Edition 2008 I have a query joining against twenty some-odd tables (mostly LEFT OUTER JOINs). The full dataset returned by an unfiltered query returns less than 1,000 rows in less than 1s. When I apply a WHERE clause to filter the query it returns less than 300 rows in less than 1s...
I have a table 'TableA': TableA_ID (int) Date (smalldatetime) Name (string) and a table 'TableB' linked with TableA by TableA_ID: TableB_ID (int) TableA_ID (int) Description (string) Total (double) I want to sum up the TableB 'Total' column between two dates (TableA 'Date'). ...
In the past, I installed Visual Studio 2010. With that comes SQL Server. Now I installed this:Microsoft SQL Server Management Studio Express Now, upon starting, I get this screen: And it doesn't matter what Server name I enter, nothing works. I've tried installing SQL Server 2008 Enterprise(I can get that via MSDNAA), but that fail...
My website/application is in ASP.NET. I use the traditional Session object when people connect so they have their preference, etc. My problem is that sessions were lost very often. I discovered that my hosting company was using load balancing on their servers, so one request on my website can be on one server, and the other on another o...
I have this requirement that i need to Update/Save all records from DatabaseA on ServerA when DatabaseB on ServerB Status is updated to FG-FRESH. Example: ServerB| DatabaseB SerialNumber Status 0000001 Completed 0000002 FG-FRESH 0000003 FG-FRESH ServerA | DatabaseA SerialNumber Status 0000002 FG-FRESH 0000003 ...
Lets say I have the following table User_ID Manager_ID --------------------- Linda Jacob Mark Linda Kevin Linda Steve Mark John Kevin Basically the requirement is to pull all the managers under the user_id you are searching for. So for instance if I send in 'Linda' then it should retur...
I would like to migrate a SQL Server 2008 database to Postgres. Is there a painless way to do this? are there any tools that will scan through the schema and stored procedures to flag compatibility problems? ...
I would like to query back a list of threads, with each of the conversation showing the latest message max(date), and a count of how many messages in the conversation count(*), group by threadID. Here's the SQL table Message ------------- messageID (int) subject (varchar) ... date (date) threadID (guid) How do I produce the following...
The query below is working: update top(1) ShipBillInfo set shipfirstname='kkk' where CustomerId='134'; but it is showing error if i try to order by some Id: for example: update top(1) ShipBillInfo set shipfirstname='kkk' where CustomerId='134' order by OredrGUID desc; ...
Why does SSMS (MS SQL Server Management Studio) continue to increase the appending numbers to windows and queries even if I open a new one after closing all previous? For ex., the window header of a newly created query is shown as "SQL query6. sql - localhost.databasename (ComputerName\Administrator (52))". How one can reuse these "help...
"Also, master is the database that records the existence of all other databases and the location of those database files and records the initialization information for SQL Server. Therefore, SQL Server cannot start if the master database is unavailable. In SQL Server, system objects are no longer stored in the master database; instead, ...
id1 id2 year State Gender ==== ====== ====== ===== ======= 1 A 2008 ca M 1 B 2008 ca M 3 A 2009 ny F 3 A 2008 ny F 4 A 2009 tx F select state, gender, [year], count (distinct(cast(id1 as varchar(10)) + i...
I know in SQL Server you can create indexes on a view, then the view saves the data from the underlying table. Then you can query the view. But, why I need to use view instead of table? ...