Don't you think the join columns are incorrect. It should beSELECT t1.Columna FROM Table1 t1 INNER JOINXrefList x ON t1.TableId=x.listid WHERE...
The best pratice says that you should close your database connection as soon as you are done with it so that all the resources acquired by the...
Oh... i have misinterpreted the question. I believe there is no system variable available to let user know whether the procedure is called directly...
select a.[Name], b.name, a.max_lengthfrom sys.columns ajoin sys.types bon a.user_type_id = b.user_type_idwhere [object_id] =...
You can use sp_depends <your_procedure_name> OR You can view dependencies using Object Dependencies from Query Analyzer.
Hi Arijit, You can use "Derived Column" transformation in SSIS and split the single column in multiple columns based on the column length information...
Hi Sandy, You can use "Expression" for setting the background color for particular condition. Regards, Mayur.
Are you following any rule for creating the file name? eg. somefixedcharacter + CurrentDateTime OR it could be anything? If you are following some...
DECLARE @Var VARCHAR(8000) SET @Var = '' SELECT @Var = @Var + [Property] + ',' FROM @MyTable SELECT @Var
I am assuming that you want to insert all the records from source table to destination tables. There is no need to use For Each Loop. Create one data...
When you use FLOAT(20) for casting the precision would be 7 digit only thats why you see the truncation/rounding. Don't use any number any use only...
Looks like access issue. Please have a look into below link:...
Create a job to be executed on every Thursday with following T-sql task. declare @sql varchar(8000) select @sql = 'bcp "EXEC...
Check with Mapping Type, It should be "Fuzzy" & not "Exact". ( Right Click on Mapping and then Edit Mapping under Columns Tab ) Also check with...
Wonderful Data Flow component for cleaning the data. Couple of things to look out for is "Similarity threshold" & "Editable Comparision Flag" one can...
Hi, I am trying to import data from excel file into SQL Server using SSIS. One of the column in excel file having most of the numeric values and...
How about Max(RowNumber) instead count(*) ?
In that case BOL ( Books Online ) would provide you great help. Please find "Backup Database" / "Restore Database" in BOL whereas you will find...
Separate names with a comma.
