Viewing 15 posts - 4,906 through 4,920 (of 13,872 total)
November 14, 2017 at 10:34 am
DECLARE @ID INT
DECLARE @CODE VARCHAR(15)
DECLARE @BOOK VARCHAR(15)
DECLARE @DATE DATE
DECLARE @ORDER VARCHAR(25)
DECLARE @COUNTER SMALLINT
DECLARE @FETCH_STATUS...
November 14, 2017 at 8:30 am
Can you confirm that the SQL instance has been restarted since it was switched to mixed mode?
November 14, 2017 at 8:17 am
November 14, 2017 at 6:23 am
November 13, 2017 at 10:53 am
Idera's Rapid SQL may be of interest to some people here, despite the fact that their definition of "all major RDBMSs" seems to be a little light.
November 13, 2017 at 8:49 am
November 13, 2017 at 7:33 am
November 13, 2017 at 5:40 am
A general observation: CASE expressions do not 'bring anything in', nor do they 'take anything out'.
If your query works fine without joining to a CTE but results in duplicates...
November 12, 2017 at 6:02 am
Because of user constraints, I cannot follow through with your stored procedures suggestion.
I tried...
November 10, 2017 at 1:57 pm
Thank you for your contribution, but no matter what variation of your code I try,...
November 10, 2017 at 1:42 pm
I have two tables tblData2017 and tblData2018...
November 10, 2017 at 1:21 pm
Sub ClickButton()
Dim SQL As ADODB.Command
Set...
November 10, 2017 at 1:09 pm
leavesandmusic - Friday, November 10, 2017 11:31 AMI would like only one column: for example,Dim arr As Variant
arr = Sheets("Sheet1").Range("E3:E20").Value
Have you...
November 10, 2017 at 11:46 am
Viewing 15 posts - 4,906 through 4,920 (of 13,872 total)