jjturner (8/25/2014)

---

Eirikur Eiriksson (8/25/2014)

---

jjturner (8/25/2014)

---

Yes, apologies for the tacit generalization (backup ~ backup/restore)

So further to the point, I'm having this DEV recovery model switch over to FULL a number of...

Feel I'm starting to repeat my self on the issue:pinch:

Using the RFC-4180, commas and double quotes within a column/field/attribute are not a problem. The problem is more that many of...

jjturner (8/25/2014)

---

Yes, apologies for the tacit generalization (backup ~ backup/restore)

So further to the point, I'm having this DEV recovery model switch over to FULL a number of days after it...

Lynn Pettis (8/25/2014)

---

rwaring 96203 (8/25/2014)

---

I am definitely no expert, but in my (25-year) career I see a big difference between those who write books about coding versus those of us...

I think you've just scoped your investigation here, suspect that somewhere there...

sqldriver (8/25/2014)

---

That's pretty cool. I like the position column. I don't think you need the extra step with the prefixes, though. Their position (at least in my actual data) isn't...

rwaring 96203 (8/25/2014)

---

I am definitely no expert, but in my (25-year) career I see a big difference between those who write books about coding versus those of us in the...

Quick look and one major concern, only one production backup showing in the period of two weeks!

😎

Lowell (8/25/2014)

---

correct me if i'm wrong, but I thought noone can write to a file on the root of the C drive unless they are running elevated, admin priviledges:

so C:\CambridgePubs.xlsx...

jkalmar 43328 (8/25/2014)

---

Hi. I have a table with columns KitID, BatteryID, TestID and LBSTAT. I need to exclude rows where LBSTAT='NOT DONE', but ONLY if there's not a row with...

N_Muller (8/25/2014)

---

I have a partitioned table and a partitioned index view on the table. As part of the clean up process, data from the partitioned table is switched out...

Just having a quick fun with this problem, this code probably has more of an entertainment value than being an actual solution (couldn't help it):-D

😎

USE tempdb;

GO

WITH cteText(string) AS (

...

shaimaa.tarekelshoeiby (8/25/2014)

---

Thank you ...

But with so limited time , what can I do to help me go through until I can have more time to read the book(s) you suggested...

shaimaa.tarekelshoeiby (8/25/2014)

---

Oh, an important question regarding the join

I learnt about using CTE instead of a view so that I can do it all as sql queries

However , adding the With...

vigneshkumart50 (8/25/2014)

---

Hi,

I have two columns like below

parsename('$'+ Convert(varchar,Convert(money,Q.[Profit Cost]-R.[Shared Dollars]),1),2) as [Pre Profit],

parsename('$'+ Convert(varchar,Convert(money,R.[New Cost+Shared Dollars]-R.[Shared Dollars]),1),2) as [Post Profit]

Formula to be applied:

When [Pre Profit]...