Topics
Started by
Posts
Last post
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
Hi - I am new to SQL express, can someone please guide me to how I can schedule a task to run trunc…
15 replies
CREATE TABLE #holding( [TIDM] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [CLIENT…
4 replies
hi all, many times when looking to graphical excution plans I see the operator "clustered index sca…
10 replies
Hi, I'm working on normalizing a small part of our DB, but having trouble building a particular que…
6 replies
pretty basic so appreciate the help here,getting conversion error , what is the way to have int var…
4 replies
Viewing 15 topics - 4,711 through 4,725 (of 10,636 total)
You must be logged in to create new topics.