[font="Verdana"]Hi,

Have you checked the Expressions Editor of your DataFlow Task, which has got the Source and Destination Transformation. Basically all the properties are listed in the...

[font="Verdana"]

[/font]

[font="Verdana"]Hi,

The query which I gave...

Hi,

In your select statement, you just made a trim to the columns which you are getting, and not performing the DataType operation. Hence, the DataType...

HI,

Try this..

SELECT CONVERT(VARCHAR(19), GETDATE(), 120) DATE

,REPLACE(REPLACE(REPLACE(CAST(CONVERT(VARCHAR(19), GETDATE(), 120) AS VARCHAR(20)),'-',''),':',''),' ','') FORMATDATE

Regards,

Ashok S

[font="Verdana"]Hi David,

What you told is correct, I agree on it. NOLOCK will return the data faster, but it will fetch the data which haven't commited...

[font="Verdana"]Hi Naveen,

This is one more solution to your query...

SELECT DATEPART(WK, GETDATE())

- DATEPART(WK, DATEADD(DAY, - CAST(DATENAME(DAY,GETDATE()) AS INT), GETDATE())) AS WEEK_OF_THIS_MONTH

...

Hi Ali,

Hope this may help you.

DECLARE @VARIABLE AS VARCHAR(50)

SET @VARIABLE = UPPER('(901) 123-3990 ext. 1209')

--SET @VARIABLE...

Have you tried with NOLOCK option? It may be bit faster than the usual one.

Regards,

Ashok S

Thanks GSquared,

Exactly thats what I'm looking for :-).

And Steve, I suggest you to have...

Hi,

Really hard to identify your problem yaar. I'm sorry, I guess I can't help you :ermm:.

Regards,

Ashok S

Hi,

It will be more understandable if you post your query with sample data. Its ok, from your query I understand that you want to display all...

Hi Namish,

Are you sure that your SQL Server has a user called "'rutikas"?

Does your SQL Server allows Windows Authentication?

...

Hi,

The issue is, eventhough you have set the @ssql variable as varchar(8000), it...

Hi,

Try this, It will give you the result you are looking for.

CREATE TABLE #Test(

ItemNumber char(12),

NumCount Int,

Catagory VARCHAR(20)

)

INSERT INTO #Test VALUES ('1', 2,...

Hi,

Ok, The issue is with your Server. Check whether the Named Connections are Enabled or not in the Server. If not Enable it and...