Topics
Started by
Posts
Last post
Warning: This should be seen as a puzzle and not as a solution to a problem. I use this type of puz…
6 replies
SELECT DISTINCT mv.meetID, mv.FundID, CASE WHEN vcv.vote IS NULL THEN mv…
7 replies
Hello, I have SQL Server 2008 Standard Edition installed on a Windows XP machine. I am trying to in…
1 replies
Hi I have a table with below data. Requirement is to replace all integers with continous 6 or more …
44 replies
Hi Everyone, Hope all is well. I was wondering if there is a way to determine when a new index was …
15 replies
I have a process that is blocking a lot of stuff on the server. The session id is "-2", which means…
7 replies
I have a rogue developer I need to stop. Bottom line. I work for a small company with several met…
5 replies
Is there any way to reduce this code?? SELECT N.insuredID ,CASE WHEN N.creditScore BETWEEN '0' …
7 replies
Hi, I have managed to successfully connect to another SQL Server instance using a linked server. I …
3 replies
Hello Guys, i got a requirement from business that they need pagination for an application. The st…
12 replies
Hello, I have a report that I want to render in different languages. Easy enough. However, the way …
4 replies
Is there a way I can remove the distinct statement from the Select statement and bring it down the …
3 replies
I'm baffled here and have no explanation for the devs. They have a numeric created as a type calle…
5 replies
Hi, I have a date column (not datetime) in SQL Server and the dates are in the format yyyy-mm-dd I …
7 replies
Hi, great forum first of all, i've been reading stuff here for awhile. I will say i'm not a DBA, wh…
2 replies
Viewing 15 topics - 3,241 through 3,255 (of 30,225 total)
You must be logged in to create new topics.