McSQL (12/12/2014)

---

CREATE TABLE MYTABLE

(

DOC_NO NVARCHAR (10),

REV_NO NVARCHAR (5),

FILE_NAME NVARCHAR (20),

ADD1 NVARCHAR (10),

ADD2 NVARCHAR (10),

ADD3 INT

)

INSERT INTO MYTABLE (DOC_NO, REV_NO, FILE_NAME, ADD1, ADD2, ADD3)

SELECT 'ABC123', 'A', 'abc123.pdf', 'CON1', 'LOC1', 1 UNION...

mahi123 (12/12/2014)

---

Thanks for your reply,

i have been created procedure but i want data in select statements, because in front end code we have to pass optinal perameters something, s that...

I have about 4 ideas of what you might want from this. Can you put together some ddl and sample data in a consumable format? Also, if you can demonstrate...

Actually if the data is consistent this is about the most...

Interesting question. It seems it was poorly worded since one of the correct answers is a statement of fact but the question ask what is the output. Also, the link...

Sure it will work with more rows. Glad it is working...

This looks pretty close to mine. Just before I posted my solution I saw that the OP wanted the closest date that was earlier...

timotech (12/9/2014)

---

Good day,

Please i need help in solving active connection problems in my office, we have roughly 22 people connected to one database. But after a while, their applications begin...

vvinarov (12/11/2014)

---

Hi,

I’m trying to write a query that will extract cost based on closest date (<= date passed by user), product and terminal from example below. Table has over million...

+100000

OK this can be done without resorting to dynamic sql but it is kind of ugly. Notice I created the tables and sample data. This is something you should do...

sKreetz! (12/11/2014)

---

Thanks for the quick reply, Eirikur! It worked like a charm and I appreciate the help. As Sean mentioned, users may change their mind and remove line certain line...

tomek tomek (12/11/2014)

---

the point is, no one knows the real content (even I, as admin) - until decrypted on a website.

Unfortunately,

i don't have enough knowledge to build my own website...

ikrami2000 (12/11/2014)

---

I have this table

Outlet_IDDescription

1Soups

1Salads

1Appetizers

1Tempura

1Tataki

1Teppanyaki

2Teriyaki

2The Sakura Specialty

2Rice

2Noodles

and i need it to be :

Outlet_IDDesc1Desc2 Desc3Desc4

1 ...

tomek tomek (12/11/2014)

---

I have a following situation.

1. I need to encrypt set of strings in t-sql. These encrypted strings will be manually delivered to users.

2. Users have neither...