Viewing 15 posts - 4,606 through 4,620 (of 8,753 total)
algytaylor (9/7/2015)
PHP has been printing out the following error when I try to connect to SQLServer 2008 RC2:
Fatal error: Uncaught exception 'PDOException' with...
September 7, 2015 at 11:14 pm
One can truly argue that science is probably the greatest invention but in the adoption of scientific methods in the software industry it has somehow gotten lost in translation. Hypothesis...
September 7, 2015 at 11:11 pm
keng_mkt (9/7/2015)
In Command line tab/FILE "\"C:\Users\Administrator\Documents\Visual Studio 2010\Projects\SSIS_KENG_TEST4_86_TO_21\SSIS_KENG_TEST4_86_TO_21\Package.dtsx\"" /DECRYPT /CHECKPOINTING OFF /REPORTING E
Quick question, can the SQL Server Agent access the Administrator's home directory?
😎
September 7, 2015 at 10:52 pm
Piling on Andrew's and Ed's good answers: avoid using functions on the columns in the where clause if possible and all the alternatives forms of that, such as function in...
September 7, 2015 at 10:38 pm
Quick suggestion, use N'' prefix, then the SQL Server automatically uses UTF-16
😎
USE tempdb;
GO
SET NOCOUNT ON;
IF OBJECT_ID(N'dbo.TABLE1') IS NOT NULL DROP TABLE dbo.TABLE1;
CREATE TABLE dbo.TABLE1
(
XXXX varchar(255) NULL
...
September 7, 2015 at 11:37 am
maddukuru.rambabu (9/6/2015)
Hi All,Please find attachment which contains screenshot of Error
Please Help me.
If you are trying to overwrite the existing database then use WITH REPLACE (options tab in the restore database...
September 7, 2015 at 1:19 am
Post the full configuration for the agent job.
😎
September 6, 2015 at 11:53 pm
Carlo Romagnano (9/1/2015)
declare @sql nvarchar(max) = 'select 0 as dbid,0 as fileid WHERE 0=1'
UNION ALL SELECT '''+RIGHT(database_id,10)+''',fileid FROM...
September 6, 2015 at 10:13 pm
g7u (9/6/2015)
I really can't thank you enough. Thank you for the superb help and explanation. This was stumping me for quite some time.
You are very welcome and thank...
September 6, 2015 at 9:19 am
g7u (9/6/2015)
One more question...If I wanted to get a DATEDIFF between the two Dates, how would I accomplish that? Many thanks.
Simply add it to the last part of the...
September 6, 2015 at 8:10 am
Here is the code again with comments, let me know if you need further explanation.
😎
/* CTE (Common Table Expression for marking the sessions in
chronological order, creating an...
September 6, 2015 at 8:07 am
Quick solution
😎
USE tempdb;
GO
SET NOCOUNT ON;
GO
DECLARE @SAMPLE_DATA TABLE
(
[action] VARCHAR(10) NOT NULL
,[date] DATE ...
September 6, 2015 at 6:48 am
hegdesuchi (9/5/2015)
thank you very much. It does work.. But I have to repeat this scenario for 3 flags.. So I have to define CTE all three times.
Do we have...
September 6, 2015 at 1:32 am
QQ-485619 (9/5/2015)
I have a table with the follow row and sample data
RowID RecordType ...
September 5, 2015 at 4:46 pm
mar.ko (9/4/2015)
INSERT WITH SELECT HAS THIS:,Convert(Int,TARG_SALES) AS TARG_SALES
Treats the column as if it were formatted decimal !!
Looks more like a rounding trick in the insert, pretty certain the column's datatype...
September 5, 2015 at 8:25 am
Viewing 15 posts - 4,606 through 4,620 (of 8,753 total)