Viewing 15 posts - 3,211 through 3,225 (of 8,761 total)
Kingston Dhasian (9/14/2016)
How would somebody respond to this? The last statement of the OP is a cruel joke.http://www.sqlservercentral.com/Forums/Topic1817507-3739-1.aspx
Makes you wonder what the purpose is and English certainly not being OP's...
September 14, 2016 at 3:48 am
ChrisM@Work (9/14/2016)
You could get someone up the duff with all that stuffing 🙂
It's the Right Stuff:-D
😎
September 14, 2016 at 2:03 am
Quick suggestion
😎
BTW DON'T USE the FORMAT function!
USE TEEST;
GO
SET NOCOUNT ON;
DECLARE @LINE_TEMPLATE VARCHAR(50) = '000000000 ...
September 14, 2016 at 1:51 am
Jeff Moden (9/14/2016)
September 14, 2016 at 12:20 am
SQL-DBA-01 (9/13/2016)
So you are suggesting to extract all the login accounts in the SQL Instance and there if the name matches or present can shed that off?
That is normally the...
September 13, 2016 at 3:39 pm
Slightly different syntax but same results (and identical execution plan)
😎
SELECT
E.id
,X.STATE
,X.VAL
FROM #Example E
CROSS APPLY
(
SELECT...
September 13, 2016 at 3:32 pm
SQL-DBA-01 (9/13/2016)
If I need to find out an user account present anywehere in the SQL instances (say, login, jobs, repl agents, db owners, AlwaysOn groups), how to find and...
September 13, 2016 at 3:21 pm
Further on Jeff's fine answer, here is an alternative which should work if you cannot store the numbers generated, I have used this method to generate 10^10 rows without any...
September 13, 2016 at 1:34 pm
latitiacasta (9/13/2016)
Thanks Eirikur Eiriksson, i will try from my side first if i stuck anywhere will raise it 🙂
You are very welcome.
😎
If you have any problems just post it on...
September 13, 2016 at 3:30 am
Whether you use a 3rd party tool or not the challenge is the same, the columns must be manually mapped to elements within the XML as the element names differ...
September 13, 2016 at 2:26 am
Quick thought, alias the table in the select
😎
BEGIN
--INSERT row OF CURRENT emp
INSERT INTO [dbo].[EMP]
([empid] ,[fname] ,[lname] ,[dept] ,[active] ,[ext] ,[date_effective])
SELECT
EE.empid
...
September 12, 2016 at 10:27 am
Quick thought, if you execute a script like you posted then it will run sequentially. To execute in parallel then simply have one task for each statement on the same...
September 12, 2016 at 10:16 am
Quick question, any scalar or multi statement table valued functions in the 3rd party code?
😎
September 12, 2016 at 10:12 am
Here is a quick suggestion for a query to create the desired XML output
😎
USE TEEST;
GO
SET NOCOUNT ON;
IF OBJECT_ID(N'dbo.SSIS_TblImageViewerXML') IS NOT NULL DROP TABLE dbo.SSIS_TblImageViewerXML;
CREATE TABLE [dbo].[SSIS_TblImageViewerXML]
(
[StackNumber]...
September 11, 2016 at 4:53 am
Here is my ailing old work station
😎
OS Name Microsoft Windows 10 Enterprise
Version ...
September 10, 2016 at 9:15 am
Viewing 15 posts - 3,211 through 3,225 (of 8,761 total)