Topics
Started by
Posts
Last post
I want to update the field "ModifiedDate" in an audit table with the last (up) date (ModifiedDate) …
1 replies
How would you trim a string that looks like this? I need only the string between the first set of …
32 replies
help me with this code its not showind date declare @row1 datetime set @row1 = @fromYTD …
1 replies
hi i am executing udf as (select fGetGenericDate (@param)) which returns datetime as datatypeof …
2 replies
I have a request where I have to find the start and End statuses for a member. The requirement is …
4 replies
I've a procedure which insert data into a table from the join of two tables based on the search cri…
7 replies
Hi, I have two SELECT queries. They are the same, only the conditions in the WHERE clause different…
6 replies
I am trying to create two new columns,using a case statement of the same data. For example Select …
3 replies
hi i am having trouble in select stm select "heading1" = case when (condition) then item1 …
17 replies
Hi, Can i get sample code for hierarcial query in sql ser 2008.My Scenario is as follows: I have a …
3 replies
I have data that when grouped by 4 fields, and using a having clause, displays records that don't a…
4 replies
Can someone please help me out setting up primary and foreign key relationships. Here is my issue..…
14 replies
Hello All, Little stumped! Have a simple select stmt (SQL 2008): 1. Returns the correct result whe…
23 replies
Hello all, I've 2 separate sql servers, both 2008R2. On srv1 i created a link to linksrv in order t…
2 replies
I wonder if any of you helpful folks could suggest any alternatives to cursor for the following iss…
11 replies
Viewing 15 topics - 6,211 through 6,225 (of 10,635 total)
You must be logged in to create new topics.