pdanes (7/19/2012)

---

Yes, I've done that...

You could also use dynamic sql to build the query that needs to be executed based on the parameters passed to the stored procedure.

Did you use the image data type or the varbinary(max) data type? I'm asking because text, ntext, and image data types have been depreciated since the release of SQL...

Charmer (7/19/2012)

---

Hi Friends,

I am trying to concatenate a string and datetime....i did it....but after concatenating , i am getting date and time like Jul 19 2012...

You can think what you like, but I'm not going to give you...

Koen Verbeeck (7/19/2012)

---

100 books? I'm glad I can read 2 on a whole year (technical books not included).

Don't get me wrong, I love to read (read the whole Dexter series...

I am sorry, but I have absolutely no idea what you just said here. It would...

If you can't write dynamic sql, I'm not going to write it...

Swetha527 (7/19/2012)

---

No.

I need columns and data like

[LoanNumber] B1.FirstName B1.LastName C1.FirstName C1.LastName E1.FirstName E1.LastName

-----------------------------------------------------------------------------------------

ABC12345 Swathi ...

Good question. I over thought and picked the wrong answer. Yes, you can restore the database from any of the snapshots, you just have to delete all but...

Is this what you were looking for?

select

t2.[LoanNumber],

stuff((select ', ' + t1.RPTTypeCode + '.' + t1.FirstName + ',' + t1.RPTTypeCode + '.' +...

From another thread:

Swetha527 (7/18/2012)

---

CREATE TABLE [dbo].[Trans1](

[RPTTypeCode] [char](2) NULL,

[Firstname] [varchar](50) NULL,

[LastName] [varchar](50) NULL,

[BarrowerID] [int] NULL,

[LoanTransID] [int] NULL

) ON [PRIMARY]

insert into [Trans1] values('B1','Swathi','B',10,1),('C1','Anu','CH',11,1),('E1','Chintu','KK',13,1)

CREATE TABLE [dbo].[Trans2](

[LoanAppID] [int] NULL,

[LoanTransID] [int] NULL,

[LoanNumber] [varchar](10) NULL

) ON...

Post replies here.

Please do not post multiple times.

Post replies here.

Please do not post multiple times.

Took me a while to accomplish this. It turned out that the hardest part was getting the select criteria correct to properly align the schedule times to the buckets.

Please...