Topics
Started by
Posts
Last post
Hi, we have a query that copies data from one table to another. Sometimes we copy like 25000 record…
8 replies
i have a query like this: SELECT StartDate,R1,SUM(Total),ROW_NUMBER() OVER(ORDER BY StartDate ) AS…
6 replies
I am receiving the following message: "Transaction context in use by another session" I know what I…
2 replies
In SQL 2008 SSMS query window frequently I save my query results to file. In SQL 2000 QA I would ge…
9 replies
Hi, I have outline numbers such as I.A.1.b. I am trying to split them into a string as follows I., …
12 replies
Hi, I have 2 servers. 1 located at HO through LAN connection and 1 located at DR (around 100 KM). W…
1 replies
Hi all, I am trying to develop an new database for school Fee management system. I am not able to …
4 replies
I was just wondering if there is anyway that you know of to add 20 business days to a date field?
19 replies
I have code on an update trigger that sends an email when a record is changed. Is there an easy wa…
2 replies
I need to generate index ddl of an existing index. Where in the system views of the sql server 2008…
1 replies
Hi, I need to randomly select questions my database. i used the following query: …
35 replies
Hello, I apreciate if anyone can check the .xlsx that i've anexed on this post to answer to my "stu…
5 replies
Greetings all, I am using .net to perform a bulk insert. I am doing this by creating a bunch of emp…
2 replies
I'm having some issues with getting the TOP X records for a query that runs in 10 seconds without t…
4 replies
I use following query to rename a table DECLARE @RenameTableDetail varchar(50) SELECT @RenameTableD…
2 replies
Viewing 15 topics - 10,156 through 10,170 (of 10,647 total)
You must be logged in to create new topics.