Search results for query: *

I have a variable called @FilterCmd wher I am creating a query based on many different factors. The query is a select query. I tried running the query like so: exec @FilterCmd But I get an error. How can execute this?

How can I translate the following to its equivalent in TSQL? IIF(CONVERT(age, int) < 18 AND ltrim(rtrim(age)) <> '', CONVERT(1, SQL_BIT), CONVERT(0, SQL_BIT)) AS IsJuvenile

I am writing an active report where I am trying to add 2 values from the database in the following way: this.txtNumAddedTotal.Text = (this.Fields["intNewBPVRegistrations"].Value() + this.Fields["intNewBPVRegistrations"].Value()); But I'm getting an error stating...

I have been asked to create a report with the following look and feel grouped by type. How can I accomplish this grouping using Active reports? Also, if anyone knows where I can find a tutorial on Active reports I'd appreciate it. Number Type Count1 Count2 2425 1...

I keep getting an error that states: "Operator '>' cannot be applied to operands of type 'string' and 'string'" when using the following. I'm trying to compare to see if the dtExpire date is greater than todays date. How can I do this in C#? if(this.Fields["dtCertExpire"].Value.ToString() >...

I have the following query which will return 2 records (Each has different dtPrinted values but the same intTblID values): Select intTblID * from tblMyTable How can I modify the query below to return the record with the oldest dtPrinted value Select DISTINCT intTblID * from tblMyTable

I'm trying to create a query I can use inside a DTS by dynamically setting the Query inside a dynamic properties task. Below is my select statement for creating the Select statement. I keep getting an error. It's mandatory that I use the query to load the values into the "IN" clause because...

I need to use a parameter to pass in one string with multiple values for use inside the "IN" filter of a select statement. Example: parameter is named myParam I want to set myParam value to 'A2fg','A2fh','A2fi','A2fj' And use it in the select statement inside the source query of a dts package...

I have a DTS package where I'm using a Global Variable in the where clause of the query for retrieving a record from the source. How can I call this from a sproc and pass in a value for the global variable?

I need to convert the following Access query to TSQL. The only problem is that I don't have any experience with a query like this. Any help is deeply appreciated. (((IIf([tbl0000Tracking]![AvailableScanDate] Is Not Null,CStr(Format([tbl0000Tracking]![AvailableScanDate],"mm/dd/yyyy")),Null))...

Can someone help me with converting the following where clause in TSQL to PLSQL? I need to pull records where the date (in varchar()) is within the last 2 months. WHERE (IMS_UDT_TS > convert(varchar(26), DATEADD(mm, - 2, getdate()), 21)) AND (IMS_UDT_TS < convert(varchar(26), getdate()...

Can someone help me with converting the following where clause in TSQL to PLSQL? I need to pull records where the date (in varchar()) is within the last 2 months. WHERE (IMS_UDT_TS > convert(varchar(26), DATEADD(mm, - 2, getdate()), 21)) AND (IMS_UDT_TS < convert(varchar(26), getdate()...

I'm thinking that the below is defining a parameter that is set to null if no value is pased in. Am I correct on this? ALTER PROCEDURE [dbo].[jspFilInjImpUBDFiles] @ClientID as int=Null

Is there a way to use an ADO.NET grid to hold data inside an SSIS package? I'd like to load a grid with Unique IDs from a SQL Server table then loop through the grid and update each record with values from the cooresponding record in the Oracle database. Is this possible?

I need to run a DTS package from a sproc and pass parameters in when I call it. Is the following the correct way to call it from a sproc? xp_cmdShell myDTSPackage @var1, @var2

I have been tasked with finding a way to import a subset of records from a table on a remote Oracle database. The table has 80 to 90 million records so I don't want to import the entire table because I will only need approximately 10,000 records. I have a table on SQL Server that has the same...

I have been tasked with finding a way to import a subset of records from a table on a remote Oracle database. The table has 80 to 90 million records so I don't want to import the entire table because I will only need approximately 10,000 records. I have a table on SQL Server that has the same...

Is it possible to run a select statement to return more than one field in a select statement inside a dtsLookUp? Ex place the following statement in a Lookup Select Field1,Field2 from TableA where something = ?

I'm in the process of switching from SQL Server 2000 to 2005. I know that Management Studio has Replaced Enterprise Manager. Is there a ubstitute for DTS?

I have written the following code to upload an image to sql server 2000 using a fileupload control on the GUI but I'm getting an error stating "An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and...