sql-lover (4/29/2013)

---

Lynn Pettis (4/29/2013)

---

sql-lover (4/29/2013)

---

The best way to fix deadlocks is via T-SQL code, changing the order of your transactions.

Deadlocks occurred because two transactions pin each other, so the 1st...

danawexler (4/29/2013)

---

i'm stuck!! i'm trying to determine if a customer attended our webinar based on their log in date/time - that's the easy part. but there are many...

So the fix was removing the spaces in your original connection string?

sql-lover (4/29/2013)

---

The best way to fix deadlocks is via T-SQL code, changing the order of your transactions.

Deadlocks occurred because two transactions pin each other, so the 1st one can't complete...

Also, if the column(s) you are testing the dates against have time values other than 00:00:00.000, you will miss data at the end of the month.

steve4134 (4/29/2013)

---

Yep Lynn

I just wanted to confirm that what I had wrote was indeed from last month threw the end of the month ran today. So if I ran this...

Look at Snapshot Isolation. Will increase tempdb use but will keep readers from blocking writers.

steve4134 (4/29/2013)

---

I can not express the joy that comes to me when I see a community come out and help someone so quick. I thank you again. I was correct...

Lowell (4/29/2013)

---

creating a view that auto-decrypts the data makes the data no longer HIPAA compliant, doesn't it?

I'd say that is no different from storing the data unencrypted in the...

One of the things you need to understand, there is no concept of...

I disagree with your friend. I do not believe that stored procedures put additional overhead on the server when compared to ad hoc queries.

phamm (4/29/2013)

---

I have this query:

declare @controlnumber varchar(13)

set @controlnumber = '0210300000001'

select *

from Cards

where controlNum like ''''+SUBSTRING(@controlnumber,1,5)+'%'+''''

it returned nothing

however if I change the where clause to controlnum like '02103%' then...

From the original post:

select

GETDATE() CurrentDate,

DATEADD(month, -1,CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(GETDATE())-1),GETDATE()),101)) FirstOfPreviousMonth,

DATEADD(month, -1,CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(DATEADD(mm,1,GETDATE()))),DATEADD(mm,1,GETDATE())),101)) [LastOfPreviousMonth-NOT]

Results:

CurrentDate ...

I don't see where you are providing the Username and password to connect to your source system.

WWDMark (4/29/2013)

---

Hi all,

I'd be really grateful if someone could help me (probably something very basic I'm missing!)

I'm trying to create a stored procedure (code below) but it's failing. If...