Topics
Started by
Posts
Last post
What is wrong with the following Statement? update #tmpTotals set StateCount = (Select ISNULL Sum(…
28 replies
Hi , I am using following sql to extract locking information in database. It only work on current s…
3 replies
OK, I'm having a brain freeze today because I SHOULD know this but I can't even think of the soluti…
4 replies
Hi All, I have a table called country that will store all the country related details in it. Below …
5 replies
Hi, I am looking for the fastest way to strip non-numeric characters from a string. I have a user …
21 replies
I have table like this : declare @tt table ( TagId int, TagType int, ReportId int) INSERT …
7 replies
Hello people, this might be very simple but I'm having a hard time trying to get this to work: I ha…
9 replies
Hi, I need one query help let me explain my issue create table #task(TaskId bigint unique, Name var…
7 replies
Hi Team, I have a table with column "Data" as VARCHAR, with entries like below. 1 11 2 A1 A10 A11 …
21 replies
Consider the following data: create table #test (id int ,color varchar(20) ) insert into #test (id,…
9 replies
Having issues with this query. I'm thinking it could be simplified with OVER/PARTITION somehow, but…
4 replies
I have a problem that requires me to write Daily sum aggregation script, I wrote the script; But wh…
3 replies
Hi I have a code I wrote and I'm required to get Product Name and Quantity with the maximum quantit…
2 replies
Hi all, I need to evaluate the records to: 1. Find persons who have >=3 months of consecutive d…
5 replies
Hi I have a requirement where i have to insert empty string in column whose datatype is decimal. I …
3 replies
Viewing 15 topics - 3,001 through 3,015 (of 4,984 total)
You must be logged in to create new topics.