Topics
Started by
Posts
Last post
Hello Everyone I am in need of help with creating a query that will work. I am not having any luck …
3 replies
Hello All, I have a table of staff members with a home, cell, and alternate phone numbers. Each pho…
11 replies
I'm having a problem with a simple Scalar UDF. CREATE FUNCTION udf_ConvertDB2toSQL RETURNS DateTim…
20 replies
Hello all, I was trying to figure out a way to write this code using a cte, Could someone help me w…
15 replies
I have an app where I need to design tables around the concept of a "team". I'm not real sure how t…
8 replies
Hello My Table Structure is Id Sunday Monday Tuesday Wednesday Thursday Friday now i want to write…
5 replies
Sample data User Action DateTime Smith inserted 22/7/2010 8:33 Andy inserted 22/7/2010 9…
1 replies
Sample data User Action DateTime Smith inserted 22/7/2010 8:33 Andy inserted …
1 replies
Hi, I have a data file and the structure of it looks like below (H-for header, D-for Data and T-for…
3 replies
Hello All, I have a query like this select [ACCOUNT_NUMBER] ,[End_Date] ,[LDC_Accoun…
9 replies
CREATE TRIGGER tr_1 ON dbo.mytablename AFTER UPDATE,INSERT AS INSERT INTO table1(col1) SELECT InsRe…
5 replies
I tried function top 80 percent i sorted desd, but it still get some unwanted records. 6020% 5…
12 replies
I have the following fields in my table. UserName DateTime Action abc 22/1/2011 …
2 replies
I have got a column with data like 12345 0047225P1 I need a query to select 0047225 as serial numb…
8 replies
Hey all, got an odd issue we've been working to track down. Here's the summary, followed by some su…
5 replies
Viewing 15 topics - 6,871 through 6,885 (of 10,647 total)
You must be logged in to create new topics.