additionally, when you have multiple tables having field names of the same, such as LName, FName, Address, etc. that may appear in more than one

table then it would be...

Vijay_Raju (10/2/2012)

---

I have a Table with 20 columns the first 12 columns needs to be same as it is, but from 13th column to 20 column i want it in...

datediff(yy, date1, date2) > 4

If you want some more detailed help you are going to have to provide something to work with. With over 600 points you are by no...

3. If multiple records found in sys.columns you will NOT cause get run-time error and will be set to one of values returned by SELECT (you cannot guarantee which one)...

PiMané (10/2/2012)

---

Thanks... using the column number isn't as much readable friendly as is the column name.... but it works fine 🙂

Is there any problem using the column number besides risking...

Charles Kincaid (10/2/2012)

---

I would agree with you except for name collision. ...

You should read this article from Gail about catch all queries. http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/%5B/url%5D

And if you are going to have to modify column names after you create them I don't see how this saves you any effort or time. At any rate instead...

charles.byrne (10/2/2012)

---

Besides the .* issue which sounds like you plan on fixing. What was also odd was the naming prefix for the views being 'tbl_' for a view. ...

Of course this is nothing more than a cursor. Take a look at the code.

Jeff Moden (10/1/2012)

---

Perhaps it's just the way I've been using them but I've had no such problems with a properly constructed EAV. Certainly, I've not had to do a...

I don't understand how this determines which time zone. To truly get the format in the way you...

PSB (9/28/2012)

---

Updated 2nd case data

IF we have same relNum,DDate and differnt MAXBOLTIME

Insert into FACT

SELECT 4,400,7999,2012-1-27,1234,1111,3333,489

UNION

SELECT 5,500,7999,2012-1-27,2000,2222,1111,499

UNION

SELECT 6,600,7999, 2012-1-27,1,2,3,466

we need the row with maxbol (499) and delete the two e.g...

jhtein (9/28/2012)

---

Thanks Sean, that worked and got me the results I need.

Those number were just examples; not taken from the data. I probably should have clarified that.

I'll remember to following...

Pretty sparse on details but I think something like this is what you want.

;with Data as

(

select 1 as ID, 'A' as Status, 1 as Sequence union all

select 1, 'C', 2...