Forum Replies Created
Viewing 15 posts - 76 through 90 (of 337 total)
-
RE: Help finding a date
Hello guys,
As rightly pointed out by Chris the query I posted earlier were having some issues.Please see refined one.
DECLARE @duration INT=20;
WITH cte
AS (SELECT TOP 1...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server -
RE: Microsoft.Jet
"External table is not in the expected format." typically occurs when trying to use an Excel 2007 file with a connection string that uses: Microsoft.Jet.OLEDB.4.0 and Extended Properties=Excel 8.0
http://stackoverflow.com/questions/1139390/excel-external-table-is-not-in-the-expected-format
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server -
RE: Microsoft.Jet
Is it on the same machine where the SQL instance installed against which you are running the query ?
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server -
RE: Microsoft.Jet
I think the problem must be with the access to network path
Database=\\192.168.1.20\upload\data.xls
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server -
RE: Help finding a date
ChrisM@Work (6/24/2014)
With a duration of 20, this returns an incorrect timeslot (2014-06-23 08:30:00.000 - 2014-06-23 09:15:00.000)No it returns
(2014-06-23 09:15:00.0002014-06-23 10:00:00.000)
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server -
RE: Update Part of a SQL field with charindex
You can, but I wouldn't recommend it:
declare @str as table( val varchar(20))insert @str select '12-FLA-2-02'
insert @str select '12-FLA-2-12'
declare @update varchar(20)='11111'
select * from @str
update @str set val=replace(val,LEFT(val, CHARINDEX('-', val)-1) ,@update)
select *...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server -
RE: Update Part of a SQL field with charindex
You can use REPLACE function as well.
declare @str as table( val varchar(20))insert @str
select '12-FLA-2-02'
declare @update varchar(20)='11111'
select * from @str
update @str set val=replace(val,LEFT(val, CHARINDEX('-', val)-1) ,@update)
select * from @str
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server -
RE: Help finding a date
The query is purely based on the sample data provided and all the assumptions stated in the earlier posts.
See if this helps.
DECLARE @duration INT=70SELECT TOP 1 time_sched_start_dt,
...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server -
RE: Case Where Clause for Datetime from Varchar field
In what format are the dates stored in the table ? Can you please post some sample data ?
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server -
RE: The provider ran out of memory.
Try setting up as "Outprocess"
To connect to Microsoft Access, SQL Server must start the Microsoft Access Database Engine. Unlike most other providers, Microsoft Access is not a light-weight provider, but...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server -
RE: Running total error
Is the output for RunningTotal right based on the sample data you have provided ? If not then what it should be ?
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server -
RE: The provider ran out of memory.
What is the value of physical memory allocated to sql instance set to ?I think not enough memory(VAS) is available for the linked server.
How big is the Excel data ?
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server -
RE: The provider ran out of memory.
Is AWE enabled for your server ?
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server -
RE: The provider ran out of memory.
Is your SQL Server also a 32 bit ?If yes then it looks like the linked server has no memory available to pull the data.
How much memory does your server...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server -
RE: Copy Rows Based on Value
Not exactly a tally table as mister.magoo mentioned but somewhat equivalent.
create table #t(person varchar(100),id1 int,id2 int,id3 int)insert #t
select 'Person1', 10, 15, 5 union
select 'Person2', 14,14,0 union
select 'Person3', 20,21,1
select person,id1,id2,isnull(T.number,0)+id1 id3
from...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
Viewing 15 posts - 76 through 90 (of 337 total)