Forum Replies Created
Viewing 15 posts - 6,571 through 6,585 (of 13,879 total)
-
RE: query and compare values in a text based column
Grant Fritchey (10/7/2016)
The example looks like either XML or JSON. Do you know where the data is coming from? It's fine that it's stored in a VARCHAR field, but if... -
RE: query and compare values in a text based column
niall5098 (10/7/2016)
HI There,it looks like sql but is actually text
XML, not SQL.
XML is text, but in structured format, with start and end 'tags' around data items.
-
RE: query and compare values in a text based column
niall5098 (10/7/2016)
thanks for the reply.the column contain a string of data. within that string I will see the following entries:
<new_pmetd_refno>4110</new_pmetd_refno> ...
-
RE: query and compare values in a text based column
niall5098 (10/7/2016)
HI There,as the heading suggests I am trying to query a text based audit for specific values then compare them values. For example the column should contain and new_ref_no...
-
RE: Help with dynamic join with case statement
Jeffery Williams (10/6/2016)
I will give it a try thank you. AND I don't have to count I just need to know if the result is greater than 0. Basically... -
RE: SQLdumps filling drive
psred (10/6/2016)
Is listing a stored procedure in all the text files. But what could be the problem with stored proc.You have been here long enough to realise that this is...
-
RE: SQLdumps filling drive
psred (10/6/2016)
Lot of SQL dumps filling C:\ and they are continuous SQLDump####.mdmp and .txt. It SQL 2014 SP1. Any suggestion how to resolve this.Read the text files, check the errorlog,...
-
RE: slower queries using linked server
Lynn Pettis (10/6/2016)
If you are accessing the tables on the linked server and doing all the work on the local server, you are pulling all the data across the network... -
RE: Are the posted questions getting worse?
Ed Wagner (10/6/2016)
Sean Lange (10/6/2016)
This may be the funniest thing I have seen in quite some time. You just gotta love 3rd party software.Yeah, that's a good one. Be...
-
RE: How to force column explicitly to string type before we export to excel
Eric M Russell (10/6/2016)
Jeff Moden (10/5/2016)
komal145 (10/5/2016)
i have check other tables and do lot of stuff to get this point . So , i have to do it in ssis.... -
RE: Export Integration Services Catalogs
SQL-DBA-01 (10/6/2016)
So need to use the same password whch are used for SSISDB ?The sensitive values cannot be retrieved, unless the user who originally saved the project opens it again.
-
RE: SSMS - Query History - Tool Recommendations
Redgate SQL Prompt and SSMSBoost both save a history of queries.
-
RE: Performance of system tables when loading views and procedures.
...uploading new versions of all the views and procedures...
Why are you doing this, out of interest?
-
RE: Export Integration Services Catalogs
SQL-DBA-01 (10/6/2016)
Hi Phil,While deploying getting the below Warning. But able to deploy the packages successfully. No error.
Is there something to look into against this warning?
TITLE: SQL Server Integration Services
------------------------------
Warning:...
-
RE: Export Integration Services Catalogs
SQL-DBA-01 (10/6/2016)
Hi Phil,It worked...:) I am able to import/deploy the .ispac packages. Thanks much.
If I need any further help from you on this will let you know.
Thanks much for your...
Viewing 15 posts - 6,571 through 6,585 (of 13,879 total)