Welcome to the **Microsoft SQL Server** Forums at SQLTeam.com

44

Can you try something for me?

It's seeing the @variable in your TSQL and thinking it is a user mention. After you get the error, can you try putting that into formatted text? If that works I'll see about updating the posting guidelines. If not, I'll file a bug.

1 Like
45

I found my error. In my topic, I did not use the tag code for the snippet I was writing.
This error message --> Sorry, new users can only mention 2 users in a post.
It was no relevant to me.

One more thing, why do I always receive email from this forum duplicated?

Thanks!
N.B.: Great looking web tool.

46

I'm late to the party and offended that my post count and profile moniker didn't transfer! Fortunately I know people "on the inside"

47

Forums look nice Graz, it's been a while.

48

Everyone is probably offended their post count didn't transfer. I'm lazy. :yak:

49

hey bill, any section for mssql pdw?

50

Nothing specific at this point. Let's just put anything in the SSAS,SSRS category and we can tag it as PDW. I'll see abou updating the description.

51

Hi Bill,

Nice work! It's good to see ravishing new look for SQLTeam, except post count.

What is the link for the old read-only sqlteam forums which where I can see my posts?

Thanks.

52

Hey, great to hear from you. It should be at www.sqlteam.com/forums/.

53

Thanks Bill.

54

I can never find where the how to faq are.

55

Dear Sir,
I need to get output in text file from mssql

This is the format which I have raised from website of ICEGATE EDI format
ICEGATE Header:
HREC^]ZZ^]^]ZZ^]^]^]^] ^]^]^]^]
Example:
HREC^]ZZ^]ABCD^]ZZ^]XYZ^]ICES1_5^]P^]^]COCHE01^]123456^]20071015^]1015

Pont 1 : When I open the Output in Notepad I get in this manner without any spaces in between
--------------------------------------------------Point 1------------------------------
HRECZZAAACF2188HZZINNSA1ICES1_5TSACHI011201512080959

Point 2 : When I open the Output in Word pad I get in this manner with spaces in between
--------------------------------------------------Point 2------------------------------
HREC ZZ AAACF2188H ZZ INNSA1 ICES1_5 T SACHI01 1 20151208 0959

Point 3 : When I open the Output in Notepad++ I get in this manner with GS where space shown ie Group Separater

How can I handle this via syntax in MSSQL

56

I'm unclear if you want to query a database and output that format to a file. If that's not the case, then please explain in more detail.

You can use SSIS, export wizard or bcp to get that output, just use ^] as the column terminator.

If you want to do it in TSQL, you would build it by concatenating ^] to each column.

1 Like
59

How can SQL Server instances be hidden?

60

hey guys im having a problem with my query
select idmedicament,dateExpiration from stock where (SELECT DATEDIFF(day,dateExpiration,getdate()) FROM stock )>=21

but bring me this error below
Msg 512, Level 16, State 1, Line 13
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

please help me because is an academic project

62

Looks nice!
Hopefully my post count will migrate and no one else's! :slight_smile:

63

Thanks for sharing you saved my day

64

This is a new and exciting start for me. I'm sure, I will learn a lot.

66

Sorry, new users can only put 2 links in a post.

What's that supposed to mean? I've been browsing the forums!!!!

67

Hi there, I just have a minor problem, which is since I update my laptop to Window 11, it quite lagged. How can I fixed it now?