Topics
Started by
Posts
Last post
We have a new .net application that using entity framework. In the database, there are going to be …
25 replies
Hi All, I will try and explain as best I can. I have the following parameters for my sp: declare @…
10 replies
I have a trigger that looks like it should handle multiple rows in an update however we are getting…
7 replies
We have some scripts worked out by development for purging old unnecessary data but it's extremely …
53 replies
Hi to all, I have got a one column in table containing different Client ID's. There are 3000 rows i…
10 replies
I have this piece of code in my query , where the while loop is involved. It has some performance i…
16 replies
Hi I am looking to amend a fact table build job such that it disables indexes, builds the table the…
5 replies
I am STIGing a database and have to create a trigger that will stop any connection from occurring a…
6 replies
Hi i need to generate a XML file like this <Products> <product>item1</product> …
1 replies
I have a table that has over 1mil records. hers is an example of the table insurer claim_num…
13 replies
I have a requirement to expand a row in an Orders table into two rows based on columns of EnteredBy…
4 replies
Hello, I have 2 identical tables with almost identical data(Few field values will vary). Both tabl…
21 replies
Hi, I'm deploying some SSIS solutions to the SSIS catalog by the project deployment model. I'd like…
6 replies
I have the following t-sql 2012, which is the following: DECLARE @endYear varchar(04) = 2016 select…
3 replies
If a record does not exist in this table the update on "SomeTable" should work. When I debug I see…
9 replies
Viewing 15 topics - 2,326 through 2,340 (of 4,984 total)
You must be logged in to create new topics.