Ed Wagner (6/14/2013)

---

I've always done this using a .NET application and found it far easier than trying to force it with T-SQL. The first big hurdle in doing it...

this post has...

here's my best guess, based on your original query, using row_number() like kingston suggested:

SELECT

ROW_NUMBER() OVER (PARTITION BY mem.MemberID ORDER BY t.TransactionDate) AS RW,

mem.MemberID,

mem.FirstName + ' '...

usually this is done in a programming language, as there's a lot more tools and control there.

Doing it in TSQL only, the file has to exist, and you have to...

Ed you are correct, i'm still not getting what i'm after;

if i add these five more rows to my sample data above, i would expect five values with [1] and...

rajborntodare is correct;

the information is not saved anywhere on SQL server, unless you explicitly added one of the many audit options available to SQL server.

so going forward, I would recommend...

wow amazing what a little coffee can do for me!

my issue was the wrong tool for the job.

i needed to use DENSE_RANK() and not ROW_NUMBER

this is what i should have...

arooj300 (6/13/2013)

---

Hi,

I have a 4 GB CSV file , which i am unable to import in SQL Server 2008 R2, even I not able to open file also. I tried...

SSMS = SQL Server Management Studio, sorry about the acronym!

here's two ways how i might do it.

first create yourself a temp table to capture the results from the code below:

the code below is doing TWO examples,

one to build...

prtk.raval (6/7/2013)

---

I am just wondering about the the tables as they are located as following structre in SQL SERVER MANAGMENT STUDIO

SERVER OBJECT => LINKED SERVER => [ORACLE LS] => [CATALOG]...

vs.satheesh (6/7/2013)

---

i am using CTE in following ways

with CTE1

(

select * from xx

),

CTE2

(

select * from xx a inner join CTE1 CT on xx.id=CT.id

) ,

CTE3

(

select *...

it's incredsibly similar; you just have to use the four part naming convention:

SELECT

TABLE_NAME,

COLUMN_NAME

FROM

MyOracleLinkedServer...ALL_TAB_COLUMNS

WHERE

COLUMN_NAME LIKE '%PATTERN%';

if you are not a sysadmin on the linked server, you might have to use USER_TAB_COLUMNS...

not sure which of the two tables are the problem, but i'd start by looking at any values that cannot convert to a numeric datatype:

SELECT * from [dbo].[Final] ...

whether is was near simultaneous or five minutes apart, what prevents two people form overwriting the task at all?

does the business /app portion present a list of available task slots...