Quick suggestion, instead of nesting IIF's use the Switch statement

😎

=Switch(

Fields!Currency.Value = "USD" ,"'$' #,0;('$' #,0)"

,Fields!Currency.Value = "AUD" ,"'AUD' #,0;('AUD' #,0)"

,Fields!Currency.Value = "EUR" ,"'€' #,0;('€' #,0)"

,Fields!Currency.Value = "GBP" ,"'£' #,0;('£'...

Quick crosstab as an alternative to the pivot

😎

USE tempdb;

GO

SET NOCOUNT ON;

Declare @detail table

(

grn_no varchar(55),

po_no varchar(50),

vendor_no numeric(10,2),

...

Quick suggestion, add WITH NOWAIT to the RAISERROR

😎

BEGIN

BEGIN TRAN;

RAISERROR ('Sorry!You have entered more discount',16,1) WITH NOWAIT;

ROLLBACK;

END

Quick suggestion, change the primary key, something like this:

😎

IF OBJECT_ID('') IS NOT NULL DROP TABLE BasicData;

CREATE TABLE BasicData

(

BasicData INT IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED

...

Quick question, an you post the ddl (create script) for the destination table?

😎

Jeff Moden (11/4/2014)

---

Heh... after 6 years, we might finally...

Almost there;-)

😎

Ed Wagner (11/4/2014)

---

Erikur, I don't know how you got that bit of logic from the decimal values, but well done! It seems to make sense. I was hoping...

No time outs or errors yet, fingers crossed, knock on wood, salt...

Just dawned on me, kind of a deja vu, here is around six years old thread on the same subject.

😎

Quick thought, is it this you are looking for?

😎

SELECT DATEADD(HOUR,735510.40461,'1900-01-01 00:00:00.000')

Result

1983-11-28 06:00:00.000

The time element

SELECT CONVERT(TIME,DATEADD(HOUR,735510.40461,'1900-01-01 00:00:00.000'),0)

Result

06:00:00.0000000

Looks good to me, you might want to construct the filename in the same procedure, i.e.

DB_NAME() + NCHAR(44) + OBJECT_SCHEMA_NAME(ASM.object_id) + NCHAR(44) + OBJECT_NAME(ASM.object_id) + N'.sql'

😎

Quick question, any functions or operators used in the code? Many do have 8K limits. Also look out for implicit casts.

😎

Quick thought, Task Manager is lying.

😎

Chipping in my 2 Cents, it is close to impossible to validate a phone number without a geographical reference, with it, it can still cause an headache.

On the OP,...