Loading ...
Sorry, an error occurred while loading the content.

Topics List

CAST/CONVERT a screwed up field with one UPDATE statement

(3)
Convert them to type Varchar, then parse the strings into the number form you need then cast that to decimal. I know sucks but since it is a one time thing.
Myrddin Wyllt
3
posts
Apr 22

Fwd: Binary Conversion

(6)
John, Rhonda, It was a pleasant ‘gift’ to learn that you are both still around and hopefully, healthy. Good tidings and holly happidays to you too! Arnie
Ronda Pederson
6
posts
Dec 24, 2014

SQL Merge Dynamically

(1)
If anyone knows the answer we would love your help over at https://groups.yahoo.com/neo/groups/AspNetAnyQuestionIsOk/info Dear Group: We are developing a
Charles Carroll
1
post
Nov 11, 2014

Magic Numbers for NULL and Identity Fields

(6)
I have encountered sequences in Oracle and the headaches they can cause (and am glad I mainly work in the SQL Server side of the business). If they are so
Charles Carroll
6
posts
Aug 14, 2014

Better approach to Queries and Relationships design Question

(7)
Well actually bad design has a way of slowing things down as data grows, and never gets fixed. So I try to fix bad design where I see it - lack of
Charles Carroll
7
posts
Jun 26, 2014

Creating Computed Persisted column

(3)
Thanks Mark, that was of much help. Can you please share some stuff on this "WITH SCHEMABINDING" stuff? Any side effects it may cause of other queries using
Shadab Mustafa
3
posts
Jun 9, 2014

Simple Co-worker question on Drop Procedure and parameters

(1)
my co-worker was doing this: IF EXISTS (SELECT * FROM sys.objects WHERE type = 'P' AND name = 'Blah') DROP PROCEDURE 'Blah' GO I recommended extracting method
Charles Carroll
1
post
May 8, 2014

Anybody try these RedGate competitors?

(1)
http://www.xsql.com/ These look interesting. Tableau and Embarcadero Data Architect are my favorite high end Database tools at the moment but I am thinking
Charles Carroll
1
post
May 1, 2014

SQL Server Tools and DBMS Tools

(1)
http://www.sqlserverutilities.com/SQL-Server-Utilities-Free-SQL-Server-Tools-Software-and-Utilities-for-the-DBA-and-Developer.htm these are nice ones. Anybody
Charles Carroll
1
post
Apr 18, 2014

Free SQL Server 2014 book and new favorite data type

(2)
Finally! I've been waiting for this since 2003! Time to dig out my old code and wormhole, (drat! haven't cleaned out my closet for years) This data type was
Charles Carroll
2
posts
Apr 3, 2014

Combining 2 queries - correct Join or SubQuery sntax

(5)
Which Costco Arundel mills or? From: SQLQueriesNoCode@yahoogroups.com [mailto:SQLQueriesNoCode@yahoogroups.com] On Behalf Of Charles Carroll Sent: Wednesday,
Charles Carroll
5
posts
Mar 16, 2014

Decode answer with Temp Tables Yuck

(1)
I so wish I did not have to use an intermediate table for this.... Drop Table #UmbracoDocs; select DP.DocPageID As UmbracoDocs_ID
Charles Carroll
1
post
Mar 11, 2014

Base 64 to Text Cast Error

(12)
I am asking on this thread too: http://stackoverflow.com/questions/22331478/sql-server-text-field-casting-error-and-base64-decoding On Tue, Mar 11, 2014 at
Charles Carroll
12
posts
Mar 11, 2014

SQL Server 2012 Binary Text Field - convert to human readable HTML t

(8)
You’re welcome. --  Eric Kestler Sent with Airmail From: Charles Carroll seniorprogrammerguru@... Reply: sqlqueriesnocode@yahoogroups.com
Charles Carroll
8
posts
Feb 27, 2014

Anybody know any great "print all SQL Server Data to PDF" tools?

(3)
All set and happy. I withdraw the question. On Thu, Feb 20, 2014 at 1:17 PM, Charles Carroll
Charles Carroll
3
posts
Feb 20, 2014
View First Topic Go to View Last Topic
Loading 1 - 15 of total 1,043 topics