Would probably help if you posted the entire query not just the snippet above.

You should also read the first article I reference below in my signature block regarding asking for...

eedgar 45478 (4/23/2015)

---

Thanks SScrazy. I really appreciate your help with this.

Now, I've stumbled on another issue. Since i'm including this the last step of the job here. I don't think...

Or you could use the MS scalar function in the MSDB database:

select job_id, msdb.dbo.agent_datetime(run_date,run_time) from msdb.dbo.sysjobhistory;

Sean Lange (4/23/2015)

---

They are pretty slick. I was working on an article to explain how to use...

Interesting. I get notifications on old threads when new posts are added but I'm not getting any on the new threads I have posted on. Anyone else having...

ScottPletcher (4/23/2015)

---

Lynn Pettis (4/23/2015)

---

CELKO (4/22/2015)

---

Please read any book on basic data modelling and look at the chapters on...

That isn't...

CELKO (4/22/2015)

---

Please read any book on basic data modelling and look at the chapters on scales and measurements....

Finally made the dive into using TVPs. Pretty neat stuff actually.

jre1229 (4/22/2015)

---

I am using a SQL Server Agent jobs that run each morning to update the records in a table to match what they should be for that day. I...

Much simpler way to do this without using windowing functions:

create table #Users (

UserID int not null,

UserName varchar(10) not null

);

insert into #Users

values (1,'Robert');

create...

Jeffery Williams (4/22/2015)

---

Agreed but I can not. We are ETL'ing data from 100 + databases, servers. And I can not add anything to those (client machines). I Can add them...

CELKO (4/21/2015)

---

Please, please read any book on data modeling. A schema is supposed to be a model...

CELKO (4/21/2015)

---

>> I need help with an SQL query. <<

No, you need help with DDL. You have no idea how to make a valid data model A table has...

You don't need a while loop or a nested while loop to accomplish the task you are attempting to complete. Alan.B has shown you a much better way to...