Recently Indexed Messages:-



T-SQL (SS2K8) :: Add Job Interval And Time To Script

Mar 18, 2014

I need to add the Job Interval and Time to the following script:

SELECT DISTINCT 'CYP_BI' AS Server,Jobs.Name AS Job_Name, Jobs.description AS Alias,
'Enabled' = CASE (Jobs.enabled)
WHEN 0 THEN 'No'
WHEN 1 THEN 'Yes'
ELSE '??'
END,

[Code] .....

This query contains the job interval and time but when I add it to the first script I can't get my syntax right:

SELECT DISTINCT
'CYP_BI' AS Server,
S.name AS JobName,
S.description AS Alias,
'ScheduleName' = left(ss.name,25),
'Enabled' = CASE (S.enabled)

[Code] .....

View 8 Replies

Data Access :: How To Load Data From CSV File In Temp Table At Run Time

May 28, 2015

how I can load the CSV file data into the sql server table. I know there are ways like bulk insert and other to load the csv file data into the table. But in my case the table doesn't exist and has to be created at the run time. With simple insert in temp table we do like select * into #temp from tablename and that creates the temp table. So. I need something like that which create the temp table and load the data into it. because the CSV file would have different number of columns and names so I can not create the table structure in advance. I have to create the table at run time. 

View 3 Replies

SQL Server 2012 :: Replace Multiple Values Without Looping

Jul 13, 2015

I need one query...

create table #task(TaskId bigint unique, Name varchar(2000))
insert into #task values(1, 'Text Text Text Text Text Text Text <<Name>> Text Text Text <<Salary>>')
insert into #task values(2, 'Text Text Text <<Name>> Text Text Text Text <<Company>> Text Text Text <<Salary>> Text Text Text')
-- select * from #task

[Code] ....

Now I need to create an inline function who resolve the task name with appropriate values and return me the resolved task name

select * from fn_TaskResolver(1, 'Text Text Text Text Text Text Text <<Name>> Text Text Text <<Salary>>')

I try this function but its return multiple rows as i just want to return one row. as I have big data set so i don't want to use scaler or Multi Line function.

