Viewing 15 topics - 29,761 through 29,775 (of 284,197 total)
Topics
Started by
Posts
Last post
Hi Guys, I need help. I want to use a MERGE statement. The source and target tables are pretty big…
9 replies
HI All, I have an assignment, to Purging data, with conditions:1. Keep the full data 6 months (keep…
17 replies
Guys, I am adapting the below code and i understand what it is doing with the exception of the d, I…
3 replies
Hello to all I have a system that is getting 24 hours a days xml files to import. Each of these fil…
14 replies
Hello,I have the following basic sp to truncate a table... Create Procedure sp_Truncate_Address@DBN…
10 replies
Hi Experts, How can i accomplish this using case within select. Please see my sample below. se…
3 replies
I have a requirement to write an error to the Windows Event Log when the number of rows in a table …
9 replies
I have a stored procedure which uses CTE and a temp table. I want to store the results of this stor…
12 replies
Hi dbascan you tell me a quick way to check timestamp on multiple user databases in a S…
11 replies
Hello all. fairly new to SQL. but not that new.I have 3 stored procedures.The first one has a state…
9 replies
Hello , I dont think what im trying to do is possible but could someone advice on a correct way of …
5 replies
I am trying to associate the number value that has a description of SK to the previous rows up to t…
7 replies
Hello, I'm hoping someone can help with this please.I need to join the 2 below case statements into…
15 replies
Hi all. I'm configuring/testing some aspects of Resource Governor, and right now , i'm trying to se…
2 replies
I am working for a company that still uses Sql 2008 R2 and so i cant use Lead/Lag Functions. I know…
5 replies
Viewing 15 topics - 29,761 through 29,775 (of 284,197 total)