Jeff Moden (5/18/2010)

---

Sorry for the delay... here's an "Inline Table Valued Function" (iTVF) with a bit of flexibility built in. It's not a panacea but it certainly works for...

Jeff Moden (5/18/2010)

---

Heh... not to worry. CC is building his reputation where it...

Andrew,

Use the following; this will work out for you!

SELECT

STUFF('0000',LEN('0000')-LEN(CONVERT(VARCHAR,@Years))+1,LEN(@Years),@Years)

Tell us if that worked!

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..:-)