Viewing 15 posts - 3,676 through 3,690 (of 5,111 total)
That all depends on what your planning to do. If they're derived columns, then you could add these into the dataset or in the query. If it's filtering that's possible...
May 23, 2017 at 11:54 am
tarekj - Monday, May 22, 2017 7:43 AMThen what is the best practice to backup sql database to the cloud?
Uploading the files...
May 23, 2017 at 2:07 am
May 22, 2017 at 8:55 am
Sounds like the Login is set to a different language. You can check with the following sql (replacing the string with the real logins):USE master;
GO
SELECT...
May 22, 2017 at 7:36 am
tarekj - Monday, May 22, 2017 6:09 AMThis will copy the whole file every time I sync it which is 10 GB!
You'll...
May 22, 2017 at 6:31 am
Usable DDL & DLM:CREATE TABLE #Shift
(Eid int,
Shift_Start datetime,
Shift_End datetime);
GO
INSERT INTO #Shift
VALUES
(1,'20170522 20:00:00.000','20170523...
May 22, 2017 at 6:28 am
Considering that you didn't provide any DDL or DLM, this entire thing is guesswork. Personally, however, I'd strongly consider your database design. For example, why are there two tables for...
May 22, 2017 at 4:16 am
tarekj - Sunday, May 21, 2017 9:33 AMHow can I make automated sql differential backup onto onedrive?
I'm not sure there's a direct...
May 22, 2017 at 2:37 am
May 22, 2017 at 2:00 am
If they do contain NULLs then perhaps:=COUNT(Fields![Your Nullable Column].Value, "[Your dataset Name]")
May 19, 2017 at 6:20 am
May 19, 2017 at 5:44 am
solus - Friday, May 19, 2017 5:32 AMIve changed the varchar sizeALTER FUNCTION [dbo].[ConvertStringToTime]
(
@T VarChar(4)
)but im still getting null returned
For what values?...
May 19, 2017 at 5:39 am
You've declared @T as a varchar(1)(
@T VarChar
)
Edit:
This means most of your values will be truncated:'1300' -> '1'
'900' ...
May 19, 2017 at 5:13 am
Viewing 15 posts - 3,676 through 3,690 (of 5,111 total)