Topics
Started by
Posts
Last post
Hi, I'm writing a script that moves data from one table to another. TableSource has lots of columns…
6 replies
Hi every one, here iam comparing two tables and want to delete the records from first table if ther…
4 replies
I am reviewing the existing TSQL code in a stored procedure. There are six tables that need to be u…
10 replies
Hi, I am trying a fix a database that is missing constrainsa and triggers that sould be present ac…
2 replies
We have a table that stores building and unit numbers in an apartment building. What I need to do i…
6 replies
I have a stored procedure and with in the stored procedure I have multiple select statements. When…
7 replies
HI all, Can anyone see an advantage to having a smalldatetime field(no time stored e.g 00:00:00) an…
5 replies
hi guys, i have a query with cumulative total. for the Column in a table, i need a Cumulative Total…
5 replies
Hi, One of the tables in the database got locked. when a select statement is issused, it shows that…
5 replies
select trans_Date,'MD' as org, case when rate_cat = 'INTER'then sum(trans_amt)*0.1 when rate_sub_ca…
1 replies
i am writing this SSIS and I need to pass a value to a varibale. SELECT Top (1) CASE ENCT_HDR_BATCH…
2 replies
SELECT CASE WHEN h.cloned_wrksht_indcr IS NULL THEN AVG(ABS(CAST(dbo.fn_workdays(h.job_execution_dt…
4 replies
I have a an issue were i want to check if specific characters or strings exist in a string based on…
6 replies
I have a set of data that gives me month name and year in this format: FiscalMonth July, 2008 Augus…
2 replies
i want to get a value from another database table. the db name should pass as a variable. i try wit…
3 replies
Viewing 15 topics - 8,926 through 8,940 (of 12,234 total)
You must be logged in to create new topics.