Thank you Forever for your Forever help!

create table #Table1 (

id int,

value varchar(10)

)

create table #Table2 (

id int,

value varchar(10)

)

insert into #Table1 values...

I get in EXCEL sheet. I convert them into CSV which gives me bit flexibility to run SSIS package.

yes, it looks like regional settings into browser itself.

yes I am using still date/time parameter. in 2 out of 3 laptop is show date like 6/1/2016 and in one laptop it shows 6/JAN/2016.

I figured it out, here is the solution.

Put following for CRM_URL parameter in SSRS report. https://crm.abc.com/CRMReports/viewer/drillopen.aspx

AND when you click on client's name in table put following into Action...

it's much faster to import data into our software from 4 small tables as compared to one big table. that's why.

Because we do this exercise every week splitting one table into 4. So when we do this we don't care about what's in there into those 4 tables so we...

Michael L John (4/28/2016)

---

This may work

ALTER PROCEDURE Doc124NEW_new

(

@DMIGRATIONNEW nvarchar(255)

)

AS

SET NOCOUNT ON

SET XACT_ABORT ON

DECLARE @ErrorMessage varchar(2048);

DECLARE @ErrorSeverity INT;

DECLARE @ErrorState INT;

DECLARE @SQL AS NVARCHAR(MAX)

DECLARE @Count int...

Only one question now!!

How I can become like you pro in SQL

Please answer. I am ready to do whatever it takes.

BY the way that solution worked fine.

All I am trying to do is to split the table records into 4 fixed name tables equally.

So all was working fine until source table name was hard coded, since...

Looks like that error is solved and got the new one! Neverending!

Error message

Invalid column name 'cindex'.

SP

ALTER PROCEDURE Doc124NEW_new (@DMIGRATIONNEW nvarchar(255))

AS

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets...

I am getting following error.

Msg 245, Level 16, State 1, Procedure Doc124NEW_new, Line 36

Conversion failed when converting the varchar value 'SELECT TOP (' to data type int.

Here is my little...

GilaMonster (4/7/2016)

---

nTile window function can create a column with numbers 1 to 4. After that it should be easy to do an INSERT ... WHERE Tile = 1...

CREATE TABLE #Test...

THANKS