keywestfl9 (8/19/2010)

---

i have a parameter planno

and then i have a textbox with the expression as below in the page header

FormatNumber(round(Parameters!PlanNo.Value,1),0,-1,-1)

i get #error

Can anyone tell me what i am doing...

Sample tables and data please.

Read the link in my signature for how to best display this.

--Sample table

DECLARE @TABLE AS TABLE(

[RID] INT,

[EMID] INT,

[In Time] DATETIME,

[Out Time] DATETIME)

--Insert sample data

INSERT INTO @TABLE

SELECT 62, 12, '2005-08-18 06:02:00', '2005-08-18 06:31:00'

UNION ALL SELECT 63, 12, '2005-08-18 06:31:00', '2005-08-18 06:33:00'

UNION ALL...

Failing that, would something like this do?

SELECT 'INSERT INTO yournewtable(Col1,Col2,Col3) SELECT '

+ Quotename(col1, '''') + ','

+...

I think my problem is that it's 2008 and I'm not able to connect to my 2008 box to test it today 😛

thisisdeepthy (8/19/2010)

---

No thers isn't any actually. I am new to sql and ssis.

I migrated the data from these flat files in to another flat file destination using SSIS, but...

Is there a reason you can't do this in SSIS?

Don't overly like.

Off the top of my head: -

DECLARE @caps VARCHAR(24),

@lower VARCHAR(25),

...

Ummm, :blink:

DECLARE @TABLE AS TABLE(

A INT,

B INT)

INSERT INTO @TABLE

SELECT 1,1

UNION ALL SELECT 0,1

UNION ALL SELECT 1,0

SELECT a,

b

FROM @TABLE

WHERE ( CASE

...

http://www.sqlservercentral.com/scripts/Maintenance+and+Management/30222/

I went with this: -

--DROP FUNCTION [dbo].[Split]

--GO

--Split function

CREATE FUNCTION dbo.Split (@sep char(1), @s-2 varchar(512))

RETURNS table

AS

RETURN (

WITH Pieces(pn, start, stop) AS (

...

Chi Chi Cabron (8/11/2010)

---

Can someone explain this strange behavior to me?

Inserting into #Table2 with a subquery causes the computed column to be rounded off to the nearest whole number.

If I...

Nope.

Please read the article[/url] that ColdCoffee pointed you at and supply...

adonetok (8/11/2010)

---

Which one is fast to get count of records?

1)select count(*) from order

2)select count(OrderID) from order (OrderID is primary key)

I tested in 3894000 records table but both them are done...

OCTom (8/11/2010)

---

Not being a DBA, I don't know the answer to this. Do DBA's work independently or do they get permission first before making changes? AS a developer and "accidental"...