Topics
Started by
Posts
Last post
Hello everyone, I have database with about 20 tables,and some of them must be populate automaticall…
2 replies
i have two database AgencyDB(primary DB) and AgencyBackupDB(Deleted Info from AgencyDB by user) and…
6 replies
Here Is My DDL Create Table #Tab1 ( Fileid int, FileName Varchar(10), FileType varchar(10) ) go in…
13 replies
CREATE TABLE #AmountOfTime ( DURATIONTIME ) INSERT INTO #AmountOfTime (DURATION ) VALUES…
12 replies
I need to GROUP products by category based on a product rate, but I'm having a hard time joining on…
6 replies
I am unable to understand how variables work: I have created this query that finds all the column n…
4 replies
Hello, I have a query where two tables are joined using a LEFT JOIN. This logical operation is bein…
2 replies
in my case, some source columns values are nulls, i want to populate "NULL" to "0" where isnull([co…
3 replies
OK, need a fast way to compare new data coming in to old data. Both are in seperate tables so we we…
12 replies
I have a column and the values are 0.01 0.2 0.0003 0.00004 0.5 I want output like this 1 2 3 4 5…
1 replies
Im running the following in a batch file sqlcmd -Q "exec dbo.MySproc" -S "MyServer" -d "MyDatabase"…
6 replies
I altered a sql script the other day to handle for a column containing NULLs. Basically, in the ca…
3 replies
Hi I’ve a CustomerActivity table that records all the activities of the consumers. I've create a si…
13 replies
Hi Guys, I'm designing a report in SSRS,I need to pull that from DB from previous Friday till the e…
5 replies
DECLARE @EmpID nvarchar(max) = ' ' DECLARE @sql nvarchar(max) SELECT @EmpID = @EmpID + '['+Convert…
1 replies
Viewing 15 topics - 3,631 through 3,645 (of 10,636 total)
You must be logged in to create new topics.