create function fn_TaskResolver(@TaskId bigint, @name varchar(2000)
Return table
as
return
(
with data as

[Code] ....

View 7 Replies

Exporting Scheduled Report In Excel Format Via SSRS Subscription

Oct 1, 2014

I am currently exporting scheduled report in excel format via SSRS subscription and the report is getting deposited in 97-2003 (.xls)format. I am using SQL Server 2008 R2 version

Now i need to export the report in .XLSX format. What i need todo to upgrade the exporting excel version (i.e .XLS to .XLSX format ) as .XLXS version is only available from Excel 2007 and later version.

View 2 Replies

SQL 2012 :: Integration Services On Different Servers

Mar 26, 2015

I have installed SQL Server on Server A. I have installed Integration Services on Server B.I found that you need to addto the integrations services MsDtsSrvr.ini.xml file the server for the database if you want to use MSDB package store. The issue I have now is how do I execute the jobs on the Integration Server. I dont want them to execute on the SQL Server. Is there a way to configure the SQL Server Agent jobs to execute the package on the other server? Do you have to setup windows scheduled tasks or some other tool to execute command line packages on the IS server?

I'm looking for any info on segregating these roles but still using the MSDB store for pacakages. I don't want SQL server installed on the IS server or IS on the SQL Server. I want the Integration Services server to do all processing... not database level obviously but flat file reads, web service calls, data manipulaiton, custom code, etc and just pass the input/output of data to the SQL server for storage or retrieval to offload the workload and segregreate responsibilities.

View 1 Replies

Logs Are Getting Full?

Jul 17, 2014

I am db2 dba and in my environment we have ms sql server db. Sql dba is in leave .

Logs are getting full in below path . Can we remove the logs ? is it archive logs ?

Path : H:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLDATA

View 2 Replies

Integration Services :: How To Traverse Files Under Subfolder Using Folder Option

Apr 29, 2015

My files are stored as Newborn.txt under each year's subfolder, How to implement this.

Eg: C:RaviN90Newborn.txt
  C:RaviN91Newborn.txt
C:RaviN92Newborn.txt
C:RaviN93Newborn.txt

How to read the files using the for each loop container"

View 5 Replies

Analysis :: SSAS Time Period Dimension Aggregation

Jul 27, 2015

I have a monthly time period dimension representing average number of students for each month. At the yearly aggregate level I don't want it to sum up the avg number of students from every month because that number is incorrect. I would like it to use the number of students from the most recent month as a roll up. Is that possible to configure in SSAS?

View 2 Replies

SQL 2012 :: Inserting A Row With Multiple Counts

Sep 17, 2015

I am trying to insert into a row in SQL 2012 a default value for one column and then the results of some select count(*) queries into the other columns.Here is my example:

insert into x64_hourly_activity (Hour,Ingests,Restores,Proxies, Tape_Onsite, Tape_Offsite)
select (select count(*) from x64_Ingest_metrics_temp where datepart(hh, date2) = 00 and datepart(mi, date2) <= 59),
(select count(*) from x64_restore_metrics_all_temp where datepart(hh, date2) = 00 and datepart(mi, date2) <= 59),
(select count(*) from x64_proxy_metrics_raw_temp where datepart(hh, date2) = 00 and datepart(mi, date2) <= 59),
(select count(*) from x64_tape_metrics_temp where datepart(hh, date2) = 00 and datepart(mi, date2) <= 59 and Storage_Loc = 'XYZ'),
(select count(*) from x64_tape_metrics_temp where datepart(hh, date2) = 00 and datepart(mi, date2) <= 59 and Storage_loc = 'JKL')

What is the statement I use to insert 12AM as a value for Hour?

View 1 Replies

How To Extract Part Of A String In Column Results

Jul 21, 2015

I want to extract a number within a column results, that is the number between the first two commas

Example:
select path from tablea
results:
1158285,1158286,1158287,1158288,1158289
1158288,1158289,1158290,1158291,1158292
....

How to extract the second number(between the first two commas) from the above results?

The output should be

1158286
1158289

View 2 Replies

End Up With Only One Record For Each MRN

Mar 4, 2015

I need to end up with only one record for each MRN from the following query. This query returns one record for each problem that a patient has. I need to have one record for each MRN and a flag, marked 'x', for each problem that the patient has.

select MRN,
case when Problem='Congestive Heart Failure' then 'x' else '' end as 'CHF',
case when Problem='Chronic Obstructive Pulmonary Disease' then 'x' else '' end as 'COPD',
case when Problem='Chronic Renal Failure' then 'x' else '' end as 'CRF',
case when Problem='Coronary Artery Disease' then 'x' else '' end as 'CAD',

[code]...

View 2 Replies

Sub-queries Are Not Allowed

May 27, 2015

I want to pass the string "select @@servername" in the print statement, it throws error as:=

Msg 1046, Level 15, State 1, Line 3
Subqueries are not allowed in this context. Only scalar expressions are allowed.
Msg 1046, Level 15, State 1, Line 28
Subqueries are not allowed in this context. Only scalar expressions are allowed.

declare @account_name nvarchar(400) = 'Mail Account';
IF exists (select * from msdb.dbo.sysmail_account where name = @account_name)
PRint 'Database Mail Account ' + quotename (@account_name) + 'is already setup in the Server:= ' + (select @@servername);

I mean why such restriction? In such queries results will be only 1 so it does not violate the SET operation. correct??

View 3 Replies

Embedded Select Distinct Query

Feb 18, 2015

This is part of a query I have. I want to display the diagnosis code attached to a patient. Sometimes there are more than one which is why I have tried distinct. I am getting the message 'subquery returned more than 1 value...'

If I use MIN or MAX, its giving me the min possible diagnosis code alphabetically or the max, not the one actually assigned to the patient which is what I want.

(SELECT DISTINCT (Diagnosis.DiagnosisCode) FROM Diagnosis
LEFT OUTER JOIN CourseDiagnosis ON CourseDiagnosis.DiagnosisSer = Diagnosis.DiagnosisSer
LEFT JOIN Course ON Course.CourseSer = CourseDiagnosis.CourseSer
JOIN Patient ON Patient.PatientSer = Course.PatientSer
WHERE Diagnosis.ObjectStatus = 'Active' AND
Diagnosis.Description not like 'ERROR%' AND
Diagnosis.DiagnosisTableName not in ('RTDS Dates')),

View 10 Replies

Transact SQL :: Raw Excel File - Create Automated Insert Into DB

Sep 17, 2015

I have a raw excel file which I am trying to create an automated insert into a DB.

Data in excel file is two columns, Row_Data, Row_ID

I am trying to split rows and store them in columns in a table.

Row_ID column is simply row identifier column

E.g.:

Row_Data  Row ID
Frank          2
Seattle            3
WA           4
34     5
1010.00   6

How can i insert this data into a table where i`ll have columns of Name, City, State, Age and Amount?

View 18 Replies

SQL Server Admin 2014 :: Backup Of Indexes For A Particular Table?

Aug 9, 2014

how to take backup of indexes for a particular table.

View 1 Replies



Copyrights 2005-15 www.BigResource.com, All rights reserved