Topics
Started by
Posts
Last post
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
I have a table with @ 20 Million rows of data I want to truncate or delete. I don't need any of th…
47 replies
I have the following trigger: Create trigger [dbo].[new_Location] on [dbo].[TBL_LOCATIONS] for inse…
9 replies
When I copy/paste grid results from SQL Server Management Studio --> an Excel file, the WORD "NU…
48 replies
Hi, I have a requirement to change the date to 1900-01-01 if its an invalid date like 2009-13-31 (I…
12 replies
Hi Experts ! I have two select statements, in between select statement taking UNION ALL . I need to…
14 replies
Viewing 15 topics - 31 through 45 (of 30,223 total)
You must be logged in to create new topics.