Hi there, try this:

SELECT ISNULL(RIGHT(' '+CONVERT(VARCHAR,Title),40) , REPLICATE (' ',40))

Tell us if that worked for you!

Hi there, please move the semicolon at the end of the statement at the penultimate place.

Like this

SELECT @sql = N'exec master..xp_cmdShell ''bcp DBA.dbo.x in \\RemoteServer\e$\DIR\Filename.csv -F02 /Sservname\Instancename -T...

I can put N-Way handshaking as this:

Assume there are 4 people sitting in the room and assume they are to first hand-shake with each other, then they will pair up...

Good code , Gopi! 😎

You probably wil have to use Paul White NZ's N-Way Handshaking code for your requirement!

NOTE : Jeff Moden had advised that this code contains triangular joins and we must...

Deepak, are you sure, the code i supplied dint provide any results? Cos i imported the excel data that you provided, then created teh query on top of that.. it...

You're welcome, sachin!

😎

Sachin , this will help you

SELECT

CASE WHEN DATEPART (HH,GETDATE()) < 4 THEN DATEADD(HH,-1, GETDATE())

ELSE GETDATE()

END [TIME]

FROM...

I'm afraid we dont have any..

You have to use Dynamic-SQL for these purposes!

Something like

-- Declare and initialize the database name

DECLARE @dBName VARCHAR(20)

SET @dBName = 'MASTER'

-- Declare and initialize the query

DECLARE @QUERY VARCHAR(128)

SET @QUERY...

You're welcome, nitesh..:-)

You're welcome, NewBee..:-)

Deepak, let me tell u this, this was one of the longest ask i had worked on :-D, not cos' of the code, but for importing data into my machine!

Here...

To learn more about the CASE syntax, please go through the following BOL link, especially the Examples part of it

CASE (Transact-SQL)

😎

NewBee, replace all of your ELSE IF to WHEN.. That syntax u used is not supported..

Hope this helps you!