Just like you did above but instead of having your cte be 2 rows, make the table the values...

ditha (4/21/2015)

---

Eiminating I and O - its needs to return 24*24*10*10*24*24*10*10 exactly 3 317760000 records .

That's fine with the data load if its slow.

but I need to...

ditha (4/21/2015)

---

Hi, Thanks for the immediate Suggestion.

I am using below as Input query to load sequence records to destination table

SELECT ID, [Database].[dbo].[SequenceComplexNEW](ID) AS Sequence

FROM (SELECT n AS...

ditha (4/21/2015)

---

I need to load the output in database table.so I am trying to write a Sql stored procedure or function to return the sequence numbers and load the sequence...

I am sure this is crystal...

ditha (4/20/2015)

---

Please Help - GENERATE 8 CHARACTER ALPHANUMERIC SEQUENCES

Requirements

• ALPHANUMERIC FORMAT – > AA00AA00………..ZZ99ZZ99

Last 8 bytes will alternate between 2 byte alpha/2 byte numeric

• Generate from Alphabets – A...

Naveen J V (4/20/2015)

---

Hi Experts,

I have used Aasim Abdullah's (below link) stored procedure for dynamically generate code for deletion of child tables based on parent with...

vipin_jha123 (4/21/2015)

---

Hi ,

I am having staging table with separted by '¯'.

I want to split the data with given number .

i have given 31 means my main table have 31 column.

it...

I assume you meant to have a NULL and not the string literal "NULL" in your data. If you have the string literal you just need to use a NULLIF.

CREATE...

sharonsql2013 (4/20/2015)

---

Hi ,

I need to get the below data in one single row... How can I do so?

CREATE TABLE #tbl_data (

Region Varchar(25),

code_1 Varchar(20),

code_2 Varchar(20)

);

INSERT...

Hi and welcome to the forums. In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form...

With ROW_NUMBER. https://msdn.microsoft.com/en-us/library/ms186734.aspx

Your explanation is kind of all over the place. You reference columns in your sample query that don't exist in your sample data. The description is difficult to follow however...

cphite (4/17/2015)

---

Sean Lange (4/17/2015)

---

Please note that the query in the apply from cphites excellent solution is using TOP 1 but it also needs to have an order by so you...

Lidou123 (4/17/2015)

---

Hi experts,

I am working with access 2013 and I want to add an extra row in my select query.

With sql server I used an union like this:

select...