xenophilia (4/11/2012)

---

when i run this:

SELECT Distinct Outcome

, TestNo

, SUBSTRING(RIGHT('SuitePath',DATALENGTH('SuitePath') - 1),1,PATINDEX('%\%',RIGHT('SuitePath',DATALENGTH('SuitePath') - 1)) - 1)

from testsuite

i get this error

Msg 536, Level 16, State 1, Line 1

Invalid length parameter passed to...

xenophilia (4/11/2012)

---

Oh for the love of mankind it is still happening with the simple DDL I created. Apparently I'm not adopting Lynn's solution properly as it is happening here when...

Gail's blog posts helped me out alot when i was trying to figure out my indexes on a table(Thanks Gail). read them and if you have any questions after...

Lynn Pettis (4/11/2012)

---

Please, someone tell me why, just why do I keep helping someone who...

Lynn Pettis (4/11/2012)

---

SQLKnowItAll (4/11/2012)

---

seesachinjadhav,

note that it is not only bad etiquette in a forum to post your entire question in the subject line and nothing in the post itself, but...

so why dont you post what you know we will ask for?...

http://msdn.microsoft.com/en-us/library/ms186734.aspx in case google is broken. also if you post DDL and sample data you will get tested code. we here like solving problems. it passes...

glad to hear we could help you out.

Is this related to http://www.sqlservercentral.com/Forums/Topic1281810-392-1.aspx "how to sum up instances only 3 of the 4 values that can occur in a given column"

If so it will be better to...

SQLKnowItAll (4/11/2012)

---

Saggy (4/11/2012)

---

hi....guys...

we have to create a nightly maintenance plan for the database Adventureworks that does:

1) Full database and transaction log backup

2) Integrity check, rebuild index, recompute statistics.

Backups should go...

i to prefer to eleminate as many nulls in the data as possible. however it has to make sense. a last modified date IMHO is the inserted date...

what?? a...

is your windows user part of a domain admin group? or some group that has the access you are seeing in the database? only way that would be...

yep with something like the following to pull the next date.

SELECT @NextDate = MIN([datecolumn])

FROM [datetable]

WHERE [datecolumn] > getdate()

im fine with things scheduling themselves with in reason. the first is i have tested them in dev and been able to break them in dev doing things that...