Technical Article

RE: Date Conversion

  • Reply

This is a cool date format function I found a while back.  See header comments for credits.../* ////////////////////////////////////////////////////////////////////////////////// Author: Rusty Hansen 8-21-2001 Description: Formats a date to a specific format. Parameters:      @dDate = A value or field of datatype datetime or a value or field that can be explicitly converted to               a datetime […]


Technical Article

RE: I need a replacement! (Chicago Suburbs)

  • Reply

Hi Josh Is this a consulting position or a permanent one ? Also would the company sponsor visa (H1 B) ? I have a Masters from Louisiana State University and am currently working on Sql Server Reporting Services/VB.NET and I have about 4 years of experience with Sql Server 2000. Dinakar


Technical Article

Reinstalling OS

  • Topic

Hi, I want to reinstall OS on one of the clustered nodes(Node1) since it is giving us problems. My question is how do we do this, Can we take node1 offline after moving all the resources to Node2 and than uninstall the OS and reinstall the OS and connect to the cluster. Is this possible? […]



Daily Coping 1 Dec 2022


Today’s coping tip is to discover your artistic side. Design a friendly greeting card....

New Database Job – The 6 Month Plan


So, we made it through our first 90 days, things start getting tougher now...

SQL Homework – December 2022 – What’s new in SQL Server?


SQL Server 2022 has been released! Long live SQL Server! No really, I’ve still...

Read the latest Blogs


Merge String into single string

By sabarishbabu

Hello Team, I have a input fields like below with fixed value separator (6) ...

How to get intellisense on CLR types in SQL Server Management Studio

By FirstByte

I created a CLR user defined type in C#/Visual Studio and added it to...

Display Top N values of a table with calculation next to it

By Soof1234

Hi, In Power BI Report Builder I need to use SSRS code for my...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers