Topics
Started by
Posts
Last post
CREATE TABLE [ODS_Non_Rtl_Cr_Risk_Aggregation]( [EC_DRAWN] [numeric](18, 6) NULL, [EC_UNDRAWN] [n…
6 replies
sir, i try like below create procedure abc @sql varchar(100) as begin select * from [accomodation]…
4 replies
After thinking again and scratching my head decided to post in the forum My table structure looks l…
3 replies
Hi all: I am using change tracking with a few tables and I ran into a problem and wanted to know wh…
1 replies
Wanted to know where i am going wrong in this query DECLARE @Table TABLE ( FirstName NVARCHAR(255)…
6 replies
I have an audit table that has Inserts and Updates from a parent table. Unfortunately, we're not tr…
10 replies
I am trying to write a stored procedure that uses multiple linked servers. The issue is occasional…
1 replies
I have been asked to create a script to manipulate the database and set any nullable columns to nul…
9 replies
The below script returns this data set. RowOrgID StartDateEndDate 11219042/4/20086/1/2…
8 replies
accountno transaction amount date ========================================== A-123 …
22 replies
Hi Everyone, I have users profiles in a table in my database but some of them have wrong data. i.e,…
8 replies
I'm looking for a script that List all Foreign Keys for a Table. I had a few but I can't locate the…
10 replies
Hi, Can some one tel me how can I display current week number in SQL? I need to use this function i…
12 replies
Hello, I compressed a table XYZ in Sql Server 2008. Now i need to insert some thousands of rows fro…
4 replies
I have a table with two columns created date and mofified date. I have a condition like 1. When the…
6 replies
Viewing 15 topics - 5,491 through 5,505 (of 10,635 total)
You must be logged in to create new topics.