Topics
Started by
Posts
Last post
Hi Team, I have setup management data ware house for data collection...server activty, queries and …
4 replies
Every weekday we receive a file which under normal circumstances gets processed by a SQL Job that r…
5 replies
Hi! The problem is simple, but the answer doesn't seem so... I'm trying to count the number of days…
7 replies
I wanted to get other's opinions as well as share my own. I just came across a pretty good product …
7 replies
Hello, I have the below query working properly by but very slow, the sub-query is the cause of slow…
3 replies
By: EdVassie
Hi all, I have an issue with one job in SSMS which uses some SSIS Package. I'm receiving the error …
1 replies
Hello my table CREATE TABLE #DETAIL ( IDR INT, ID INT, AMOUNT FLOAT, BALANC…
7 replies
Hello guys, I want to discuss about your experience what is better. for example. I have procedure …
22 replies
I am writing a stored procedure with optional variables, but am not sure the best way to represent …
5 replies
I am having trouble with a CASE statement like this. The All Cars doesn't work. SELECT CASE WHEN CA…
7 replies
Do you guys recommend upgrading SQL Server 2008 R2 to 2017 by just running the disc and uprading? O…
6 replies
What property value do I need to set so that the header row I created displays on subsequent pages?
17 replies
Hi All, I need to insert sp_spaceused output of DATABASE into temp table. How can I do this? Pls su…
13 replies
SELECT sqltext.TEXT FROM sys.dm_exec_query_stats AS CP CROSS APPLY sys.dm_exec_sql_text(sql_handle)…
3 replies
When I double click on a .sql file, it starts up SSMS and loads my file. When I click on a second …
16 replies
Viewing 15 topics - 31 through 45 (of 30,223 total)
You must be logged in to create new topics.