Skanda (10/8/2012)

---

Hi,

I need to write a SQL query to print the following aphanumberic sequence in SQL 2008.

0001, 0002, ... , 0009, 000A, ... , 000Z, ... , 0010, 0011, ......

mubarak.a (10/8/2012)

---

Hi,

I'm new in SQL Server, i want the working process of STUFF & ISNULL. How it works & how it concatenate the row level data into a single data?...

Use table constructor to generate your primary sequence, within a CTE. Then run a select from it, joined to itself 3 times (giving 4 references total in the FROM list)....

Forgive me if I'm mistaken, but all of your posts look like homework. What have you tried so far?

Is it anything to do with this connect entry?

Can you post the full query which causes the error?

Is this query generated by Crystal Reports?

You need to know what the relationships are between the tables. If you don't have an ERD (Entity Relationship Diagram), request one from your...

dwain.c (10/8/2012)

---

ChrisM@Work (10/8/2012)

---

dwain.c (10/8/2012)

---

<<snip>>

Nagaram's is the fastest so far - it's a good 20% faster than mine. I'm having a look to find out why - probably the tally-table generation....

dwain.c (10/8/2012)

---

I like Euros better, just don't have that...

I know you like them - so I put in lots.

RichardDouglas (10/8/2012)

---

Maidenhead SQL Server User Group - Tuesday 9th October

18:00 - 18:30 - Registration, Intro, Round Table discussion, Nuggets etc.

18:30 - 19:30 - Increasing Business and IT...

neellotus07 (10/8/2012)

---

Hi All,

I want to show data from four tables on the basis of left outer join.All tables contain common column "a_code" on which i want to apply left outer...

zahid_7777 (10/8/2012)

---

I have a table (dbo.ACCOUNT_INF) with fields company_code (secondary key), accounts_code (unique) and other columns.

I like to copy rows containing a specific company_code and from accounts_code = 1...

Examine...

lm_hamilton (10/7/2012)

---

Our clients use MS-SQL 2000 through 2008, and soon will have some using 2012.

WinXP through Win7, very few on Vista. 32-bit & 64-bit.

The issue is an old application bug...

dilipd006 (9/27/2012)

---

Hi

I written a procedure to search hotel based on particular hotel name or based on a cityID. The procedure returns 10 tables.The procedure work fine...executing in 1 milisecond...