Topics
Started by
Posts
Last post
Hi, I'd like to have a go at pivoting this small dataset to start with before applying to a larger …
5 replies
Hello I have the following query which runs considerably slower when we change the isolation level …
14 replies
Is there a way to get sys.dm_exec_query_stats These below in minutes or more readable time? ,max_…
3 replies
Hi All, I am a newbie.Recently i came across a code as follow Select something from Handset h Inner…
4 replies
Hi All, I have a table (unfortunately the front application is from a third party so the table cann…
2 replies
Hi Everyone, I have a huge stored procedure in which I have one main table and lots of left joins w…
3 replies
I want to make a Stored Procedure to create a database with a dynamic name. In that SP I have to cr…
7 replies
I am not sure exactly how to phrase what I am asking so thanks for looking and I will try to clarif…
5 replies
This is a really odd issue!! A parameterised SP runs fine on my test database wth a certain set of …
47 replies
Hi All, I have a very small problem. I have two schema in my database. The default "dbo" and user c…
9 replies
I have table with 20k records. I want to delete 20k-1000 records from the table. i.e keep the top 1…
4 replies
Hi, i need query to update all the columns which ever carrying null to 'unknown' using a single que…
9 replies
Hi, I need some assistance with this regard. I am trying to figure out how i can Join a table to it…
11 replies
I would like to retain the data for change data capture log tables to 365 days. Please let me know …
2 replies
I have something out of order what is it I'm not sure, I want to reverse the field(s) Doe.John@Com…
35 replies
Viewing 15 topics - 4,711 through 4,725 (of 10,647 total)
You must be logged in to create new topics.