Hi, I'm trying to build a stored procedure in order to import data from an excel file to a temporary table. I'm using the following code: set @strSql = 'SELECT * INTO #TempTable FROM OPENROWSET( "Microsoft.Jet.OLEDB.4.0", "Excel 12.0;Database=C:\FileName.xls ","SELECT...

yes t-log difference is there 12:50PM,13:30PM could u please suggest me

My problem (excuse me for being a novice) is that whenever the query becomes complex in the @whereclause (and it does) it cant exceed the character limit of a nvarchar. Now if someone could shed some ligfht on this for me I would be incredibly grateful. I have tried doing the exec(@var1 + @var2) but...

Suppose we have two tables: Parent (id uniqueidentifier, cola varchar(100), colb int, colc bit) Child (id uniqueidentifier, Parent_id uniqueidentifier, cola varchar(100)) I've seen a lot of procedures along these lines: CREATE PROCEDURE ps_Parent(@get_children bit = 0) AS IF @get_children = 0 BEGIN...