Topics
Started by
Posts
Last post
I cannot figure out how to add columns or ordering to my query which has a Rollup without it changi…
3 replies
I need a query that will produce rows of dates given a starting date and incrementing that date for…
3 replies
hi i want to insert 1000 rows in a table without any loop. how can i do it?
9 replies
DECLARE @RNum int DECLARE @DDate datetime DECLARE @MaxBolTime int DECLARE @GGallons numeric (14…
6 replies
I have a web application where the users will be entering time based on the different time zones th…
8 replies
Hi Team, I am working setting up CDC for a table on a database and i understand that we need to cha…
2 replies
hi friends, I need to create a server trigger to automatically map a login to a new database and ma…
7 replies
Hi, I had written the lines of code as Cast(SUM(A*B) / SUM(C) AS DECIMAL(30,5)) and Cast(SUM(A*B) …
11 replies
I have this query where I'm trying to get data into Test.csv from table TableName where ColA has va…
4 replies
Hi, I wanted to take the back up of a single table and put that table on other server. So i followe…
5 replies
Is there a way to open EDI file in SQL Server and insert the data into tables? Thanks.
1 replies
Hi.. I have data the data in the below temp table(SQL query) IF object_id('TempDB..#tTemp1') IS NOT…
4 replies
Dear Members, [font="Courier New"]SELECT a.name, b.type, MAX(b.backup_finish_date) LastSuccessfulBa…
10 replies
Hi, I have been asked to see if our new database system is up to handling a high load and need to …
4 replies
Hi friends, I have created temp table with row_number() since i need the latest loanumber with step…
3 replies
Viewing 15 topics - 5,086 through 5,100 (of 10,647 total)
You must be logged in to create new topics.