LOOPING a Delete Store Procedure - Hi, I have the Following SP that will be sending the data to archive data before deleting data from tables, I'm...
Running total for previous 7 values where there is a 1 - Hi I need a flag to tell me there is 7 1s in a row per site This would class as...
SSIS Error When Executing Package in SSMS - Hi, I have a system that previously ran on SQL Server 2008. However, with our latest version upgrade we are now...
De-Identification of PHI Data - The company that I work for deal with PHI Data and wanted to get other opinions on De-Indentifying this kind...
SQL: HOW to concatenate two fields using trigger, - Hi All, I have SQL database called “S1”, and a table called “WORKORDER”, inside the table, I have two field...
SQL Installation from CommandLine - Hello I am trying to perform SQL installation from command prompt I have created below 3 folders in D:\Patches\ 1)Setup -> contains SQL...
Transaction replication is looks not working. - Hi, I Just joined to company and give me to bunch of SQL Servers to do admin. I noticed there is...
Extract sp_execute value to a variable to compare - Hello, I want to take the sp_executesql results to a variable to further compare the results. Please suggest how to do it. [code...
Connection string associated with an SSMS *.sql file - I have a project setup in SSMS with several *.sql files, each of which attempt to connect to an instance when...
General advice needed - database design - Is this a bad way to design a pricing table? - Suppose we are selling bottles of water that can be bought in sizes of 1 to 10 litres (1, 2,...
Convert integer to date - Hello, In a flat file source (that comes from a Microsoft publishing "Training Kit - Implementing a Data Warehouse with Microsoft SQL...
How to calculate cost of flight and hotel and transfer per every program ? - How to design database for tourism company to calculate cost of flight and hotel per every program tour based on...
query similar to the 'where column in' but i need all matching items... - I know it has probably been asked and answered but i am not sure how to search for it. Currently using...
Total column in SQL Dynamic Pivot - I have used normal SQL pivot queries before but realised I needed dynamically created one for this piece of work,...
Using comma delimited value for a lookup into table - I had found SQL code previously that would let me use a comma delimited value in one table to return...
How does a stored procedure takes 15 seconds to start? - The trace attached shows a stored procedure calling another stored procedure. The statement calling the inner procedure takes 18 seconds while...
What's the best way to get a sample set of a big table without primary key? - This is what is happening here: We have lots of big data, table's size is often around billion and there is...
Running total for previous 7 rows - Hi I need a flag to tell me there is 7 1s in a row per site This woud class as...
How much memory does SQL server Really need? - Hi All, How do we know how much memory does
CPU troubleshooting with Perfom counters - I have put 2 PERFMON counters to troubleshoot high CPU utilization due to SQL server 2008 on a windows host...
