lianv 90648 (1/18/2011)

---

Good Day ,

we are in the process of implementing a new security policy where we plant to grant execute permissions to all the stored procedures to public in...

kthanigaivel (1/17/2011)

---

Hi,

I am facing deadlock in update query. i found the reason is Clustered index scan takes more time.

the query likes below example.

update tbl1 set b=10 where c=x...

r_slot (1/18/2011)

---

Thanks Craig for your answer. I have a front-end Access-2007 and I know what the report possibilities are. I was just wondering if things could be done in sql...

^ This.

Sachin, what Keith said above is your best practice, and should usually be done anyway when dealing with LOB data (VARCHAR(MAX), text, Image, etc.) LOBs behave annoyingly when...

You seem new, so here's a way to help you get started:

Click Here

SQL Server Reporting Services. Think Crystal Reports or Access Reports.

Basically, you're looking...

If your column was stored as VARCHAR() what you're listing above should work. However, you don't want dates in that format, so I hope it's not. From your...

Your problem/difference is pTransaction. It's doing a clustered index scan in both cases, but the data volume is hugely different.

~134 thousand rows in Db2 in the base table.

~480 million...

Robert,

That looks like a reporting format you're trying to output. Are you attempting to do this in SSRS or via a T-SQL query? (Psst, SSRS will be easier....

Show us your current work, and current code, and explain where you're having difficulty, and we'll see if we can't help...

You've got other issues then...

Keymoo,

It'll be very difficult to show you usable code without having some sample DDL and data, as well as a sample of the desired result. Check the first link...

Very nice Paul. A good primer for the millions of simple database conversions out there.

Random note:

Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency...

brandonmooreis (1/14/2011)

---

I've had this discussion with the lead programmer at work about how we need to start creating our database with scripts instead of deploying an actual database, and then...