| Thread | Last Post | Replies |
|
| Select Dates | 20 Nov 2008 03:21 GMT | 5 |
I have a table: ID INT Primary Key EntryDate SmallDateTime Amount INT
|
| Turning data into column headings | 20 Nov 2008 02:17 GMT | 4 |
I have a scenario where we need to store strings to be used as labels in my reports. These strings need to be represented in various languages. So I am using a table to store the data called localization.
|
| Logical names of the databases | 20 Nov 2008 00:23 GMT | 5 |
I know how to get the logical name of a database from the backups (RESTORE FILELISTONLY), but how do I get it from the database itself? Thanks, Tom
|
| Use variable in child stored procedure? | 19 Nov 2008 23:52 GMT | 5 |
Is there a way to define a variable used in a main stored procedure so that its value becomes available in a child stored procedure that it calls? I think normally the scope of a variable is just the immediate proc that it's declared in.
|
| triggers | 19 Nov 2008 20:59 GMT | 4 |
I want to create a trigger for one of our tables that handles both insert and update. For the insert, it will always do something. For the update, it will only do something if one particular column in the table was changed.
|
| Trying to get job to send email when done. Failed to notify 'opera | 19 Nov 2008 19:39 GMT | 4 |
I have a scheduled job setup that I am trying to get to send an email when the job is complete when to let me know if the job succeeded or failed. The job runs fine, but I get no email. I went through setup everything for DB mail, and I can send email with the msdb.dbo ...
|
| Stored Procedure Question | 19 Nov 2008 18:00 GMT | 4 |
Is there a way to find out when the content of the stored procedure was last modified. I have a few SPs which are badly documented and I need to find out when it was created/modified. Thanks
|
| fulltext search on all fields at the same time? | 19 Nov 2008 12:37 GMT | 4 |
How do you do a full text search on all columns of a table in a single statement?
|
| SQL Query Using incorrect index | 19 Nov 2008 06:31 GMT | 12 |
We have a problem with this query – declare @startDate as datetime, @endDate as dateTime select @startDate = '2008-10-14 00:00:00.000', @endDate = '2008-10-14 23:59:59';
|
| How To Use MERGE On Variables? | 18 Nov 2008 22:14 GMT | 9 |
I'm trying to update a database using MERGE. But I don't have any source tables to use, I just have Stored Procedure arguments. After fiddling around unsuccessfully I've come to an end now and I need help... Imagine the following table: CREATE TABLE Test (ID TINYINT PRIMARY ...
|
| Flip table | 18 Nov 2008 21:59 GMT | 11 |
how to flip a table? Suppose the tables has same decimail datatypes for all columns except column0 which is varchar. After flip the table, columnnames should be in the column0 of new table and
|
| TRANSACTION ISOLATION LEVEL in a VIEW | 18 Nov 2008 19:48 GMT | 4 |
I have a view created thus: if exists... drop view MyView SET QUOTED_IDENTIFIER OFF
|
| How to handle various options in single query? | 18 Nov 2008 13:27 GMT | 4 |
I'm writing an application in VB.NET which operates data on SQL Server 2000. One form reads data from a table. It has several checkboxes and two Date/Time pickup controls. With the date/time it's clear (at least it works though am not sure if I do
|
| SSIS100: File Task always fails - why? | 18 Nov 2008 12:34 GMT | 7 |
in one of my packages I'm using a File task to rename a file. Only when the file actually exists I want the File task to rename it. I've set the following task properties to false: FailPackageOnFailure and FailParentOnFailure. Yet, when running the package in Visual Studio 2008, ...
|
| Dynamically number rows | 18 Nov 2008 03:11 GMT | 7 |
Doing this in SQL 2005 All I want to do is have a column that auto generates a number for each row starting with 1. Since my below Select statement says show just the top 80, it would be a column with 1 - 80.
|